The 4thcumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative Update 4 contains all the SQL Server 2012 hotfixes which have been available since the initial release of SQL Server 2012. This update contains hotfixes for issues that were fixed after… Read more

Issue :

Today, I received one request from my old friend.

He wants to insert text in different languages in table. He is looking to create Multilanguage table.

Solution :

The simplest solution is to insert data in table as NVARCHAR data type, like below.

–Create Table

CREATE TABLE TBL_LANG Read more

Dear Friends

Firstly, I want to say thanks for your support & liking my blogs that make it possible.

I like to share this good news that http://MSSQLFUN.WORDPRESS.COM is now http://MSSQLFUN.COM.

Website Link – http://MSSQLFUN.COM

RSS Feed – http://mssqlfun.com/feed

Note : Old links will keep working, no change required. Read more

4 simple steps to move FullText catalog with SQL Server 2005 :-

1. Detach the database which contains the FullText Catalog. While detaching from Management Studio, there is “check box” called “Keep FullText Catalogs”. Make sure that this is selected.

2. Move the catalog files to the location where you… Read more

Service packs are very critical and important. It is very important from product upgrade & bug fixing point of view.

Microsoft has recently released SQL Server 2012 SP1 CTP4. CTP stands for Community Technology Preview and it is not the final version yet. The SQL Server 2012 SP1 CTP release… Read more

The 3rd cumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the SQL Server 2012 hotfixes which have been available since the initial release of SQL Server 2012. This update contains hotfixes for issues that were fixed… Read more

Issue :

Today, I decided to clear my desktop. I am currently running with around 10 SQL server instances with different names & versions, that I have created for different purpose & not required now.

I start uninstallation of SQL server but after one uninstallation, second uninstallation gives errors of… Read more

A Question “SQLEXPRESS instance name is fixed for Express edition only ?” is running in my mind. SO I have decide to test it.

First I have tried to install SQL server Evolution Enterprise edition with instance name “SQLEXPRESS” & it worked.

Now I tried to install SQL… Read more

Q) Why is it named ReFS?

ReFS stands for Resilient File System. Although it is designed to be better in many dimensions, resiliency stands out as one of its most prominent features. It will come with Windows 8.

Q) What are the capacity limits of ReFS?

The table below shows… Read more

Issue : When running DBCC CHECKDB on SQL server 2000, We are facing t-log growth & blocking.

Cause : DBCC CHECKDB does block in 2000 and earlier. The code for DBCC in 2000 was complex since it was working against a moving target (the database being modified), so to have… Read more