SQL Archives - Page 357 of 828 - SQL Authority with Pinal Dave

SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions

May 21, 2010

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

To learn any technology and move to a more advanced level, it is very important to understand the fundamentals of the subject first. Today, we will be talking about something which has been quite introduced a long time ago but not properly explored when it comes to the isolation level.…

SQLAuthority News – Updated Favorite Scripts and Best Articles Page

May 19, 2010

Pinal Dave

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

I have been writing on this blog for around 4 years now and have contributed with more than 1300 blog posts. Many times, I have been asked regarding what is my most favorite article or which is the most essential script for developers and DBA. This is very difficult to…

SQLAuthority Book Review – DBA Survivor: Become a Rock Star DBA

May 18, 2010

Pinal Dave

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

SQLAuthority Book Review

DBA Survivor: Become a Rock Star DBA – Thomas LaRock Link to Amazon Link to Flipkart First of all, I thank all my readers when I wrote that I could not get this book in any local book stores, because they offered me to send a copy of this good…

SQLAuthority News – Bookmark – Deprecated Database Engine Features in SQL Server 2008

May 17, 2010

Pinal Dave

SQL

SQL Deprecated Feature, SQL Documentation, SQL Server

When anyone asked me if any specific feature is available in SQL Server 2008 or if any feature will be disabled in future versions of SQL Server, I always pointed to the following list where all the deprecated database engine features are listed.

SQLAuthority News – Storage and SQL Server Capacity Planning and configuration – SharePoint Server 2010

May 16, 2010

Pinal Dave

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

SharePoint, SQL Data Storage, SQL White Papers

Just a day ago, I was asked how do you plan SQL Server Storage Capacity. Here is the excellent article published by Microsoft regarding SQL Server capacity planning for SharePoint 2010. This article touches all the vital areas of this subject. Here are the bullet points for the same. Gather…

SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup

May 13, 2010

Pinal Dave

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

SQL Backup and Restore, SQL Index, SQL Scripts

Recently, I have observed that not many people have proper understanding of what is bookmark lookup or key lookup. Increasing numbers of the questions tells me that this is something that developers encounter every single day, but have no idea how to deal with. I have previously written three posts…

SQL SERVER – Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index

May 12, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

This blog is in response to the ongoing communication with the reader who had earlier asked the question of SQL SERVER – Disable Clustered Index and Data Insert. The same reader has asked me the difference between ALTER INDEX ALL REBUILD and ALTER INDEX REBUILD along with disabled clustered index.…