Hello, My apologies if the question is too silly (am a novice) and if it is too vague (the details are specific to work). Details: The problem table 'Table A' has around 40 columns. 3 of the columns together constitute a unique non-clustered index. The problem: An update query whose where clause...

I wish to run DBCC FLUSHPROCINDB on a database called 'Batch'. I found the following example: DECLARE @intDBID INTEGER SET @intDBID = (SELECT dbid FROM master.dbo.sysdatabases WHERE name = 'database_name') DBCC FLUSHPROCINDB (@intDBID) But I don't understand it. Can someone please...

Hi, First thing I would do is to identify if any long running queries and then check its execution plan and needed fine tune it.