SQL

declare @year int set @year =2011 -- First and Last Sunday by SqlServerCurry.com select min(dates) as first_saturday,max(dates) as last_...

The best way to prevent users from dropping databases is to not grant the necessary access to drop a database, it can sometimes come in hand...

Restart SQL Server with the command line parameter -T3608, and then run alter database commands to move the location of TempDB: ALTER DATAB...

Consider the following example: declare   @t  table (data  VarChar (20)) insert   into   @t select   '3333333333'   as   data  ...

Here is a script to find All Tables in a Database. It will also find No of Records, Indexes, No of Indexes, Space occupied by a Table. S...