All Articles - SQL Authority with Pinal Dave

SQL SERVER – DMV sys.dm_exec_describe_first_result_set_for_object – Describes the First Result Metadata for the Module

April 7, 2012

Here is another interesting follow up blog post of SQL SERVER – sp_describe_first_result_set New System Stored Procedure in SQL Server 2012. While I was writing earlier blog post I had come across DMV sys.dm_exec_describe_first_result_set_for_object as well. I found that SQL Server 2012 is providing all this quick and new features which quite often…

SQLAuthority News – Reliving TechEd at Bangalore User Groups

April 6, 2012

Pinal Dave

SQLAuthority News

SQL Server, SQL User Group, SQLAuthority Author Visit

TechEd India 2012 was held in Bangalore last March 21 to 23, 2012. Just like every year, this event is bigger, grander and inspiring. Here is my blog post reviewing the event SQLAuthority News – #TechEdIn – TechEd India 2012 Memories and Photos. For me this is a family event – I get to meet my friends who are dear as my family. I like to call User Groups as family too. Family shares life’s personal happiness and experience – the same way User Group shares professional experiences and quite often UG members become just like a family member.

SQLAuthority News – #TechEdIn – TechEd India 2012 Memories and Photos

April 5, 2012

Pinal Dave

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

SQLAuthority Author Visit, TechEd, TechEdIn

TechEd India 2012 was held in Bangalore last March 21 to 23, 2012. Just like every year, this event is bigger, grander and inspiring. Pinal Dave at TechEd India 2012 Family Event Every single year, TechEd is a special affair for my entire family. Four months before the start of…

SQL SERVER – Cleaning Up SQL Server Indexes – Defragmentation, Fillfactor – Video

April 4, 2012

Pinal Dave

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

SQL Index

Storing data non-contiguously on disk is known as fragmentation. Before learning to eliminate fragmentation, you should have a clear understanding of the types of fragmentation. When records are stored non-contiguously inside the page, then it is called internal fragmentation. When on disk, the physical storage of pages and extents is not contiguous. We…

SQL SERVER – FIX: ERROR Msg 5169, Level 16: FILEGROWTH cannot be greater than MAXSIZE for file

April 3, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I am writing this blog post right after I resolve this error for one of the system. Recently one of the my friend who is expert in infrastructure as well private cloud was working on SQL Server installation. Please note he is seriously expert in what he does but he…

SQL SERVER – Use ROLL UP Clause instead of COMPUTE BY

April 2, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Note: This upgrade was test performed on development server with using bits of SQL Server 2012 RC0 (which was available at in public) when this test was performed. However, SQL Server RTM (GA on April 1) is expected to behave similarly. I recently observed an upgrade from SQL Server 2005 to…

SQL SERVER – A Puzzle – Illusion – Confusion – April Fools’ Day

April 1, 2012

Pinal Dave

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

SQL Scripts

Today is April 1st and just like every other year, I like to bring something interesting and light for the day. Atleast there should be days in every one’s life when they should feel easy. Here is a quick puzzle for you and I believe it will make you feel…

SQL SERVER – sp_describe_first_result_set New System Stored Procedure in SQL Server 2012

March 31, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

I might have said this earlier many times but I will say it again – SQL Server never stops to amaze me. Here is the example of it sp_describe_first_result_set. I stumbled upon it when I was looking for something else on BOL. This new system stored procedure did attract me…

SQL SERVER – Online Index Rebuilding Index Improvement in SQL Server 2012

March 30, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

Have you ever faced a situation where you see something working but you feel it should not be working? Well, I had similar moments a few days ago. I knew that SQL Server 2008 supports online indexing. However, I also knew that I could not rebuild index ONLINE if I…

SQL SERVER – Difference between DATABASEPROPERTY and DATABASEPROPERTYEX

March 29, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Earlier I asked a simple question on Facebook regarding difference between DATABASEPROPERTY and DATABASEPROPERTYEX in SQL Server. You can view the original conversation there over here. The conversion immediately became very interesting and lots of healthy discussion happened on facebook page. The best part of having conversation on facebook page is…