Home » Posts tagged 'SQL Server 2012' (Page 3)
Tag Archives: SQL Server 2012
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 sort & save data in … Continue reading
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 2 : Go to Tool … Continue reading
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 & then move to Production … Continue reading
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 well manner. If Snapshot failed … Continue reading
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 move to Production after satisfactory … Continue reading