I recently changed the SQL Server 2000 default...

How can you identify automatically created statistics in...

When a database performs an autogrow, does it...

Where can I find all the ports on...

What does this return?


EXEC master..xp_msver N'ProcessorCount',N'ProcessorType'

Beginning SQL Server - Limit Your Queries

Part 2 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product.

Why do the sp_depends procedure and the Display...

Is it possible to programmatically detect a blocked...

SQL Server Alerts

SQL Server Alerts provide a great way for the server to notify a DBA that some event has occurred, usually something bad that they need to fix. However alerts can also be used to drive business logic processes and enable some types of actions to be safely performed without requiring extraordinary rights by a user. Author Leo Peysakhovich brings us some ideas on how we can use alerts to implement business logic processing.

First Impressions of SQL Server 2005: Installation and Tools

Brian Knight has started a new series base on his impressions of SQL Server 2005, Beta 2, aka "Yukon". Read about his first impressions of the product as he starts down the path of learning about the next version of SQL Server.