Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – BI Quiz – Troubleshooting Cube Performance

June 6, 2011

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

My friend Jacob Sebastian runs SQL BI Quiz competition. Where there are 30 different questions on each day of the month. Winners get opportunity to participate in this Quiz, learn something new and win great awards. Working with huge data is very common when it is about Data Warehousing. It…

SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit – Download – May Update

June 5, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

I often receive the question what is the quickest way to learn SQL Server 2008 R2. Microsoft have published developers training kit which one can download and learn at your own pace, it has tutorials, videos, and hands-on lab which one can practice. This training kit has been published earlier…

SQLAuthority News – Download Pre-configured VHD – SQL Server 2008 R2 Standard on Windows Server 2008 R2 SP1 Standard

June 5, 2011

Pinal Dave

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

SQL Documentation, SQL Download

It is extremely simple to test out latest SQL Server 2008 R2. You can even get pre-configured ready to use VHD, which you can download and use it. This becomes very easy as one does not have to do anything besides downloading VHD and installing it on Hyper-V. Download Pre-configured…

SQL SERVER – Question to You – When to use Function and When to use Stored Procedure

June 4, 2011

Pinal Dave

SQL Interview Questions and Answers

SQL Function, SQL Server, SQL Stored Procedure

This week has been very interesting week. I have asked few questions to users and have received remarkable participation on the subject.
Q1) SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*)
Q2) SQL SERVER – Puzzle – Statistics are not Updated but are Created Once
Keeping the same spirit up, I am asking the third question over here.
Q3) When to use User Defined Function and when to use Stored Procedure in your development?

SQLAuthority News – Community Tech Days – TechEd on The Road – Ahmedabad – June 11, 2011

June 3, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Best Practices, Database, DBA, MVP, SQL Wait Stats

TechEd on Road is back! In Ahmedabad June 11, 2011! Inviting all Professional Developers, Project Managers, Architects, IT Managers, IT Administrators and Implementers of Ahmedabad to be a part of Tech•Ed on the Road, on 11th June, 2011. We have put together the best sessions from Tech•Ed India 2011 for…

SQL SERVER – Puzzle – Statistics are not Updated but are Created Once

June 2, 2011

Pinal Dave

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

SQL Index, SQL Statistics

After having excellent response to my quiz – Why SELECT * throws an error but SELECT COUNT(*) does not?I have decided to ask another puzzling question to all of you. I am running this test on SQL Server 2008 R2. Here is the quick scenario about my setup. Create Table…

SQL SERVER – Creating All New Database with Full Recovery Model

June 1, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Sometimes, complex problems have very simple solutions. Let us see the following email which I received recently. “Hi Pinal, In our system when we create new database, by default, they are all created with the Simple Recovery Model. We have to manually change the recovery model after we create the…