Hi, I have an appliction which run the following two SQLs in the order: 1.INSERT INTO tab1 WITH (ROWLOCK) 2.DELETE from tab1 WITH (ROWLOCK) This...
Hi, I have a program which insert/update thousands of rows in a table (this table has millions of rows), some other programs are doing DML...
Hi, I have table which has an index on (col1, col2), if in my query the where clause is col2='a' and col1='b', does it matter?
Hi, I need to join two big tables and return all rows of the tables. The problem is the two tables are big so the performance of the query is very...
Hi, I try to tune a slow query: SELECT 1 FROM tab1 WHERE col1 = ? AND col2 = ? AND col3 = ? AND (SELECT COUNT(col1) FROM tab2 a...
All,<br /><br />Thanks in advance for your help. Any help is appreciated.<br /><br />I have a urgent production deadlock issue. Because of the...
Hi, Thanks in advance for your help. I am working on a blocking issue of a production db. I try to implement something so SQL Server can send me an...
Hi, all: I issued a query on two tables: SELECT p.pcol1, ISNULL(COUNT(b.bcol1), 0) FROM p LEFT OUTER JOIN b ON p.pcol2 = b.bcol2 WHERE b.col3 >=...
Hi, All: I have a huge table in a production DB need to do some cleanup duties, I decide to only keep one month data in that table and delete all...
Hi, All: I plan to run Profiler to monitor the SQL transactions of a SQL Server 7.0 server, but I try to minimize the performance interference, so I...
Hi, All: I have a question about adding index to improve the performance of the query. I have a big table called c and relatively small table...
Separate names with a comma.
