SQL Server 2008 Statistics

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…

0

SQL Server 2008 Indexing for JOINs

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…

0

SQL Server 2008 Graphical Execution Plans

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…

0

SQL Server 2008 Indexing Best Practices

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…

1

SQL Server 2008 Indexing

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…

0

Technical Articles and White Papers on SQL Server

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…

0