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

SQL SERVER 2016 – Comparing Execution Plans

November 28, 2015

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

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…

SQL SERVER – How to Find If Queries are Running in Parallel?

July 25, 2015

Pinal Dave

SQL Performance

Parallel, SQL CPU, SQL Scripts, SQL Server

Let us learn today how to find if queries are running in Parallel? If a query runs in parallel it is a query that SQL Server thinks is expensive.

Interview Question of the Week #028 – Few SQL Best Practices

July 19, 2015

Pinal Dave

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

Best Practices

Just last week, I moderated a SQL Server interview and I heard very interesting conversation. Question – What are the best practices are you following for SQL Server? When I heard this question – I thought candidate will answer many different things, but he was stunned and had nothing much to…

SQL SERVER – Querying Performance Counters from SQL Server

July 14, 2015

Pinal Dave

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

SQL Scripts

Troubleshooting SQL Server is something almost every single DBA has to go through in their lifespan. It sounds simple and often we are clueless on where to start. Here is a scenario, you have been told that SQL Server is slow or unresponsive. Now you need to troubleshoot and figure…