This script shows a simple way to check if the current version of SQL Server is 2005 or lower.
It exploits the new server property called 'BuildClrVersion' which is not defined on SQL Server 2000 (and lower) but has just been introduced with 2005.
It may be useful to condition the execution of a piece of code which is required only for an older or the new version.
A Normalization Primer
For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model.
2003-01-13
18,238 reads