Rohit Garg

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.

All authors

Wishing You a Very Happy Holi

by Rohit Garg

MSSQLFUN

2014-03-17

604 reads

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

by Rohit Garg

MSSQLFUN

Table with clustered index is totally depended on index accessibility.
ERROR : The query processor is unable to produce a plan because...

2014-02-25

5,113 reads

System Configuration Check – Without Starting SQL Server Installation

by Rohit Garg

MSSQLFUN

Question : Can we do system configuration check with starting SQL Server installation? One of my friend need to submit it...

2014-02-13

3,371 reads

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

by Rohit Garg

MSSQLFUN

The 15th cumulative update release for SQL Server 2008 Service Pack 3 is now available for download at the Microsoft...

2014-02-03

759 reads

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

by Rohit Garg

MSSQLFUN

The 8th cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 8 contains all...

2014-02-03

1,228 reads

2013 with You & SQL Server

by Rohit Garg

MSSQLFUN

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

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

2014-01-30

1,129 reads

Database Snapshot failed due to disk space issue

by Rohit Garg

MSSQLFUN

Database snapshot is really a useful feature. As we know, Snapshot database file will keep increasing parallel to the DML...

2013-12-11

1,091 reads

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

by Rohit Garg

MSSQLFUN

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

2013-11-04

847 reads

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

by Rohit Garg

MSSQLFUN

The 9th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...

2013-11-04

996 reads

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

by Rohit Garg

MSSQLFUN

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...

2013-10-15

1,392 reads

All authors

Rohit Garg

Wishing You a Very Happy Holi

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

System Configuration Check – Without Starting SQL Server Installation

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

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

2013 with You & SQL Server

Database Snapshot failed due to disk space issue

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

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

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

Blogs

T-SQL Tuesday #200: When I Look at a Query …

Reflections on the Life of a DBA

Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables

Forums

ALAMAT KONTAK BCA KCP Pecatu Telp:08218154393

ALAMAT KONTAK BCA KCP Ubud Telp:08218154393

ALAMAT KONTAK BCA KCP Benoa Telp:08218154393

Question of the Day

TempDB Facts I