Tag Archives: benefit

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 »

Clustered Index vs Unique Non Clustered Index, which is better performance while still maintaining integrity of the data?

By | April 5, 2015

At a training recently we were talking about improving ETL performance for a process that loads about 3 million rows. While the answer is typically to load the data after dropping the indexes, in this case they wanted to load the data with indexes since the data would then be needed to perform looks up… Read More »

Sometimes common sense takes a back seat to BI

By | March 9, 2015

This post has to do with how we sometimes loose the tree for the forest (no this is not a mistake), I had written a blog post sometime back about game theory and how it can help decide the outcome of certain business cases. I came across two instances in the last week where game… Read More »

Single Partition online rebuild in SQL 2014

By | January 16, 2015

If you have a large database then you probably have table partitioning implemented. While I have already blogged a lot about partitioning one feature that is really useful in SQL 2014 is the ability to rebuild an individual partition online. Previously for VLDB that contain partitions you either had to rebuild the index on the… Read More »

When does a machine become human? When they can Lie…

By | October 31, 2014

Don’t worry I am not talking of androids or cyborgs. I am talking about the classical definition used to determine artificial intelligence. The most widely used benchmark or at least the most well know is The Turing test: is a test of a machine’s ability to exhibit intelligent behavior equivalent to, or indistinguishable from, that of a human.  … Read More »