Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Find the Size of Database File – Find the Size of Log File

February 8, 2010

I encountered the situation recently where I needed to find the size of the log file. When I tried to find the script by using Search@SQLAuthority.com I was not able to find the script at all. Here is the script, if you remove the WHERE condition you will find the…

SQL SERVER – SQL Server 2008 R2 Update for Developers Training Kit

February 7, 2010

Pinal Dave

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

Database, SQL Documentation, SQL Download, SQL Training

Note: Download SQL Server 2008 R2 Update for Developers Training Kit by Microsoft SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who…

SQLAuthority News – Presenting Two Sessions at TechED Sri Lanka

February 6, 2010

Pinal Dave

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

MVP, SQLAuthority Author Visit, TechEd

I will be presenting following two sessions at TechEd Sri Lanka this week. I am very excited as this is very first time I will be presenting in TechEd event. I have previously presented many sessions but I have never presented at this premier Microsoft Event. I will be presenting…

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate

February 5, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

I keep a check on the questions received from my readers; when any question crosses my threshold, I surely try to blog about it online. Stream Aggregate is a quite commonly encountered showplan operator. I have often found it in very simple COUNT(*) operation’s execution plan. If you like to…

SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines

February 4, 2010

Pinal Dave

SQL Tips and Tricks

SQL Dependency, SQL Scripts, SQL Server, SQL Server Security, SQL System Table

Recently, I read a question on my friend‘s SQL site regarding the following: sp_depends does not give appropriate results whereas information_schema. routines do give proper answers.

SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Fun

February 3, 2010

Pinal Dave

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

MVP, SQL User Group, SQLAuthority Author Visit

MVP Open Day South Asia was held in Hyderabad from Jan 20, 2010 to Jan 23, 2010. This event was a fun-filled event as well as an educational one. The event was held at Microsoft IDC at Hyderabad, the largest Microsoft Development location after Redmond. I had great time meeting…

SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Business

February 2, 2010

Pinal Dave

SQLAuthority News

MVP, SQL User Group, SQLAuthority Author Visit

MVP Open Day South Asia was held in Hyderabad from Jan 20, 2010 to Jan 23, 2010. This event was a fun-filled as well as an educational event. This event was held at Microsoft IDC at Hyderabad – the largest Microsoft Development location after Redmond. I had a great time meeting my friends and some of the renowned experts from all over the South Asia. The whole event started with networking with other MVPs as well with Product Group members.