Home » Posts tagged 'SQL Server' (Page 2)
Tag Archives: SQL Server
Creation & Deletion of Database Snapshot by SQL Agent Job
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite interesting scenario. I did not go in deep why he has such requirement but I am clear that It can be done very easily. So let’s … Continue reading
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
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
DMV-9 : Digging out details of CLR Tasks……..sys.dm_clr_tasks
sys.dm_clr_tasks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/ms177528.aspx Returns a row for all common language runtime (CLR) tasks that are currently running. A Transact-SQL batch that contains a reference to a CLR routine creates a separate task for execution of all the managed code in that batch. Multiple statements in the batch … Continue reading
Cumulative Update – 12 for SQL Server 2008 R2 Service Pack 1 Is Now Available !
The 12th cumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 12 contains all the hotfixes released since the initial release of SQL Server 2008 R2 SP1. Those who are facing severe issues with their environment, they can plan … Continue reading