Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

MSSQLFUN

I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.

Archives: October 2012

SQL Server 2012 CU4 Is Now Available !

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

0 comments, 288 reads

Posted in MSSQLFUN on 16 October 2012

Multilanguage Table, How to insert different language text in table ?

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

0 comments, 816 reads

Posted in MSSQLFUN on 15 October 2012

IMPORTANT MESSAGE || http://MSSQLFUN.WORDPRESS.COM is now http://MSSQLFUN.COM

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

0 comments, 327 reads

Posted in MSSQLFUN on 15 October 2012

How to move the FullText catalog with SQL Server 2005 ?

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

0 comments, 423 reads

Posted in MSSQLFUN on 12 October 2012

SQL Server 2012 SP1 CTP4 Is Now Available !

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

0 comments, 299 reads

Posted in MSSQLFUN on 11 October 2012

SQL Server 2012 CU3 Is Now Available !

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

0 comments, 514 reads

Posted in MSSQLFUN on 9 October 2012

How to avoid windows REBOOT after any operation required restart ?

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

2 comments, 339 reads

Posted in MSSQLFUN on 6 October 2012

Is Instance name SQLEXPRESS is fixed for Express edition only ?

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

0 comments, 269 reads

Posted in MSSQLFUN on 5 October 2012

ReFS || next generation file system for Windows

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

1 comments, 137 reads

Posted in MSSQLFUN on 3 October 2012

SQL Server 2000 || DBCC CHECKDB logs entried in T-log file

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

0 comments, 172 reads

Posted in MSSQLFUN on 1 October 2012