Month: April 2010

Indexing Presentation – The Basics

Attached is the slide deck for a short presentation on indexing that was created to educate software developers on the basics of indexing. Outline: What is an Index Types of Indexes Non Clustered Indexes Clustered Indexes When To Avoid A

Tagged with: , , , , , , ,

SQL Server 2008 R2 Compatibility Levels

There was no change to the compatibility levels between SQL Server 2008 and SQL Server 2008 R2. SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it.

Tagged with: ,

What is SQL Server?

Originated as Sybase SQL Server Acquired by Microsoft and named Microsoft SQL Server in 1989 Recent Versions (2005, 2008, and 2008 R2) But what is it? A system for managing large amounts of data Provides a language TransactSQL (T-SQL) to

Tagged with: ,