The following feature comparison matrix illustrates the SQL Server 2005 features as well as the Maximum RAM and Processors by edition
Category Archives: SQL Server
Below is a link to an article that I wrote which was recently published by SQL Server Central (http://www.sqlservercentral.com/) on the the issues with dealing with NULLs
The December edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
The following Microsoft KB article details how to shrink a Transaction Log using DBCC SHRINKFILE http://support.microsoft.com/kb/272318/en-us.
The SQL Server 2005 System Table Map shows the system tables included in SQL Server 2005, and the relationships between them.
The following VBScript code snippet can be used to script all SQL Server Jobs on a SQL Server instance:
There are other tools such as SQLPing (sqlsecurity.com/DesktopDefault.aspx?tabid=26) that can be used to scan an IP address range for SQL Server instances.
For as long as I can remember the sqlwish@microosft alias has been used for submitting features and ideas to the Microsoft SQL Server team.
Below are the steps to generate a deadlock so that the behaviour of a deadlock can be illustrated:
— 1) Create Objects for Deadlock Example
An update to the SQL Server 2005 Books Online (BOL) has been released and can be downloaded from http://www.microsoft.com/