No, there is no blocking. We always calls all the procedures, prepared statements, adhoc statements with schema prefix. Before deployment, we do code...
I have already ran some queries against the following DMV and DMF, but that tells me what is in the plan cache, but doens't tell me what is causing...
Hi Satya, This is not a recompile, it is Compile, and they not exists in plan cache. I have already ran a trace with SP:Recompile &...
Hi, For last one week (since a new application release), I have been seeing lot of SQL compilations has been happening. We used to have 400-500 SQL...
I would also check against sys.dm_db_index_usage_stats to see how frequently each index is used. If you see more inserts than Selects on an index,...
Post your script and give more details on your issue
Post your script and give more deails on your issue
That is the biggest table we have 57GB in size, have 230 million rows of data (after the archival), for the current period. Yes, we do have lot of...
Hi, We have two query plans for the same "prepared SQL statement", one runs slower and one runs faster. The on runs slower does SORT operation which...
Does this design pattern work in T-SQL on SQL 2005? INSERT into sometable IF @@error <> 0 –expect 2627 unique constraint violation BEGIN UPDATE...
Did you specify any "Table Lock" hint. If you want to Row-level lock Set "Table Lock" to off....
If you want to convert rows into columns check out the PIVOT operator http://technet.microsoft.com/en-us/library/ms177410.aspx Thanks Dev
If you created that as shared rsource, the SSRS report might have overwritten the credential informations. Go to Datasources folder on the...
Yes I'm. I have also used sysinternal's PS tools, SQL trace, Idera, Nagios. Thanks Dev
No virus found. The server is on a secured network, no access to Internet from that VLAN. Does XCOPY causes any issue when you copy a file larger...
Hi, The available memory on a server is going down gradually and never come back to its initial available memory. The available memory went from 4...
Separate names with a comma.
