Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "denali"

0

SQL Server 2012 to be released Q1 2012

Ted Kummert, Senior VP, Business Platform Division announced at the PASS Summit 2011 Day One Keynote that the next version of SQL Server will be named SQL Server 2012
SQL Server 2012 will be released in Q1 2012

They are a variety of clients already…

Read More...
5

Microsoft SQL Server, codename “Denali”, will be the last release to support OLE DB, ODBC is the new new thing

According to the Microsoft SQLNCli team blog, SQL Server, codename “Denali”, will be the last release to support OLE DB.

Here is what they are currently saying

The next release of Microsoft SQL Server, codename “Denali”, will be the last release t…

Read More...
0

SQL Server Code Name “Denali” CTP3 Product Guide available for download

This is pretty cool and it is all in one place, the download is 456.0 MB

The SQL Server Code Name “Denali” CTP3 Product Guide includes useful resources and demos that will help IT Professionals better evaluate of CTP3. This includes:
- 14…

Read More...
0

TRY_CONVERT in SQL Server Denali CTP3

TRY_CONVERT is a new function in SQL Server Denali CTP3, TRY_CONVERT enables you to test if a value can be converted to a specific data type, TRY_CONVERT returns a value cast to the specified data type if the cast succeeds; otherwise, TRY_CONVERT…

Read More...
0

Format function in SQL Server Denali CTP3

SQL Server Denali CTP3 brings a couple of new functions, one of these is the FORMAT function

The syntax of the format function looks like this

FORMAT ( value, format [, culture ] )

Here is what Books On Line has to say about the arguments that…

Read More...
8

Concat function in SQL Server Denali CTP3

SQL Server Denali CTP3 brings a couple of new functions, one of these is the CONCAT function. The CONCAT function returns a string that is the result of concatenating two or more string values.

The syntax of the CONCAT function looks like this

CO…

Read More...
2

ColumnStore Index limitations in SQL Server Denali CTP3

If you have been working with Sybase IQ then you might be familiar with what a columnstore database is.

SQL Server has added a new type of index which is column based instead of row based, this is the columnstore index. I will create another post thi…

Read More...
5

DATEFROMPARTS and DATETIMEFROMPARTS functions in SQL Server Denali CTP3

Function

Syntax

Return value

Return data type

DATEFROMPARTS…

Read More...
5

A Quick look at the new EOMONTH function in SQL Server Denali CTP3

SQL Server Denali CTP3 has a bunch of new date/time functions like DATEFROMPARTS, DATETIMEFROMPARTS and EOMONTH

First let’s take a look at EOMONTH.

The syntax for EOMONTH is

EOMONTH ( start_date [, month_to_add ] )

If you pass in getdate()…

Read More...
7

A Quick look at the new IIF function in Denali CTP3

Denali CTP3 comes with the IIF function, if you have used VB or Excel then you already know how this function works. In essence this function is a shorter version of a CASE statement.

The syntax is as follows

IIF ( boolean_expression, true_value,…

Read More...
Next Page »