Tag Archives: dba

Video on Performance tuning memory allocation and spill issues

By | September 20, 2015

I was inspired by a recent article I read on parameter sniffing to add my own contribution to the topic, I explain how tempdb spools occur due to poor memory grants and they impact of parameter values in determining how much resources are allocated. I then go on to cover two different ways that the… Read More »

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 can now create nonclustered indexes on the Clustered Columnstore index

By | July 16, 2015

This post is to correct a mistake I made in my previous post on Updateable Non Clustered Columnstore index in SQL 2016; in that post I mentioned that Clustered Columnstore index doesn’t allow other indexes to be create on the table. This is true and false. Let me explain. If your using SSMS to create… Read More »

SQL 2016- Live Query Stats

By | July 16, 2015

I am a bit confused about this feature so I thought I would post about it to get feedback on its usage in SQL 2016. With SQL 2016 there is a feature called Live Query Stats being introduced. As its name suggests it provides details on the actual tasks being executed in real time. What… Read More »

SQL 2016- Activity monitor – Active Expensive Queries

By | July 13, 2015

Hurray L1 DBAs you now have an easier way to query active expensive queries. A new tab is added in activity monitor to show DBAs currently active queries. However I would still hope that everybody is familiar with using sys.dm_exec_requests Plenty of new option popping up all over Management Studio get exploring.

Fill Factor and Page split demonstrated

By | July 13, 2015

Recently on one of the popular SQL Forums I read a post by a DBA who seemed experienced but still had a poor understanding of fill factor and why it is important for SQL server. I’ve been asked this questions a number of times during trainings so here is a video hoping to show some… Read More »