Monthly Archives: June 2015

MS SQL Server and Tic Toc and why I changed my mind that it’s a good idea

By | June 26, 2015

I am not sure MS has got it right with the release cycle for SQL server. While this debate has happened before (I was then excited that there will be newer versions of SQL available sooner) now I am older and wiser. The reason I don’t think this approach will work in the long run… Read More »

NULL Management, SPARSE Columns, Vertical partitioning and a query

By | June 23, 2015

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 is not new to most seasoned DW developers it is often overlooked during the design phase and added at a later point in time mostly after testing… Read More »

Auto Update Statistics when does it occur

By | June 17, 2015

I was recently asked when does the actual Auto Update Stats trigger and while I know its during query compile I wasn’t exactly sure what the thresholds were so I did some RnD, the results are anyway well documented in the link in the references but I have still posted the results here because I… Read More »

TRACE FLAG 1118 – Proportional Filling and the tempdb

By | June 2, 2015

Often when conducting trainings I ask my participants not to take my word for it but try things out for themselves. I was asked a question about the TRACE FLAG 1118 during a recent training for SQL 2012 and wanted to bring attention to the discussion here. The participants had read in a blog that… Read More »