Year: 2010

Big One Time Use Queries

There is a newer version of this posting, click here. Part of my regular database maintenance or tuning routine is to look for the queries with cached plans that are taking up the most space, and have only been used

Posted in Performance Tagged with: ,

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: ,

Notes from the Introduction to SQL server class.

Here are the slide decks from the Introduction to SQL Server class – January 2010. Class 1 About the Instructor Introduction and Class Overview (Review Syllabus) Course Logistics – What to expect and what is expected What is SQL Server?

Posted in Classes Tagged with: ,

Moving to a new datacenter – EPIC FAIL – Fibercloud.

The current datacenter has failed.  The company that we have been using Fibercloud in Bellinhgam WA, with their “Always On” slogan has had an epic failure. Server temp of 117 degrees F means that it is time to move to

Posted in Fail Tagged with: , ,