Viewing 15 posts - 1,426 through 1,440 (of 3,232 total)
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...
May 17, 2009 at 9:42 pm
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...
May 14, 2009 at 8:52 pm
FYI....I will have a chance to look at this tonight.
May 13, 2009 at 9:22 am
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/
May 13, 2009 at 8:49 am
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,...
May 13, 2009 at 8:41 am
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...
May 12, 2009 at 4:07 pm
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',...
May 12, 2009 at 1:43 pm
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.
May 12, 2009 at 9:59 am
Wow, that's big. Why don't you see what you can get it down to by zipping it up.
May 12, 2009 at 9:15 am
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...
May 11, 2009 at 9:43 am
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...
May 8, 2009 at 1:32 pm
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...
May 7, 2009 at 4:40 pm
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...
May 6, 2009 at 4:27 pm
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.
May 6, 2009 at 4:13 pm
Hmmm.....your counters have changed quite a bit since the first post where they were lower. I think running a couple hour perfmon will help tell the tale. To...
May 6, 2009 at 4:06 pm
Viewing 15 posts - 1,426 through 1,440 (of 3,232 total)