January 2007 - Posts

• Finding (all the) gaps in an identity column (or any integer based column for that matter) using Sql 2005

  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): Read More... Posted Sunday, January 07, 2007 5:19 PM by boydc7 | 1 Comments

• Sql Server CPU licensing, edition support, and multi-core technology

  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 Read More... Posted Friday, January 05, 2007 11:01 PM by boydc7 | 2 Comments

• Login failures connecting to new principal after failover using Database Mirroring

  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 Read More... Posted Friday, January 05, 2007 10:59 PM by boydc7 | 1 Comments

• Sql Server and the new Daylight Savings Time changes

  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 Read More... Posted Friday, January 05, 2007 10:50 PM by boydc7 | 1 Comments