I came across a scenario, where I had to change the data in all the datatime columns with in a database. I made use of "xtype" column and wanted to share it. The system table which stores this information is systypes. [code] SELECT xtype, name FROM sys

The transaction log in SQL Server primarily performs sequential write operations in random sizes upto 60KB

When you copy or cut texts they are stored in the memory in the Clipboard ring. Pressing CTRL+V will give you the recently copied/cut message. If you want to have the history of the copies and get whichever you want out of them, use CTRL+SHIFT+V. This work

The technical information about VS11 is now available at http://msdn.microsoft.com/en-us/library/bb386063(VS.110).aspx. Any one interested can have a look. Thanks

Refer the second reply posted by russellb http://www.sqlmag.com/sponsoredblog/sql-server-questions-answered-28/sql-server/why-sql-server-lets-you-create-redundant-indexes-137128

It is explained here http://www.sqlmag.com/sponsoredblog/sql-server-questions-answered-28/sql-server/why-sql-server-lets-you-create-redundant-indexes-137128

These are still valid and the word test becomes alias name [code] select $+test select $+'test' select $+[test] [/code] But you can not replace $ with any other number to make them valid

Some of new features are listed below: 1. New Built-in functions(t-sql): -PARSE -TRY_CONVERT -TRY_PARSE -DATEFROMPARTS -DATETIME2FROMPARTS -DATETIMEFROMPARTS -DATETIMEOFFSETFROMPARTS -EOMONTH -SMALLDATETIMEFROMPARTS -TIMEFROMPARTS

In a select statement If you use the following query there is no error. [code] SELECT [Column1] [Column2] FROM table [/code] Notice the missing comma between the 2 column names above. In the output you get just the Column2 data and not Column1 Data. I tr

Nice tool for free online SQL query formating: http://www.dpriver.com/pp/sqlformat.htm One more is: http://sqlformat.appspot.com/