Looking at a Default Installation of SQL Server 2005 - Video Series Video Category: Installing, Deploying, and Upgrading SQL Server Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 This series takes you through a standard installation of SQL Server 2005 (Developer Edition). The videos in this series show you the folders, the network libraries, the services installed and gives you the overall "Big Picture" of SQL Server.

Videos in this Series:

Title Skill Length Download Part 1 - An Overview of the Default SQL Server Installation   100 10 mins. Download Part 2 - My How Things Have Changed - A Video Walk-Through of Some of the New To...   200 17 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

You can use the table hint "WITH (NOLOCK)" to minimize the locks you place on resources during a SELECT statement - SELECT * FROM MyTable WITH (NOLOCK) places no "Shared" locks on MyTable SQL Server 2000 Service Pack 4 Features: Changes were made to the visual tools: the table designer, the diagrams, and the Query Designer which make them more secure and reliable SQL Server 7.0 was the first time that SQL Server supported bullable BIT data types. Previous versions could only be 1 or 0