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

SQL SERVER – Quick Look at SQL Server Configuration for Performance Indications

January 14, 2011

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

Earlier I wrote SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine. That was the first article on the series of my real world experience of Performance Tuning experience. I have written second part the same series over here. Read second part over here: Quick…

SQL SERVER – DMV – sys.dm_exec_query_optimizer_info – Statistics of Optimizer

January 7, 2011

Pinal Dave

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

SQL DMV, SQL Scripts

Incredibly, SQL Server has so much information to share with us. Every single day, I am amazed with this SQL Server technology. Sometimes I find several interesting information by just querying few of the DMV. And when I present this info in front of my client during performance tuning consultancy, they are surprised…

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

January 6, 2011

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My association with SQL Server Magazine has been quite long, I have written nearly 7 to 8 SQL Server articles for the print magazine and it has been a…

SQL SERVER – Unused Index Script – Download

January 4, 2011

Pinal Dave

SQL Performance

SQL Download, SQL Index, SQL Scripts, SQL Server

Performance Tuning is quite interesting and Index plays a vital role in it. A proper index can improve the performance and a bad index can hamper the performance. Here is the script from my script bank, which I use to identify unused indexes on any database. Let us see script for unused index.

SQL SERVER – Missing Index Script – Download

January 3, 2011

Pinal Dave

SQL Performance

SQL Download, SQL Index, SQL Scripts, SQL Server

Performance Tuning is quite interesting and Index plays a vital role in it. A proper index can improve the performance and a bad index can hamper the performance. In this blog post we will discuss about Missing Index.

SQL SERVER – Plan Cache and Data Cache in Memory

December 28, 2010

Pinal Dave

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

SQL Memory, SQL Scripts

I get following question almost all the time when I go for consultations or training. I often end up providing the scripts to my clients and attendees. Instead of writing new blog post, today in this single blog post, I am going to cover both the script and going to…

SQL SERVER – Server Side Paging in SQL Server Denali – Part2

December 26, 2010

Pinal Dave

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

SQL Paging, SQL Scripts

The best part of the having blog is that SQL Community helps to keep it running with new ideas. Earlier I wrote about SQL SERVER – Server Side Paging in SQL Server Denali – A Better Alternative. A very popular article on that subject. I had used variables for “number…