The 1st cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site.

SQL Server 2012 SP1 CU1 contains fixes released in SQL Server 2012 RTM CU 3 & 4. For those who are upgrading to Service Pack 1 from SQL… Read more

The 8th cumulative update release for SQL Server 2008 Service Pack 3 is now available for download at the Microsoft Support site. Cumulative Update 8 contains all the hotfixes released since the initial release of SQL Server 2008 SP3.

Those who are facing severe issues with their environment, they can… Read more

Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 is to restore a full database backup to SQL Server 2012.

The full database backup will include the full-text catalog is required for upgrading & importing a SQL Server 2005 full-text catalog.

Backup from SQL Server 2005 Read more

The Connect to SQL Server Management Studio presents a new Additional Connection Parameters Page. Use the Additional Connection Parameters page to add more connection parameters to the connection string.

Steps to get Additional Connection Parameters page

1. In Management Studio, on the Query menu, point to Connection, and then click Connect.

Read more

Become Microsoft Community Contributor.

I am very happy after receiving this affiliation from Microsoft last month.

My MCC badge is visible now on MSDN.

Profile Page : http://social.msdn.microsoft.com/profile/rohitgarg/

Reference : Rohit Garg (http://mssqlfun.com/)

Read more

Today, We try to check of SQL server when trying to take Compress & UnCcomprees Backups in one Media\File.

Query No. 1

BACKUP DATABASE DB2

TO DISK = ‘D:\DB2_FULL.BAK’ WITH COMPRESSION

GO

BACKUP DATABASE DB2

TO DISK = ‘D:\DB2_FULL.BAK’ WITH NOINIT

Result : Run Successfully

Explanation : Backup file is… Read more

Wishing You a Very Happy Diwali…………….

KAHI TIMTIMAHAT HAIN DIYO KI, KAHI SHOR HAAN ATHISBAZI KA

CHAMAK HAAN DIL MAIN, UMEEDO KI KHANAK HAAN

MITHAIYO KA ANAND HAAN, PATHAKO KI JHADI HAAN

YE JEET HAAN SACH KI, YE JASAN HAAN DIWALI KA

Read more

Issue :

Today Evening, I was just about to leave the office and at same time I got a call from one of my friend. He is not running under any production issue but bit confused with SQL server behavior while connecting with port no. in case of named instance. Read more

How to open and view a deadlock .xdl file with SSMS ?

Solution 1 :

1. On the File menu in SQL Server Management Studio, point to Open, and then click File.
2. In the Open File dialog box, select your .xdl file & click open.

Solution 2 :

1. Go to the…

Read more

After a wait of around 8 months, Microsoft has released SQL Server 2012 SP1.

Microsoft SQL Server team has released SQL Server 2012 Service Pack 1 (SP1). Both, the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center. SQL Server 2012 SP1 contains fixes… Read more

How to save deadlock graph events as .xdl file ?

1. On the File menu, click New Trace, and then connect to an instance of SQL Server.
2. In the Trace Properties dialog box, type a name for the trace in the Trace name box.
3. In the Use the template list, select…

Read more

Question:

I want list of all error codes & messages of SQL server.

Answer:

Once some ask this thing to you or this though comes to your mind, I am sure most of us will start goggling or looking into BOL for the details

But SQL server also Contains one… Read more

Hey Friends

I missed you so much in my vacations.

I come back from my leaves & hope now we have regular interactions.

Read more