I love Full text search in MS SQL Server. Although I haven’t seen it being used a lot in client locations, I do use it a lot within […]
SQL 2016 – Stretch database in detail –CTP 2.3 screenshots with BOL corrected now
If you have been following the buzz around MS SQL 2016 you would surely have heard of Stretch database. The concept is interesting and new and probably something […]
administration / MSSQL / TSQL
Lock, Latches, Waits and Deadlocks explained weirdly (like never before)!!!
When conducting MS SQL Server Trainings I often resort to weird examples to explain how certain things work. Over the years I have some favorites that I use […]
Drawing a graph in SQL Server Management Studio
Had some spare time today so I used it to finally get around to a small project I had in mind. The intention is just to do it […]
NULL Management, SPARSE Columns, Vertical partitioning and a query
When discussing DW design I often take a lot of time to emphasize the impact Nulls have on query performance, aggregations, design, storage and much more. While this […]
Which is better Count (*) or Count (id)?
While conducting a training recently I was asked which is better Count(*) or Count(id) , while we wanted to discuss the topic further we didn’t have time so […]
It’s gorGEOus what you can do with this data type
Had some spare time on my hand today and created the company logo in the MS SQL Server Geometry datatypes. The Geography and Geometry datatypes are one the […]
Game Theory and Databases
CASE 1 Two members of a criminal gang are arrested and imprisoned. Each prisoner is in solitary confinement with no means of speaking to or exchanging messages with […]
administration / MSSQL / TSQL
sys.dm_exec_describe_first_result_set()
This DMV is probably one of the most useful DMVs for developers and Business intelligence users since it describes the data type and other columnar information of the […]
sys.dm_db_log_space_usage
Another DMV that is available in SQL server 2012 is the sys.dm_db_log_space_usage DMV, this DMV is useful when trying to decide the current state of the Log file. […]