I just reviewed one more datetime enhanced feature provided by SQL Server 2011 CTP3 and it is FORMAT. It will return formatted value of specific format with DATETIME in query. It has three arguments, first argument is for the datetime, second is for fo...

I just reviewed one more datetime enhanced feature provided by SQL Server 2011 CTP3 and it is FORMAT. It will return formatted value of specific format with DATETIME in query. It has three arguments, first argument is for the datetime, second is for fo...

I just reviewed one more datetime enhanced feature provided by SQL Server 2011 CTP3 and it is FORMAT. It will return formatted value of specific format with DATETIME in query. It has three arguments, first argument is for the datetime, second is for fo...

This is a really good enhancement in CTP3 for Denali. I personally like that enhancement very much as i always in trouble with datetime formats in SQL Server. Thanks for sharing...

This is a really good enhancement in CTP3 for Denali. I personally like that enhancement very much as i always in trouble with datetime formats in SQL Server. Thanks for sharing...

This is a really good enhancement in CTP3 for Denali. I personally like that enhancement very much as i always in trouble with datetime formats in SQL Server. Thanks for sharing...

What if you want to find out if a specific field contains a certain value? For example you want to find out all employees who have 0 vacation hours and 0 sickhours. Common way is to write a where clause with 'or'. Another way to do this is to use 'in'

Today my colleague asked me a question, "how to find size of table only for certain rows?". My initial reply was "No. Its not possible". However, immediately sys.fn_PhysLocFormatter(%%Physloc%%) struck in my mind, which gives the page number. By findi...

Today my colleague asked me a question, "how to find size of table only for certain rows?". My initial reply was "No. Its not possible". However, immediately sys.fn_PhysLocFormatter(%%Physloc%%) struck in my mind, which gives the page number. By findi...

Today my colleague asked me a question, "how to find size of table only for certain rows?". My initial reply was "No. Its not possible". However, immediately sys.fn_PhysLocFormatter(%%Physloc%%) struck in my mind, which gives the page number. By findi...