Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance

December 16, 2009

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

I would like to start this post with an interesting question: Where in MS SQL Server is “100” equals to “0”? And I am not talking about data types now.. Today I will be presenting the answer to this question and some topics related to it. Creating Indices in SQL…

SQL SERVER – Difference TempTable and Table Variable – Table Variable in Memory a Myth

December 15, 2009

Pinal Dave

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

SQL Scripts

Recently, I have been conducting many training sessions at a leading technology company in India. During the discussion of temp table and table variable, I quite commonly hear that Table Variables are stored in memory and Temp Tables are stored in TempDB. I would like to bust this misconception by…

SQLAuthority News – An Year of Personal Events – A Life Outside SQL

December 14, 2009

Pinal Dave

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

Today I will keep the words very short and will convey story in three simple photographs. This post answers the question – “Do I have life outside SQL?” YES! I do and it is very beautiful. December 12, 2009 September 1, 2009 December 12, 2008 Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – White Paper – Partitioned Table and Index Strategies Using SQL Server 2008

December 13, 2009

Pinal Dave

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

Best Practices, SQL Index, SQL White Papers

Partitioned Table and Index Strategies Using SQL Server 2008 Writer: Ron Talmage, Solid Quality Mentors Technical Reviewer: Denny Lee, Wey Guy, Kevin Cox, Lubor Kollar, Susan Price – Microsoft Greg Low, Herbert Albert – Solid Quality Mentors When a database table grows in size to the hundreds of gigabytes or…

SQLAuthority News – Featured on Channel 9

December 12, 2009

Pinal Dave

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

Database, SQL String

This blog was featured on Channel 9 MSDN over here : TWC9: Scott Hanselman, Jon Galloway, Bing, parallel unit tests, more. I was very proud that this blog was discussed for more than 5 mins (from min 18 to min 23) on my favorite online show. Scott Hanselman, Jon Galloway…

SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication

December 11, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Replication, SQL Scripts

Replication has been my favorite subject when it comes to resolving errors. I have found that many DBAs are stuck with the solving of the problem of replication for hours; however, the solution is very easy. One of the very common errors in replication occurs when replication is removed from…

SQL SERVER – Future of Business Intelligence

December 10, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence, Data Warehousing

Business Intelligence (BI) is slated to play bigger roles in all kinds of businesses in the coming years. This is not surprising as data analysis and smarter decision making has made the use of BI inevitable in all sizes of businesses across all sectors, including Real estate, IT, mobile devices,…