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

SQLAuthority News – Microsoft SQL Server 2005/2008 Query Optimization and Performance Tuning Training

May 4, 2010

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

Last 3 days to register for the courses. This is one time offer with big discount. The deadline for the course registration is 5th May, 2010. There are two different courses are offered by Solid Quality Mentors 1) Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning – Pinal Dave…

SQL SERVER – GUID vs INT – Your Opinion

April 28, 2010

Pinal Dave

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

SQL Constraint and Keys, SQL Data Storage

I think the title is clear what I am going to write in your post. This is age old problem and I want to compile the list stating advantages and disadvantages of using GUID and INT as a Primary Key or Clustered Index or Both (the usual case). Let me…

SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – SQL and 10-11 May SharePoint

April 27, 2010

Pinal Dave

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

SQL Training

There were lots of request about providing more details for the blog post through email address specified in the article SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning. Here is the complete brochure of the course. There are…

SQL SERVER – Update Statistics are Sampled By Default

April 23, 2010

Pinal Dave

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

SQL Index, SQL Scripts, SQL Statistics

After reading my earlier post SQL SERVER – Create Primary Key with Specific Name when Creating Table on Statistics, I have received another question by a blog reader. The question is as follows: Question: Are the statistics sampled by default? Answer: Yes. The sampling rate can be specified by the…

SQL SERVER – When Are Statistics Updated – What Triggers Statistics to Update

April 21, 2010

Pinal Dave

SQL Performance

SQL Server, SQL Statistics

If you are an SQL Server Consultant/Trainer involved with Performance Tuning and Query Optimization, I am sure you have faced the following questions many times. When is statistics updated? What is the interval of Statistics update? What is the algorithm behind update statistics? These are the puzzling questions and more.

SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spatial Indexing

April 14, 2010

Pinal Dave

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

Spatial Database, SQL Index, SQLAuthority Author Visit

What is Spatial Database? A spatial database is a database that is optimized to store and query data related to objects in space, including points, lines and polygons. While typical databases can understand various numeric and character types of data, additional functionality needs to be added for databases to process…

SQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005

April 13, 2010

Pinal Dave

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

SQL Reports

This article was written as a response to T-SQL Tuesday #005 – Reporting. The three most important components of any computer and server are the CPU, Memory, and Hard disk specification. This post talks about how to get more details about these three most important components using the Management Data…