SQL Server references 1

This is my first draft of the lists that I want to build to help SQL Server professionals as well as beginners who want to get resources in one place. Please feel free to send me your comments and urls that you feel is very important to be added to the list.

SQL Server 2005 home page

SQL Server related web casts

SQL Server 2005 Virtual Labs

SQL Server 2005 certification

SQL Server 2000 Resource Kit

Clustering 1

Internal and External Fragmentation

User database admin

Cost of Database Fragmentation

SQL server performance articles on sql-server-performance.com

SQL Server 2000 backup and restore

Move database from one server to another

SQL Server scripts

Blocking resolution

SQLIO Disk Subsystem Benchmark Tool

SQL Server Health and History Tool (SQLH2) Performance Collector

Best Practices Analyzer Tool for Microsoft SQL Server 2000 1.0

SQL Server Health and History Tool (SQLH2)

SQL Server Web Data Administrator

Tables with computed columns

Computed columns some times causes re-indexing of database to fail. To find out which tables got computed columns, I normally use the following query.

select so.id as ObjectId,
so.name as ObjectName,
sc.name as ComputedColumnName
FROM sysobjects so, syscolumns sc
where so.id = sc.id
and sc.iscomputed = 1
and so.xtype = 'u'

Number of Triggers

This script is used to find the number of triggers on database tables in database.

select object_name(parent_obj) as ObjectName,
count(name) as TotalTriggers
from sysobjects where xtype = 'tr'group by object_name(parent_obj)order by count(name) desc