Indexing the Data WarehouseCommented on: 2 years ago
(November 18, 2011)
Michelle, in your article you say "create a clustered index on the identity column, which you can see in Figure 1." However, Figure 1 shows identity columns with non-clustered indexes. I...
SQL Server Management Studio is a complex application that does a ton of wonderful things and, with SSMS 2014, there are still a couple of quirks or issues that I hope that Microsoft addresses or corrects someday....More
Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More