2014-03-17
601 reads
Rohit Garg
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...
2014-02-25
5,105 reads
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...
2014-02-13
3,363 reads
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...
2014-02-03
751 reads
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...
2014-02-03
1,216 reads
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...
2014-01-30
1,124 reads
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...
2013-12-11
1,090 reads
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...
2013-11-04
838 reads
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...
2013-11-04
988 reads
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...
2013-10-15
1,390 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers