tvanharp (5/17/2009)

---

Sorry about the generic question, I am always hoping for that big thing that I missed that's very obvious. I will take you suggestion with the logging and compare...

By the way, here's how to manually code for short-circuiting:

, first the AND example:

-- Change this:

SELECT *

From syscolumns

Where IsNumeric(name) = 1

And Convert(Float, name) > 1.5

-- To...

Gianluca Sartori (5/20/2009)

---

Thanks for your opinion, Gail: I longly wished you came across this thread to shed some light.

Can you help us with some ideas on the short circuit...

Ewan Hampson (5/20/2009)

---

... He also said that at conferences - even at IT security conferences - people often leave their laptops unattended long enough for their login passwords to...

If you can provide us with the the table definition (CREATE TABLE ..., you can script this out from enterprise manager) and an example of what data change or action...

My rule of thumb for tracking down performance latencies in Windows environments: if it's slow, but it doesn't appear to be waiting for anything, then it's probably waiting for...

Here's the method that I have used for the last 25 years:

1) Flip the dictionary open and pick a word at random.

2) Repeat (1), picking a completely unrelated word.

3) throw...

"Rumpelstiltskin". Definitely. 😀

I could be holding open transactions waiting for the developer/engineer using the debugger, which could in turn be blocking other users on the server.

Florian Reischl (5/19/2009)

---

Hi Goldie

Try sys.dm_exec_requests view:

SET NOCOUNT ON

SELECT cpu_time, total_elapsed_time, reads, writes, logical_reads

FROM sys.dm_exec_requests

WHERE session_id = @@SPID

DECLARE @i INT

SELECT @i = object_id...

You can do it in a trigger, but it's probably not a good idea. That's because in SQL 2000 you have to use SQL MAIL which is synchronous and...

There's lots of COM stuff that isn't allowed in SQL Server/CLR.

Frankly, delimited is a heck of a lot easier to deal with in SSIS.

This one by Hilary Cotter is pretty good.

Please post the complete procedure code and the CREATE TABLE definitions of the run_stats, run_stats_err and the source tables.