USE [master]

GO

/****** Object: Database [ProjectTesting] Script Date: 06/11/2014 10:58:40 ******/

CREATE DATABASE [ProjectTesting] ON PRIMARY

( NAME = N'ProjectTesting', FILENAME = N'd:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ProjectTesting.mdf' ,...

I can use the Where IN clause to filter results for just Home, Office, Fax, and Cell. This will still return a row for each record in the Telephone...

Windows 2003 (Standard) 64bit and SQL Server 2005 (Standard) 64bit will both address 16gb of RAM. This is assuming you are running on 64bit processor(s).

I normally handle this with a scheduled dbcc shrinkfile. Set the target size to 1(mb) and SQL will squeeze it down as tight as possible.

I don't recommend this for...