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.

SQL Server 2000 || Disable sa login

Question : How to disable sa user in SQL Server 2000?

Reason : Due to Security requirement of audit, We have to disable sa user for all SQL instances in environment having SQL 2000 \2005\2008 & 2008 R2.

Answer : We can disable sa user from SQL Server 2005 onwards… Read more

0 comments, 57 reads

Posted in MSSQLFUN on 15 April 2014

Antivirus Exclusion Policy for SQL Server

Anti-virus & SQL Server on one system together are friends not enemies, if configured properly.

Anti-virus are very useful programs from security, audit & venerability detection & removal point of view. But if team managing anti-virus server did not configure anti-virus policies properly then your SQL Server is going to… Read more

0 comments, 89 reads

Posted in MSSQLFUN on 8 April 2014

Wishing You a Very Happy Holi

0 comments, 69 reads

Posted in MSSQLFUN on 17 March 2014

Steps for Windows Cluster Installation on Windows Server 2008

Here, You have steps with screenshot to install 2 Nodes windows cluster on Windows Server 2008.

Step 1: Validate Cluster Configuration

a) Open Cluster Administrator & click on “Validate a Configuration”

b) Wizard for cluster validation appears, click Next

c) Add Node to create cluster

d) Select Type of test… Read more

0 comments, 123 reads

Posted in MSSQLFUN on 17 March 2014

ERROR || The query processor is unable to produce a plan because the index ‘IND_TABLE’ on table or view ‘Table’ is disabled.

Table with clustered index is totally depended on index accessibility.

ERROR : The query processor is unable to produce a plan because the index ‘IND_TABLE’ on table or view ‘Table’ is disabled.

REASON : We find that some disable the cluster index due to which issue occur. Clustered index physically… Read more

0 comments, 126 reads

Posted in MSSQLFUN on 25 February 2014

System Configuration Check – Without Starting SQL Server Installation

Question : Can we do system configuration check with starting SQL Server installation? One of my friend need to submit it to get installation approval. This is to ensure that no configuration issue occur at time of installation.

Answer : Yes, We can do it.

Step 1: Run Setup.exe

Step… Read more

0 comments, 134 reads

Posted in MSSQLFUN on 13 February 2014

Cumulative Update – 8 for SQL Server 2012 Service Pack 1 Is Now Available !

The 8th cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 8 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.

Those who are facing severe issues with their environment, they can plan to test CU8 in test environment… Read more

0 comments, 224 reads

Posted in MSSQLFUN on 3 February 2014

Cumulative Update – 15 for SQL Server 2008 Service Pack 3 Is Now Available !

The 15th cumulative update release for SQL Server 2008 Service Pack 3 is now available for download at the Microsoft Support site. Cumulative Update 15 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

0 comments, 126 reads

Posted in MSSQLFUN on 3 February 2014

2013 with You & SQL Server

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

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 41,000 times in 2013. If it were a concert at Sydney Opera House, it would take about 15…

Read more

0 comments, 108 reads

Posted in MSSQLFUN on 30 January 2014

Database Snapshot failed due to disk space issue

Database snapshot is really a useful feature. As we know, Snapshot database file will keep increasing parallel to the DML operations on database. But if disk containing snapshot file run out of space then what will be the impact on new transactions, database & snapshot?

Microsoft design snapshot in very… Read more

0 comments, 288 reads

Posted in MSSQLFUN on 11 December 2013

Cumulative Update – 9 for SQL Server 2008 R2 Service Pack 2 Is Now Available !

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

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

0 comments, 271 reads

Posted in MSSQLFUN on 4 November 2013

Cumulative Update – 10 for SQL Server 2012 RTM Is Now Available !

The 10th cumulative update release for SQL Server 2012 RTM is now available. Cumulative Update 10 contains all the hotfixes released since the initial release of SQL Server 2012 RTM.

Those who are facing severe issues with their environment, they can plan to test CU10 in test environment & then… Read more

0 comments, 245 reads

Posted in MSSQLFUN on 4 November 2013

DMV-15 : Pending I/O requests……..sys.dm_io_pending_io_requests

sys.dm_io_pending_io_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms188762.aspx

Returns a row for each pending I/O request in SQL Server.

It’s a very simple DMV used to see all pending I/O requests & there description.

You can combine this DMV with DMF – sys.dm_io_virtual_file_stats to see I/O pending… Read more

0 comments, 205 reads

Posted in MSSQLFUN on 15 October 2013

Cumulative Update – 13 for SQL Server 2008 SP3 Is Now Available !

The 13th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 13 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 plan to test CU13 in test environment… Read more

0 comments, 209 reads

Posted in MSSQLFUN on 7 October 2013

Cumulative Update – 6 for SQL Server 2012 Service Pack 1 Is Now Available !

The 6th cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 6 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.

Those who are facing severe issues with their environment, they can plan to test CU6 in test environment… Read more

0 comments, 216 reads

Posted in MSSQLFUN on 30 September 2013

How to Check SQL Server Evaluation Version Expire Date ?

SQL Server Evaluation Edition is available free of cost. It’s a trial version & valid for limited time of period. The expiration date is always 180 days from the initial installation date.

The following query will give you the expiration date of evaluation instance :

SELECT

@@SERVERNAME SERVERNAME,

CREATE_DATE ‘INSTALALTIONDATE’, Read more

2 comments, 637 reads

Posted in MSSQLFUN on 16 September 2013

DMV-14 : Which Table has Max. rows & Size……..sys.dm_db_partition_stats

sys.dm_db_partition_stats DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms187737.aspx

Returns page and row-count information for every partition in the current database.

This DMV gives useful information about rowcount, free & reserved space of each table in database. It can be used for analysis purpose while adding new indexes,… Read more

0 comments, 198 reads

Posted in MSSQLFUN on 9 September 2013

Cumulative Update – 8 for SQL Server 2008 R2 Service Pack 2 Is Now Available !

The 8th cumulative update release for SQL Server 2008 R2 Service Pack 2 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 R2 SP2.

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

0 comments, 759 reads

Posted in MSSQLFUN on 3 September 2013

Cumulative Update – 9 for SQL Server 2012 RTM Is Now Available !

The 9th cumulative update release for SQL Server 2012 RTM is now available. Cumulative Update 9 contains all the hotfixes released since the initial release of SQL Server 2012 RTM.

Those who are facing severe issues with their environment, they can plan to test CU9 in test environment & then… Read more

0 comments, 271 reads

Posted in MSSQLFUN on 26 August 2013

Data Purity issue after upgrading SQL 2000 to later versions

In SQL Server versions prior to 2005, it was possible to have invalid data values into a database. That can lead to incorrect result or issue at time of query execution.

SQL Server 2005 brings new option to the DBCC CHECKDB and DBCC CHECKTABLE commands to solve this issue. “DATA_PURITY”,… Read more

0 comments, 284 reads

Posted in MSSQLFUN on 20 August 2013

Older posts