Home » Posts tagged 'SQL 2005' (Page 2)
Tag Archives: SQL 2005
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
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
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 requests with database files. You … Continue reading
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’, SERVERPROPERTY(‘EDITION’) ‘Version’, DATEADD(DD, 180, CREATE_DATE) … Continue reading
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, doing index Maintenance or checking … Continue reading