SQL Tips and Tricks Archives - Page 367 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – Updated Favorite Scripts and Best Articles Page

May 19, 2010

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 – 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 – List All the DMV and DMF on Server

May 15, 2010

Pinal Dave

SQL Tips and Tricks

SQL DMV, SQL Scripts, SQL Server

“How many DMV and DVF are there in SQL Server 2008?” – this question was asked to me in one of the recent SQL Server Training.

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.…

SQL SERVER – Spatial Database Queries – What About BLOB

May 11, 2010

Pinal Dave

SQL Tips and Tricks

Geography Data Type, Spatial Database, SQL Scripts, SQL Server

Michael Coles is one of the most interesting book authors I have ever met. He has a flair of writing complex stuff in a simple language. There are a very few people like that. I really enjoyed reading his recent book, Expert SQL Server 2008 Encryption. I strongly suggest taking a look at it. Let us learn about Spatial Database Queries.