SQL Server with Mr. Denny:

Nonclustered Index

1

June 4, 2012  2:00 PM

VMware vCenter Performance Tuning



Posted by: Denny Cherry
Index Performance, Nonclustered Index, SQL Server, vCenter, VMware

As hopefully everyone that is using VMware's vSphere in either data center knows VMware's vCenter runs off of a Microsoft SQL Server database (by default).  Now as good as they guys at VMware are at building a virtualization platform there database leave a little to be desired.  I've identified a...

February 2, 2009  1:31 PM

Back To Basics: Clustered vs NonClustered Indexes; what’s the difference?



Posted by: Denny Cherry
Back To Basics, Clustered Index, Index, Nonclustered Index

SQL Server has two basics kinds of indexes. They are clustered and nonclustered indexes. There are some fundamental differences to the two which are key to understanding before you can master index tuning.


1