Simplest Example

Simplest Example

the essence of the thing

Archive for January 2014

Putting Clustered Indexes On Huge Heap Tables

I’ve recently been working with a company that has some relatively large tables stored as heaps.  Adding clustered indexes to a few of these tables has been relatively difficult, as they’re very active and, for reasons that I don’t need to get into here, we have very limited drive space. They have SQL Server Enterprise Edition, which allows us to add… (read more)

I Have No Way To Learn About SQL Server AlwaysOn Availability Groups

People often try to explain to me that they don’t have the ability to learn about something because they don’t have the proper hardware.  I felt so strongly that this was a lame excuse that I used to use a sub-$500 plastic HP laptop that I walked into Best Buy and bought as my work laptop… (read more)

Large Sample Databases for SQL Server

A large sample dataset is helpful when demonstrating the benefits of SQL Server features such as compression or columnstore indexes. Here’s a list of sources of large sets of data that can act as this sample set of data with little additional preparation. Microsoft Contoso BI Demo Dataset for Retail Industry – download the ContosoBIdemoBAK.exe… (read more)