If you are using the procedure, my advice is to move the trigger logic to procedure.
I see a mismatch in these two answers. Can you explain more?
My understanding is in your trigger, you first insert into remote server and then insert into the current database. When you execute linked server...
By the way, Welcome to the forums. (I forgot to welcome you at the last post.) Is this question related to SQL Server 2005? Your last(First) post was...
sysPerfInfo is for SQL Server 2000 only. For SQL Server 2005, please use sys.dm_os_performance_counters. For your point, cntr_value is cumulative...
This is the link on the article: http://technet.microsoft.com/en-us/magazine/hh395481.aspx Another correction: He suggests that we can use that to...
I suspect that IndexC may be unnecessary. But you need to verify with the DMVs Frank mentioned.. Too many indexes will definitely increase the...
This may not be a complete list but a good starting point: Queries taking longer time than usual. This can happen as a frequent behavior or all of...
Welcome to forums: Couple of questions/comments: Do you have indexes on the columns used in JOIN conditions? If not, they are good candidates for...
I am sure you are going to get "It depends" type of answer. Batch requests says the number of requests which includes selects and amendments They are...
Welcome to forums. From the error I feel that the stored procedure is trying to access some columns from INDEX_INFO_DAILY where it is unable to find...
Welcome to forums.. I will go for server side trace on sp stmt completed and SQL stmt completed events and put a filter on Textdata like...
We do rebuild or reorg the indexes periodically. but they are not based frequency, but on fragmentation and size. If the fragmentation level is...
Looks like the advertisement is already deleted. :)
try this one: SELECT sp.[Column1] ,k.[Column2] ,po.[Column3] ,h.[Column4] ,c.[Column5] ,s.[Column6] ,wt.[Column7] ,Column8 ,Column9 ,Column10...
Is it possible to be more specific on the index improvement you have made. I suspected few clustered index scans as the culprits, but just want to...
Just to add to the confusion: I recently had a chat with a DBA. He sets the MAXDOP to 75% - 80% of the available processors or MAXDOP = (Number of...
Only once I saw an empty Proc cache efficient: We had a complex procedure where based on parameter values different plans are best.When a plan is...
I should be more specific in my communication :) This is what I was trying to say.... Statistics will not be there in all columns, and it is...
What I said is to go with 0 until you test and find a figure. Sorry for the confusion. Since Microsoft has suggested this, It is better to raise...
Separate names with a comma.
