Wow....this one should make it to the 'evil' interview questions list.

Here's a breakdown of the counter values for your busy times. I don't see anything here that concerns me. The average values for Lazy Writes /sec are a...

I just started to look at the file. There's an awefull lot of data here. It looks like you've captured about 40 hours worth of data. That...

FYI....I will have a chance to look at this tonight.

There's an article on the home page of SSC now on ROW_NUMBER().

Here's the link: http://www.sqlservercentral.com/articles/T-SQL/66512/

You're already on the web-site!! I would search SSC for ROW_NUMBER() as there's bound to be an article or several dozen forum posts where it is used and explained.

Also,...

Ah, that will work. I was attempting to do just that when I came up with my version that used the RANK function. I just couldn't get away...

Here's a couple different ways to do it:

[Code]

DECLARE @Colors TABLE (ID int, Color varchar(12), Date datetime)

INSERT INTO @Colors

SELECT 1, 'red', '5/1/09' UNION ALL

SELECT 1, 'blue', '5/1/09' UNION ALL

SELECT 1, 'green',...

Attach it to this thread in your next post. Underneath the message window, there is a post options section where you are able to add attachments.

Wow, that's big. Why don't you see what you can get it down to by zipping it up.

So is the output broken down into multiple files? I would say pick one and add it to this thread as an attachment. I can then look at...

Dave,

I just wanted to say thanks for taking the time and effort for putting together the documentation in the attatchments. This is some really good stuff. You...

I, too, am without a degree. I changed my major 4 times in college beginning with criminal justice and ending with MIS. I left college 6 credit hours...

My bad. I though you meant in SSIS. This is an SSIS forum so I assumed your SP was being executed in SSIS. Sorry. I don't...

Double click on the precedence constraint between the two steps, change the Evaluation operation to expression, and then add your check against the variable in the Expression box.