You are browsing archives for
Applies to: SQL Server 2000, SQL Server 2005 (Yukon) It’s pretty often I see the need for a database to be renames. Sometimes its because a developer has given their database a very generic name, or sometimes becuase the use of the database has shifted. Renaming a database is a pretty easy task (make sure […]
Often you’ll want to compare datetime values based on the date only, ignoring the time. This is especially important when doing date ranges, where thinking like a human you might want ‘Select Accounts Join Offers Where SignupDate between 1st Jan and 31st Jan’. As a human we’re probably thinking ‘inclusive’. As a computer, SQL Server […]
Microsoft Support has published knowledge base articles 888799 and 888800 on Dec 21st 2004 for SQL Server Service Pack 4 Beta and Analysis Services Service Pack 4 Beta. Details on how to participate in the Beta Details on how to download the latest SQL Server 2000 service pack
