Here are some notes on "SQL Server 2008 Statistics" I took while attending an advanced class on SQL Server taught by Kimberly Tripp  (http://sqlskills.com/AboutKimberlyLTripp.asp). Please note that, although these notes were taken during the class, I might have added some of my own (mis)interpretation :-). Always check your facts on Books Online (I try to … Continue reading SQL Server 2008 Statistics →

Here are some notes on "SQL Server 2008 indexing for JOINs" I took during an advanced class I attended taught by Kimberly Tripp  (http://sqlskills.com/AboutKimberlyLTripp.asp). Please note that, although these notes were taken during the class, I might have added some of my own (mis)interpretation :-). Always check your facts on Books Online (I try to … Continue reading SQL Server 2008 Indexing for JOINs →

I'm attending a SQL training and looking at indexing closely. One thing that becomes important is understanding how SQL executes queries. Understanding the graphical execution plans becomes extremely important. While looking for a good reference, I found it in books online: Graphical Execution Plan Icons (SQL Server Management Studio)http://msdn.microsoft.com/en-us/library/ms175913.aspx As usual, Books Online is a great … Continue reading SQL Server 2008 Graphical Execution Plans →

Here are some additional notes on "SQL Server 2008 Indexing Best Practices" I took while attending an advanced class on SQL Server taught by Kimberly Tripp  (http://sqlskills.com/AboutKimberlyLTripp.asp.Please) note that, although these notes were taken during the class, I might have added some of my own (mis)interpretation :-). Always check your facts on Books Online (I try to … Continue reading SQL Server 2008 Indexing Best Practices →

Here are some notes on "SQL Server 2008 Indexing" I took while attending an advanced class taught by Kimberly Tripp (http://sqlskills.com/AboutKimberlyLTripp.asp.Please) note that, although these notes were taken during the class, I might have added some of my own (mis)interpretation :-). Always check your facts on Books Online (I try to provide links when applicable). … Continue reading SQL Server 2008 Indexing →

I will be attending an advanced SQL Server training in a couple of weeks and the instructors recommended some pre-reading. I'm sharing here a subset of those recommendations that point to articles and white papers published by Microsoft, grouped by category:Database Storage TechNet Library Whitepaper: Physical Database Storage Design RAID Levels and SQL Server Books … Continue reading Technical Articles and White Papers on SQL Server →