One of the common task that I have come across is the need to convert a list of results into a comma separated list. There… Read More »Converting part of a result set to a comma separated list
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
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
The question came up as to which version of sql server is being run, and how do you determine the exact version number of the… Read More »Determining the version of SQL server from TSQL
The following applies to SQL Server 2008. How big of an allocation does max represent in the case of varchar(max) and varbinary(max)? Up to 2… Read More »varchar(max) and varbinary(max) Questions and Answers
SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility… Read More »SQL Server 2008 compatibility levels
SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility… Read More »SQL Server 2005 Compatibility Level
Today I completed a 5 day class on Microsoft SQL Server version 1.1. The first 3 days were on Transact SQL, and the last… Read More »Officially Certified for Transact SQL