Something along these lines will work as well. I agree you should fix your data types. This will only work well if you've got good indexes too.

SELECT t.Name, t.Date, t.Time

FROM...

When you have the Job Activity Monitor window open, it's on the left in the Status field under a link labeled "View filter settings" and you can also get to...

One other thing you might look at. The Activity Monitor has a "filter settings" that might be filtering out the info that you expect to see. You should check that...

You mentioned a job that changes it's status between the time it ran and the time you looked at it. Did it run again during that time period? That's the...

If the history is getting cleaned up, it's from that properties page I mentioned. There is a way of removing history. It sounds like you might have a bit of...

Do you mean the history of the jobs? Or do you mean that a job failed at 3am, but succeeded at 6AM so it shows as successful? If the former,...

I assume there's a real difference between the number of users and transactions between dev & production? That alone will show a pretty large difference in behavior. But I'd still...

From what I can see here, I'd focus on the code. You've got a lot of waits occurring. Do you know why? You also have a reasonably high number of...

Nice article.

I'm not an SSIS expert, but I overheard our SSIS guru's discussing your article. They liked it. That's a good sign.

Before you start focusing on the server, I'd focus on the code and the structure of your database. Is the code set based or row-by-row? Is it using indexes to...

It's sample code from the BOL.

You could also set one of the parameters as OUTPUT and get it it that way.

ALTER PROCEDURE [Video].[addVideo]

@Title nvarchar(50),

...

13,000 or 30, if Access is going to require him to scroll through every select list to the bottom or it will retain a lock on that table... You have...

Straight out of the BOL:

USE AdventureWorks;

GO

-- Declare and set variable

-- to track number of retries

-- to attempt before exiting.

DECLARE @retry INT;

SET @retry = 5;

-- Keep attempting to update

-- table...

Jason Shadonix (4/17/2008)

---

Grant Fritchey (3/19/2008)

---

Hey, I lead a pack of Cub Scouts. I'm responsible for teaching them the "Fart Song."

[to the tune "The Yellow Rose of Texas"]

Oh, my body...