Feeds:
Posts
Comments

Archive for November, 2009

SQLAuthority News – Book Review – Expert SQL Server 2008 Encryption by Michael Coles

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Book Review, SQLAuthority News, SQLServer, T SQL, Technology, tagged on November 20, 2009 | 3 Comments »

Expert SQL Server 2008 Encryption (Paperback) Michael Coles (Author), Rodney Landrum (Author) Link to Amazon “What is your opinion on encryption? What I mean is: In a world filled with data, how do you see encryption?” This is the precise question Michael Coles posed to me on March 3rd of this year, while we were [...]

Read Full Post »

SQL SERVER – Understanding Table Hints with Examples

Posted in Pinal Dave, SQL, SQL Authority, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on November 19, 2009 | 10 Comments »

Introduction Today we have a very interesting subject to look at. I tried to look for help online but have not found any other documentation besides what we have from the Book Online. Let us try to understand what are the different kinds of hints available in SQL Server and how they are helpful. What [...]

Read Full Post »

SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table

Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Index, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQLServer, T SQL, Technology on November 18, 2009 | 16 Comments »

It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of all the indexes on the table. If [...]

Read Full Post »

SQL SERVER – 2005 2008 – Backup, Integrity Check and Index Optimization By Ola Hallengren

Posted in Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLAuthority Website Review, T SQL, Technology on November 17, 2009 | 5 Comments »

Script of Backup, Integrity Check and Index Optimization are the most important scripts for any developer. SQL Expert and true SQL enthusiast Ola Hallengren is known for his excellent scripts. Please try it out and let me know what you think. The documentation is available on http://ola.hallengren.com/Documentation.html and the script can be downloaded from http://ola.hallengren.com. [...]

Read Full Post »

SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle

Posted in Database, DBA, MVP, PASS, Pinal Dave, SQL, SQL Authority, SQL PASS, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology on November 16, 2009 | 13 Comments »

Update: Do not forget to checkout last three photos and follow me on twitter (of course!) I have previously documented my four-day experience of SQL PASS 2009 Summit at Seattle. There were many reasons for SQL enthusiasts to attend the SQL PASS event; I am listing my own reasons here in order of importance to [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers