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/...
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...
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 all, Am getting the following error wholce executing the stored procedure... Can neone help me out?? Cursorfetch: The number of variables...
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...
Hi there,<br /><br />When does the lock escalation happens in SQL Server 2000? Say if a transaction acquires a index (or key) lock, will it escalate...
Hi all I need a clarification... Which one out of this two (sp_prepexec and sp_cursorprepexec) will perform better. Beleive making use of a cursor...
Hi there Is it possible to have more than one dbo for a database? If so is there any query which lists all the dbo names for a particular database?...
Hi all Am facing some difficulty in obtaining the table name and where clause from a table (which has the result from the profiler). No stored...
Hi all Can neone lemme know how to load a SQL trace file to a SQL Server table. Thanks Sri
Hi SQL Guru's What is the difference between Serializable and Read Committed wrt locking? In a serializable locking, if a data is locked - the...
Hi all Can anyone let me know what this concept is?? As per my understanding, the SQL Lock Manager attempts to escalate the finer locks to a coarser...
Which one is better?? using select and traversing thr' the recordset to get the first record or making use of Select TOP 1?? eg Select * from...
Hi all What is the query to SELECT ALL THE TABLES from a database? Pl lemme know Sri
Hi all What is the difference between using the lockinh hint as REPEATABLEREAD and (REPEATABLEREAD,ROWLOCK)?? If am not mistaken REPEATABLEREAD...
Hi all Can neone lemme know how to archive the datas? Is there any tool to acheive the same? Any pointers to this will be highly appreciated......
Can anyone please lemme know how to update the statistics
Separate names with a comma.
