Tag Archives: Azure

SQL Server is an awesome product.

By | September 16, 2015

While I might seem biased in my choice of wording for the title, the fact is SQL Server is an awesome product. If you looking for actual numbers click here. MS SQL Server is the top OLTP and among the top DW RDBMS. More importantly you see that SQL server provide everything you need to… Read More »

Why I don’t have a lot of personal info on the internet- OLAP – BIGDATA and the future of privacy

By | July 19, 2015

I was asked this question while having a chat with a few friends. Mainly the complaint was I don’t have a lot of social media presence. The only real social media I follow is LinkedIn and that’s because it is mostly a Professional network. But more importantly, the reason why I don’t have a massive… Read More »

You might be a DBA if…

By | July 6, 2015

Was watching stand up on YouTube and remembered the “You might be a redneck if …” by Jeff Foxworthy here is my list for DBAs. You might be a DBA if ….. You wake up in the middle of the night screaming virtual IP addresses You might be a DBA if ….. You can’t remember… 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 »

Why I will never hire anybody for Tata?

By | April 7, 2015

Reaching a certain level of incompetence takes just as much commitment as being good at it. It’s like telling someone “you can’t mess this up even if you tried” and then being proven wrong. Case in point is the recent TataSky upgrade that happened all over India. By the CEOs admission Tata Sky has over… 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 »