Script to get total rows and space used

Script to Get Total Rows, space used and reserved (KB) of all tables

Change to readable date format

Trigger to insert date into table in the form of01/01/00 12:00:00instead of SQL standard date format2000-01-01 12:00:00.000This allows easily comparing to or updating based onOracle date formats or a readable format for the web.triggername - name of the triggerTABLENAME - name of the table that trigger is created onCOLUMNNAME - name of column in TABLENAME […]

Encrypt DTSRUN command

Encrypting a DTSRUN command in T-SQL

Janice has two tables, Employees and Orders. She...

What does the ERROR_PROCEDURE() function return?

get rich schema details of all or some tables

to get information about tables+columns+primarykeys+foreignkeys+identity, i firstly used SQL server built-in INFORMATION_SCHEMA.xxx. however, my company have various DBAs and each of them owns objects. when using INFORMATION_SCHEMA.xxx, it retrieves data based on current login (version 2005 resolves this schema v.s. object owner problem already... yeah) , which bring me a great trouble. if you want […]

What does @@options return?

Exploring NewSequentialID() in SQL Server 2005

The benefits and drawbacks of GUIDs as primary keys are generally known. Despite the drawbacks, some people use them to fulfill specific business requirements (the IDs are unique across multiple servers).

Rank the results of the following select statements...

In the REPEATABLE READ isolation level, what phenomena...