Code Name Denali
SQL 2012 is being referred to by Microsoft as code name Denali.
Finding the names of all indexes on a SQL Server
I needed a way to list of of the indexes for an entire database, but I was running into a problem using sys.indexes that I… Read More »Finding the names of all indexes on a SQL Server
Index Seek vs Index Scan
The question comes up when looking at an execution plan of whats the difference between an index seek and an index scan. What it… Read More »Index Seek vs Index Scan
MSG 128, Level 15, State 1 – not permitted in this context
Default Values and Computed Columns In SQL Server 2008, I was presented with the following error when attempting to create a table that has a… Read More »MSG 128, Level 15, State 1 – not permitted in this context
Big One Time Use Queries – Revisited
Just the same query that I posted months ago, but this time it is wrapped in a stored proc. I use this one often enough… Read More »Big One Time Use Queries – Revisited
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… Read More »Big One Time Use Queries
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… Read More »Indexing Presentation – The Basics
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… Read More »SQL Server 2008 R2 Compatibility Levels
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… Read More »What is SQL Server?
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… Read More »Notes from the Introduction to SQL server class.