You should use SET STATISTICS IO ON and then run the query. This will give you real I/Os a query is performing. The lower the I/Os, the better the...
Raj How many records are returned as output of the above query? -Rajeev
Something like this: SELECT #inv, amount, (SELECT SUM(amount) FROM invoice WHERE sonumber = b.sonumber) SumAmount FROM invoice b WHERE b.sonumber...
When you issue the above statements without any locking hints, what locks does it acquire? If it still holds a table lock then try creating an index...
It would use up to 40% (someone correct me if I am wrong). It is not like that it would allocate 40% to locks when SQL Server starts. The default...
Give the users appropriate permissions and then you don't need to care where they are connecting from. Right? HTH -Rajeev
use DBCC TRACEON(1204, 3605, -1) in query analyzer. It will write the queries or sp statements that are part of deadlock in SQL Server logs. Then you...
What error does it give? Also, change your job to write the output of the job to OS file. Sometimes this file is very helpful in debugging. HTH...
There is no way to find out when a particular row has been inserted until and unless your database is in full recovery mode and you take t-log...
Well, did you try this? In the filters tab of profiler, when you select objectId or objectType filter, there is a check box in the bottom (Exclude...
Have you set processor affinity for SQL Server to use only 1 processor by any chance? -Rajeev Lahoty
Sometimes the performance impact can be huge. I have seen table variables not generating parallel query plans on a large SMP box while in the same...
10% of log space used means that out of allocated 100 MB allocated for log gile, you are using only 10 MB of space. Log might have grown because of a...
Try doing this: 1. Open perfmon. 2. Right click on this. 3. Go on Source tab. 4. Choose log file radio button and browse to the log file destination...
Thats exactly I did. I did take the difference for CPU for a particular spid after 10 seconds. And this high number came up. Waittimes I can clear...
I haven't seen any write log timeout. I have run DBCC SQLPERF('waitstats') but what does that have to analyzing this high value of waittime for...
HI guys When catching waittime for waittypes from sysprocesses, sometimes I see values as high as "2005188812" for WRITELOG and some of these kinds...
Amit is right that enclose database name in brackets. But it doesn't have anything to do with reserved word "USER". What is happening is that once it...
If nothing helps as Satya suggested, can you try increasing remote query timeout from 600 sec to 3600 sec and see if that works? HTH -Rajeev Lahoty
The following link explains the above hint in detail as to when it can be used and what benefits is provides and also how it works behind the scens....
Separate names with a comma.
