SQL Performance Archives - Page 47 of 101 - SQL Authority with Pinal Dave

SQL SERVER – Performance counter missing! DMV sys.dm_os_performance_counters is Empty

January 16, 2016

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

The topic around performance tuning is the most sought out search on this blog. Almost every single day the top search that lands here are around performance or around some random errors one might receive from the application. If you are a DBA, the first high level tool that you…

SQL SERVER – Monitoring and Troubleshooting SQL Server Got Easy with Diagnostics Tool

January 6, 2016

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Idera

Blogging has never been an easy task. With close to 9 years of non-stop learning and sharing has got me into a rhythm that I rarely miss a single day without writing one. Over these years, there is one topic area that gets most number of hits based on subject.…

SQL Server 2016 – Enhancements with TempDB

December 30, 2015

Pinal Dave

SQL Performance

SQL Scripts, SQL Server, SQL Server 2016, SQL TempDB

SQL Server 2016 is loaded with tons of new enhancements that I can’t get enough of it. I have been playing around with the bits since multiple CTP’s and it is getting difficult to catch up on all the releases coming so fast and the number of enhancements from performance and scalability point of view have been too many to track. Let us see in this blog post Enhancements with TempDB in SQL Server 2016.

SQL SERVER 2016 – Comparing Execution Plans

November 28, 2015

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Execution Plan, MySQL

New tools bring new capabilities and sometimes these are ingrained deep into the product that we can easily miss them out. And SQL Server 2016 is no different. After installing the CTP, I was pleasantly surprised to see this addition to help our DBA’s who are doing performance tuning and…

SQL SERVER – Save and Send Execution Plan Via Email

November 9, 2015

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Here is an interesting question, I received the other day. Hi Pinal, I have a very big graphical execution plan and I want to send it to my friend. My first thought was to send him query to execute on his own machine, but he does not have the same…

Interview Question of the Week #039 – What is Included Column Index in SQL Server 2005 and Onwards?

October 4, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index

You may find it interesting that not many people still know what is Included Index in SQL Server. I have seen it personally around me and also have seen at Question: What is Included Column Index? Answer: In SQL Server 2005, the functionality of non-clustered indexes is extended by adding non-key…

SQL SERVER – Script: Finding queries without JOIN Predicates

August 26, 2015

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

I have been in developer’s shoes for close to 5+ years before reinventing myself to do things that made me even better in coding. It is a tough challenge these days being a developer. The life around you and the technology is changing so rapidly that we seldom get time…