I'd take a close look at your recruitment process. Around here developers and dba's get technical tests so we know they can walk the walk, not just talk the talk.

Any chance your front end apps are creating new connections for each call rather than closing and reusing connection correctly. If you have a single user session, with 20 calls...

Had one just this morning. A single query with a couple of bad joins on a 58mb database created a 7.5GB tempdb.

If it's not a production db and just a test db where the log has grown because you don't have a maintenance plan setup to back it up regularly then...

There procedure has parameters and I've made a few changes trying to split it out into separate queries but this is one of those catchall type queries which allows the...

Check out Performance Dashboard which is a free download from microsoft if you are running SQL2005 sp2. It's a little easier to look at than perfmon I think and lists...

With union you can have a single sortby which covers both queries in the union. Add another column to both queries and set the value to 1 for the rows...

Maybe crazy question but are you running any anti virus software? Seen a web server do something similar a while ago and altering how the anti virus software was configured sorted...

Sorry missed the bit about it being SQL2000. Not sure trace flags are as useful in 2000 but I have tracked down sql2000 deadlocks in this manner before.

Not sure your timeout makes a difference with deadlocks. Deadlock are where two queries are trying to get locks on 2 resources, query one locks object A and waits to get...

Big topic this one. The methods used may depend on what the objective of the testing is. Are you testing to check if the results are accurate and the query...

I've done something similar except I use a view to select rows which each client can select, update, or delete. I also have a further complexity in that I have...

If it's sql 2005 sp2 then you can use the microsoft performance dashboard which will show you all sorts of good stuff like the queries using the most cpu, io...

Try selection TOP 1 of the Sub query. That will get you 1 row in the sub query.

Update <table1>

Set <field1> =

         (Select TOP 1 <field2>

          From <table2> AS t2

       ...

I have what could be a related problem. We have a frequently used stored procedure which used to be slow but I have since rewritten it. Profile shows reads of over...