|
Date Published: February 18, 2010
Rating: 4.24
Description: Want to know if an index is clustered, disabled, or what the fill factor is set to? All you need is the IndexProperty function, the ID of the base table and you're almost there. It's easy to use, and did you know that it works on statistics too?
|
|
|
Date Published: December 02, 2009
Rating: 3.99
Description: You may have heard that changing the filegroup of a clustered index changes the location of the table as well, but have you seen it? We'll show you how to select the filegroup for an index, and then prove that changing the filegroup actually moves the table!
|
|
|
Date Published: September 09, 2008
Rating: 3.44
Description: This video explains what a clustered index seek is when looking at a query plan.
|
|
|
Date Published: September 09, 2008
Rating: 3.53
Description: This video explains what a clustered index scan is when looking at a query plan.
|
|
|
Date Published: September 11, 2006
Rating: 4.36
Description: By default, SSIS is not an easily cluster-aware product. In this video, Brian shows you how to cluster the service and make it highly available.
|
|
|
Date Published: August 28, 2006
Rating: 4.36
Description: With Windows 2003 now clustered, you're ready to begin to clustering SQL Server 2005. In this presentation, you'll see how to cluster SQL Server 2005 and some best practices in how to configure the SQL Server cluster after the fact.
|
|
|
Date Published: August 21, 2006
Rating: 4.58
Description: In this presentation, you'll learn step-by-step how to cluster Windows 2003 R2. Brian shows you how to configure and cluster a two node cluster, preparing it for any future services like SQL Server or Exchange.
|
|
|
Date Published: August 16, 2006
Rating: 4.24
Description: Before you start learning how to cluster, this video will show you the basics on how clustering in Windows 2003 and SQL Server 2005 works. Brian shows the basic architecture on clustering as well as the checklist that you would want to follow before starting to cluster.
|
|