Hi, This stored procedure is taking a hell lot of a time. This SP returns only 2000 records but it takes close to one minute... I suspect this is...
Hi, In a proc, how do i get the error description for the error? We can get the error code via @@error but how do we get the exact description/...
Cool Beans!!! Thanks for your help Adrian
Thanks a lot Adrian and Mohammad... Very much appreciated for your timely help. I need a small suggestion for the query performance. I was suggested...
Thanks a ton Adrian for your prompt response... Again I have a question here. The scenario here is If the customercode is TBC I dont need to filter...
Folks, I have a tricky situation where in I need to fetch all the value from a table if the input criteria is of a particular value. For e.g. If the...
Sending data to a particular port --------------------------------- I need to send data to a particular port on modification of a table. Is it...
Thanks a lot Satya... The article is very informative Luis that was an amazing reply from you... I didnt know that testing is one way by which we...
How can find if there is a parallelism problem in the server or not??
Hi there, Can anyone tell me why SQL Server is always appending the primary key to all the secondary indexes? I have an index on "Source No" field...
Hi there, I've a small question on parallelism... Here is a gist ab the application - 1) The application on which am working makes use of lot of...
Hi there, I need a small clarification... When we run sp_spaceused it displays results of database_size, unallotted space, reserved space, Data...
Hi all, Am getting the following error wholce executing the stored procedure... Can neone help me out?? Cursorfetch: The number of variables...
Thanks a lot the replies folks... Much appreciated. Another Q here... The value of Process (SqlServr) % Processor time is consistently over 100%....
Thanks a ton Loui. The article was very informative but I couldnt find the best values for the counters which I'd mentioned. Any pointers? Regards...
Hi there, Can anyone let me know what should be the limit for these counters? 1) SQL Server Access Method: Full Scan/sec 2) SQL Server Access...
Bingo!!! It makes use of the server side cursor... The basic problem with this product is, these folks migrated from a native server to SQL Server....
Hi there,<br /><br />JoeChang, you are correct. ROWLOCK is used in sync with UPDLOCK. Its not used when READUNCOMMITTED is used as the hint. FYI, the...
Hi Frank,<br /><br />Thanks for your suggestion - The following are the points mentioned in the link which you had given. But I do have some concerns...
Separate names with a comma.
