SQL 2008 Protocol Documentation

0
Your rating: None

Microsoft has released documentation on protocols used in SQL 2008. This will be really helpful for those enterprises that have strict network security. http://www.microsoft.com/downloads/details.aspx?FamilyID=91ef5106-944a-41e1-b3a0-5bd3f2356f32&DisplayLang=en

SQL Server Cheat Sheets

3.727275
Your rating: None Average: 3.7 (11 votes)

I want to create a compendium of cheat sheet sites that I think are good for SQL Server. And if I can't find anything good, I was going to create my own.

SQL Server DBA focused

A simplified BOL site includes more than DBA info - http://www.ss64.com/sql

Pinal Dave has attempted to create a one page version for SQL 2008.

Deciphering Graphical Query Plans

0
Your rating: None

Grant has done a great job on the basics that you can use to understand even complicated query plans: http://www.simple-talk.com/sql/performance/graphical-execution-plans-for-simple-sql-queries/

SQL Server 2008 Upgrade Technical Reference Guide

0
Your rating: None

Microsoft and Solid Quality Mentors have produced a free Technical Reference Guide on SQL 2008 upgrade best practices.
http://www.microsoft.com/downloads/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en

SQL 2008 Upgrade Process

0
Your rating: None

For the ultimate guide to upgrading to SQL Server 2008, check out the whitepaper published by Microsoft SQL Server 2008 Upgrade Technical Reference Guide.

SQL Server Myths

0
Your rating: None

The PSS Team blog (Bob Dorr wrote article) has a great discussion on a couple of common myths for SQL Server performance:

  • SQL Server Uses One Thread Per Data File
  • A Disk Queue Length greater than 2 indicates an I/O bottleneck

 http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx
Summary notes from article:

Excellent intro to reading execution plans

0
Your rating: None

Grant wrote an excellent introductory article on execution plan basics and has a more detailed ebook for sale on lulu.com. http://www.simple-talk.com/sql/performance/execution-plan-basics. Code listing link.

TCP Optimization for Windows

0
Your rating: None

 

Your NIC card configuration settings maybe the cause of slow file copies over your wide area network (WAN). Also, know that Windows Explorer file copy is designed to throttle its network usage, so use Robocopy, Richcopy, FTP, etc instead.

 

SQL 2005 SP2 hotfix install failure error

0
Your rating: None

Trying to install any post SP2 hotfix, I kept getting this error message in the Summary.log file (C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix)

MSP Error: 29537 Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction

SQL Server Express Installation

0
Your rating: None

Microsoft has provided 2 links for SQL Express Edition -:
Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2
http://www.microsoft.com/downloads/details.aspx?FamilyId=5b5528b9-13e1-4db9-a3fc-82116d598c3d&displaylang=en
Microsoft SQL Server 2005 Express Edition with Advanced Services