We're often asked how to determine gaps in an identity column. For Sql 2000, there are quite a few references out there (my favorite, and probably the most scalable solution I've found, is a morph of a solution created by Umachandar Jayachandran as follows...

Q: In addition to hyper-threading and dual-core technology, chip vendors are beginning to release processors with additional cores (4,8,etc.). I am currently considering purchasing a new server with multi-core processors to support a Sql Server 2005 Standard...

Q: I have configured Database Mirroring successfully between 2 Sql Server 2005 instances. My application is connecting to Sql Server using a Sql Server login, and is built using ADO and the Sql Native Client. My connection strings/connection settings...

Q: Given the forthcoming updates to Daylight Savings Time to comply with the Energy Policy Act of 2005, it will be necessary for me to update my Windows Operating Systems with the appropriate patches. Are there additional Sql Server specific updates that...