Archive for December, 2008

Windows 7 Features, Screenshots, Demo Windows 7 Taskbar Windows 7 System Tray Advertisements

When you try to restore a database there are some very tricky stuff you need to know.

A list of widely used SQL settings Explained ANSI NULLS QUOTED_IDENTIFIER ARITHMABORT ANSI_DEFAULTS ANSI_WARNINGS DATEFIRST DATEFORMAT NOCOUNT NOEXEC IDENTITY_INSERT IMPLICITY_TRANSACTIONS LANGUAGE ANSI NULLS – Syntax SET ANSI_NULLS {ON | OFF} – Explanation The SQL-92 standard requires that an equals (=) or not equal to (<>) comparison against a null value evaluates to FALSE. When SET […]