Categories
General

Concatenation in SQL Server Denali Denali using CONCAT function

Microsoft introduced new function for string concatenation. CONCAT() is the function which is introduced in SQL Server Denali for concatenation which will take input and return the output as a single string.

Categories
General

DATETIMEOFFSETFROMPARTS function – SQL Server Denali

This function is also new to SQL Server denali however this function got some more arguments compared to DATETIMEFROMPARTS function. I’m not sure how frequently we will use this as it’s more precise to give you the values.  If the arguments are not valid then an error is raised or if the argument is NULL then it will return a NULL value.

Categories
General

DATETIMEFROMPARTS function – SQL Server Denali

This function is new to SQL Server denali to return datetime value from the input given. This function is similar to DATETIME2FROMPARTS  however here we don’t have fractions and precision argument instead we have milliseconds argument here.  If the arguments are not valid then an error is raised or if the argument is NULL then it will return a NULL value.

Categories
General

DATETIME2FROMPARTS function – SQL Server Denali

We have one more new date time function in Denali. DATETIME2FROMPARTS is the function name which is used to returns datetime2 value for the input value given.  If the arguments are not valid then an error is raised or if the argument is NULL then it will return a NULL value. This function is to precise, not sure how frequently we will use this function to get datetime2 value.

Categories
DBA

New DMV’s in SQL Server 2011 aka Denali

Denali CTP3 is already released and we have new DMV’s accompanied with this version which will be very useful for us. I’m going to cover the DMV that are all generic and not to a specific feature of Denali, I’ll will cover those DMV’s while writing article on that feature. There are around 8 DMV’s which I’m going to discuss it now.