Monthly Archives: 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

Posted in Performance 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.

Posted in DBA 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

Posted in SQL Server Tagged with: ,

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at with my newsletter.
Newsletter signup form.

Stedman Solutions