Archives for: "September 2008"

Ultimate guide to the datetime datatypes

Tibor Karaszi has updated his Ultimate guide to the datetime datatypes for SQL Server 2008!Remember - SQL Server MVP Frank Kalis, has translated this article to German.http://www.karaszi.com/SQLServer/info_datetime.asp CU tosc more »

Cumulative Update package 1 for SQL Server 2008

The Cumulative Update package 1 for SQL Server 2008 (Build 10.00.1763.00) is now available: http://support.microsoft.com/kb/956717/en-us CU tosc more »

List all tables with specified field

DECLARE @COL_NAME NVARCHAR(50) SET @COL_NAME = '%SOMESTRING%' SELECT DB_NAME(DB_ID()) AS DatabaseName, B.name AS TableName, A.name AS ColumnName FROM sys.syscolumns AS A INNER JOIN sys.sysobjects AS B ON… more »

SQL Trace Flags - 3502 - Timing of checkpoints

Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account

Best Practices for Semantic Data Modeling for Performance and Scalability