I'd agree with Lynn that is could be a Checkpoint.

Based on all the other indicators you list I wouldn't be all that concerned with it.

gary.mazzone (10/17/2011)

---

No source control? At this point I would simply say that evrything in Prod is correct and the most recent (that is what you are using so it...

I figured you missed it because I've seen your posts and know...

It looks like it should work as written. Have you tested it with just one of the criteria (application name or login name)?

Elliott Whitlow (10/17/2011)

---

I would store the filename as a last step in the load process and do the load process as transactionally as possible. Then at the top of...

GSquared (10/17/2011)

---

Well, this year I got to miss PASS because I spent the last two weeks migrating some database servers from one datacenter to another three times.

Tonight, I'm again up...

I'd love to see this type of licensing.

As has been mentioned you could start small, but then you could just scale up by buying more processor licenses without...

SQLRNNR (10/17/2011)

---

Evil Kraig F (10/17/2011)

---

Thanks for the link to that Gail, everyone in the office was wondering if I was dying slowly as I'm trying not to laugh aloud in...

ron.mcdowell (10/13/2011)

---

Here you go, Jack. Thanks for making me dig.

--SET LANGUAGE italian

--SET LANGUAGE us_english

DECLARE @StartDate date

DECLARE @DaysOut tinyint

DECLARE @DesiredDayOfWeek tinyint

DECLARE @TargetDate date

DECLARE @MaxDays int

SET @StartDate = '20111013' --The starting...

ron.mcdowell (10/13/2011)

---

No matter what, SQL makes my head itch. So no matter what, I comment...comment..comment.

Thanks Itzik Ben-Gan for the in-line number generator, and tally table crusader Mr. Moden for...

First of all, this is a good article that explains how to solve a problem. There is one issue with the solution though. It works for the language...

SQLRNNR (10/12/2011)

---

Ninja's_RGR'us (10/12/2011)

---

That's got to...

kurtlgreen (10/12/2011)

---

Jack Corbett

I appreciate your response. I do have 2 questions

1. How do i check the execution plan t5o look at the bottleneck

2. What do you mean by the wait...

I'm not a TX log expert, but I believe that is header information for the TX Log or for the backup. If you run TX Log backups a file...

With this limited information I can only guess that you have 2 objects on the report that both reference the same data.