RBarryYoung (5/19/2009)

---

Florian: This looks similar to the performance measurement code that I posted in my last article (here[/url]). Unfortunately I just, found out last week that the elapsed...

Goldie Graber (5/19/2009)

---

I'd love to see your procedures, even though I don't know that they'll be useful in this case.

Sure, the elapsed time is the first thing the user notices....

Hi Pieter

Some questions:

1.) Do you call these functions in your WHERE clause?

2.) If yes, are the initial replacements "()-. " needed? They may be a very huge problem for another...

For usual tests I prefer the SQL Profiler for more special tests I use some procedures I wrote. I can post them if you want.

Sure, the elapsed time is the...

Hi

Try this:

dtexec /F "C:\DTSPackage\MySolution.dtsx" /SET "\Package.Variables[employeeID].Value";9 /SET "\Package.Variables[OtherVar].Value";9

Greets

Flo

Goldie Graber (5/19/2009)

---

Yup, sure do.

Do you mean to say that the CPU time is total of ALL processors?

If so, I guess...

Oups, sorry. Too many SSE2k in my environment yet...

I corrected the previous script and added schema-support and security for names 😉

Greets

Flo

Well... This is definitely a new chapter of "Coding for Fun" 😀

Compare and take your choice..

[font="Courier New"]SET NOCOUNT ON

DECLARE @now DATETIME

DECLARE @i INT

DECLARE @count INT

DECLARE @name NVARCHAR(128)

DECLARE @schema NVARCHAR(128)

DECLARE @sql...

GSquared (5/19/2009)

---

Greg Snidow (5/19/2009)

---

I often see code with semicolons here, but usually without. I have...

Hi Stephen

I think the people who can answer this question are you...

First question:

Do you think the customer may be lost if you don't introduce this security software?

Second question:

Is your customer...

???

What's the problem with the cursor? In my book cursors are okay for these maintenance tasks.

Anyway, you can use a string concatenation or FOR XML PATH() in combination with sys.tables.

Greets

Flo

Hi Goldie

Do you have a Dual/Quad Core environment?

Greets

Flo

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 FROM sys.all_columns

SELECT...

Hi Lowell

Some questions...

Is the ZIP file different for each consumer...