Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – Win Surprise Gift at TechED 2011 Sessions – Wait Types and Extended Events

March 25, 2011

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

A quick note for all – If you are attending my TechEd sessions today here are few notes for you. Session Time Sessions Date: March 25, 2011 Understanding SQL Server Behavioral Pattern – SQL Server Extended Events Date and Time: March 25, 2011 12:00 PM to 01:00 PM SQL Server…

SQL SERVER – Tomorrow 2 Sessions on Performance Tuning at TechEd India 2011 – March 25, 2011

March 24, 2011

Pinal Dave

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

SQL Extended Events, SQL Wait Stats

Tomorrow is the third day of the TechED India 2011 at Bangalore. I will be speaking on two very interesting sessions. If you are developer, database administrator or just want to learn something new and interesting, I suggest you attend my two sessions tomorrow. Here is the details of the…

SQL SERVER – Denali – ObjectID in Negative – Local TempTable has Negative ObjectID

March 23, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table

I used to run the following script to generate random large results. However, when I ran this on Denali I noticed a very interesting behavior: SELECT o1.OBJECT_ID,o1.name, o2.OBJECT_ID, o2.name FROM sys.all_objects o1 CROSS JOIN sys.all_objects o2 I noticed lots of negative object_ID’s on Denali, whereas my experience on SQL Server…

SQLAuthority News – Solid Quality Journal – Importance of Statistics

March 22, 2011

Pinal Dave

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

SQL Scripts, SQL Statistics

My article on “Important of Statistics” has been published in Solid Quality Journal. Statistics are a key part of getting solid performance. In this article we will go over the basics of the statistics and various best practices related to Statistics. We will go over various frequently asked questions like…

SQL SERVER – SQL Server Migration Assistant (SSMA) – Tools – Video – Download

March 21, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Data Warehousing, SQL Documentation, SQL Download

I was recently working on learning various new stuff. I just would like to share very interesting resources here today. Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from any other data platform to SQL Server 2005, SQL Server…

SQL SERVER – 2012 – Zoom Query Editor

March 20, 2011

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio

SQL Server next version ‘Denali’ is coming up with very neat feature which can be used while presentations, group discussion or for people who prefers large fonts.

SQL SERVER – Log File Growing for Model Database – model Database Log File Grew Too Big

March 19, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts

After reading my earlier article SQL SERVER – master Database Log File Grew Too Big, I received an email recently from another reader asking why does the log file of model database grow every day when he is not carrying out any operation in the model database. As per the…