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

SQL SERVER – Save and Send Execution Plan Via Email

November 9, 2015

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

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…

Interview Question of the Week #021 – Difference Between Index Seek and Index Scan (Table Scan)

May 24, 2015

Pinal Dave

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

SQL Index

Question: What is the difference between Index Seek and Index Scan? Answer: Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table. Index Scan: Since a scan touches every row in the table whether or not it qualifies, the cost is proportional to the…