Dropping a Database

I came across an issue on a server this morning where a drive had run out of free space.  Now given...

SQL Server 2012 FileTable – Part 1

In a series of blog posts we will have a look at the new SQL Server 2012 table type called...

SQL SERVER DISABLE INDEX

Use the script below to disable an index on a SQL Server table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME DISABLE;
 
Executing the...

Pro and Cons of Parameter Sniffing

Look at the following 3 scripts:
-- 1. Hardcoded
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime < '19900101'

-- 2. Variable
DECLARE @FilterDate DATETIME = '19900101'
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime...

January 2012 – Monthly SQL Server Checklist

It’s the first Monday of January and for most of us it’s probably a vacation day.  No fear, you can...

How to change the database collation

To change the collation of an database following commands can be used:

ALTER DATABASE [database name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE  [database name]  COLLATE Newcollation
ALTER DATABASE  [database name]  SET MULTI_USER

For example , suppose if the name...

How to remane a Table in Sql Server

To rename a column in a SQL Table following command can be reused:
SP_RENAME  'old table name', 'New table name'

For example,...

Wrapping Up 2011

Goal Setting
Last year, I did a wrap up post of the year to see where I landed from where I...

Review of my blog posts in 2011

The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.

Here’s an excerpt:
The concert hall at the Syndey...

SQL Index Fragmentation and sys.dm_db_index_physical_stats

Fragmentation of an index can severely affect performance. When logical ordering of the key within a page does not match...