Blog - Title

March, 2009

  • The Basics of the Windows Server 2008 Distributed File System (DFS)

    Overview In this blog post, we’ll cover the basics of the Distributed File System (DFS) in Windows Server 2008, which offers users simplified access to a set of file shares and helps administrators easily maintain the file server infrastructure behind...
  • New White Paper on Hyper-V and SQL Server Consolidation at Microsoft

    A new white paper on how Microsoft IT is combining Hyper-V and SQL Server has just been published. This comes from a team that provides thousands of SQL Server instances for internal applications. It includes a lot of interesting new information, including...
  • SQL Server 2008 Pages

    Here are some notes on "SQL Server 2008 Pages" I took while attending an advanced class on SQL Server taught by Paul Randal ( http://sqlskills.com/AboutPaulSRandal.asp ). Please note that, although these notes were taken during the class, I might have...
  • SQL Server 2008 Data Compression

    SQL Server 2008 introduced a new feature to compress data stored in tables, indexes and indexed views. It basically uses a few different techniques to save space when storing data. You can set compression to NONE, ROW or PAGE (page includes ROW-level...
  • To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem

    While attending a class on SQL Server, I was introduced to a paper from Microsoft Research (authors are Russell Sears, Catharine Van Ingen and Jim Gray) that discusses whether to store large objects in a filesystem or in a database, depending on the size...
  • SQL Server 2008 File-related Optimizations

    While attending training today, I learned some file-related optimizations for SQL Server 2008. Some of those will also apply to previous versions of SQL Server. 1) No performance gain in multiple log files There is a common misconception that having...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • SQL Server 2008 Optimize for Ad Hoc Workloads

    SQL Server will create a plan for each batch you execute. If that plan is deemed to be "safe", it's stored in the plan cache for re-use. However, you use a lot of ad hoc queries only once, you will end up with a lot of cached plans that are really never...
  • Book Chapter on Improving SQL Server Performance

    I stumbled upon a great document on how to improve SQL Server performance. It's actually a chapther in a book on "Improving .NET Application Performance and Scalability" from a "Patterns and Practices" prescriptive guidance. Here's a summary of what it...
  • SQL Server 2008 Locking

    Here are some notes on "SQL Server 2008 Locking" 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...
  • SQL Server 2008 Partitioning

    Here are some notes on "SQL Server 2008 Partitioning" 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...
  • SQL Server 2008 Fragmentation

    Here are some notes on "SQL Server 2008 Fragmentation" I took while attending an advanced class on SQL Server taught by Paul Randal http://sqlskills.com/AboutPaulSRandal.asp ). Please note that, although these notes were taken during the class, I might...
  • SQL Server 2008 Backup and Restore

    Here are some notes on "SQL Server 2008 Backup and Restore" I took while attending an advanced class on SQL Server taught by Paul Randal http://sqlskills.com/AboutPaulSRandal.asp ). Please note that, although these notes were taken during the class...
  • SQL Server 2008 Database Checking

    Here are some notes on "SQL Server 2008 Database Checking" I took while attending an advanced class on SQL Server taught by Paul Randal ( http://sqlskills.com/AboutPaulSRandal.asp ). Please note that, although these notes were taken during the class...
  • SQL Server 2008 Client Design

    Here are some notes on "SQL Server 2008 Client Design" I took while attending an advanced class on SQL Server taught by Adam Machanic ( http://sqlblog.com/blogs/adam_machanic/default.aspx ). Please note that, although these notes were taken during...
  • SQL Server 2008 XML Indexing

    Here are some notes on "SQL Server 2008 XML Indexing" I took while attending an advanced class on SQL Server taught by Adam Machanic ( http://sqlblog.com/blogs/adam_machanic/default.aspx ). Please note that, although these notes were taken during the...
  • SQL Server 2008 Change Tracking (CT) and Change Data Capture (CDC)

    Here are some notes on "SQL Server 2008 Change Tracking (CT) and Change Data Capture (CDC)" I took while attending an advanced class on SQL Server taught by Paul Nielsen (from http://www.sqlserverbible.com ). Please note that, although these notes...
  • SQL Server 2008 Hierarchies and HierarchyID

    Here are some notes on "SQL Server 2008 Hierarchies and HierarchyID" I took while attending an advanced class on SQL Server taught by Paul Nielsen (from http://www.sqlserverbible.com ). Please note that, although these notes were taken during the class...
  • SQL Server 2008 New Date and Time Types

    Here are some notes on "SQL Server 2008 New Date and Time Types" I took while attending an advanced class on SQL Server taught by Paul Nielsen (from http://www.sqlserverbible.com/ ). Please note that, although these notes were taken during the class...
  • SQL Server 2008 Merge

    Here are some notes on "SQL Server 2008 Merge" I took while attending an advanced class on SQL Server taught by Paul Nielsen (from http://www.sqlserverbible.com/ ). Please note that, although these notes were taken during the class, I might have added...
  • SQL Server 2008 T-SQL Improvements

    Here are some notes on "SQL Server 2008 T-SQL Improvements" I took while attending an advanced class on SQL Server taught by Paul Nielsen (from http://www.sqlserverbible.com/ ). Please note that, although these notes were taken during the class, I...