I guess many of you are familiar with build in SQL server function @@version, which you can use to quickly tell what SKU of SQL Server and Windows OS you are using as well as build numbers. Perhaps you are also aware of serverproperty(param) function...

Hello, everyone! Today I am going to chat briefly about the question a co-worker asked me about. The problem was with embedding one XML snippet generated by using FOR XML option of the query into another XML also generated using FOR XML option. Here is...

While working with SQL Server you've probably heard certain restrictions like 'There can be at most 1,024 columns declared in the table' or 'There can be only 8,600 bytes per row'. Some are urban legends and travel by the word of mouth others are hard...

Some time ago I wrote a post how SQL Server optimizer keep track of what indexes maybe beneficial and logs this info into sys.dm_db_missing_index_* DMVs. Brent Ozar kindly pointed out that one can script 'CREATE INDEX' statement to build missing indexes...

With this post I will start writing some small TSQL coding patterns and tricks which make daily life of SQL Server database developer easier and are used a LOT when dealing with large databases. Data developers frequently have to update rows in tables...