A one-page SQL Server 2008 cheat sheet PDF with the commands DBAs and developers use every day. Print it on A4 and keep it handy.
SQL SERVER – Renaming SP is Not Good Idea – Renaming Stored Procedure Does Not Update sys.procedures
Renaming Stored Procedure objects with sp_rename looks fine, but the stored definition keeps the old name, as sp_helptext shows. A quick demo on AdventureWorks.
Interview Questions and Answers Complete List Download
The SQL Server 2008 Interview Questions and Answers Complete List in one place. A good interview leads to a good career if the candidate is willing to learn.
SQL SERVER – Interview Questions and Answers – Part 6
Part 6 of my SQL Server Interview questions and answers covers SQL Server 2008, starting with what the master, msdb, model, tempdb and resource databases do.
SQL SERVER – Interview Questions and Answers – Part 2
This is the second part of the blog post series Interview Questions and Answers.Click here to get free chapters (PDF) in the mailbox
SQL SERVER – 2008 – Creating Full Text Catalog and Full Text Search
Set up Full Text Search in SQL Server 2008 in three steps: create a full-text catalog, create the full-text index, then populate it. Screenshots for each step.
SQL SERVER – Introduction to Filtered Index – Improve performance with Filtered Index
A Filtered Index in SQL Server 2008 indexes only some rows of a table, which can speed up queries and cut index storage and upkeep. Example on the Employee table.