1) Actually for performance, I'd do this:

IF NOT EXISTS (SELECT * FROM Users WHERE UserID = @UserId)

BEGIN

If you need to use the parameter value @Name later, then the first choice...

You guys are describing how to save the trace definition, not the template. Is that what you need Brandie?

I don't know the precise mechanisms (you'll need to ask Microsoft) that the DTA uses, but I know that it relies on the statistics on the indexes and tables and...

Jeff Moden (1/13/2009)

---

True enough, 2000 is out of support... now, tell me it's out of use. Hmmm... that would make a good survey question... I'll think there's almost as...

If you're not using SSIS, you might want to look into it.

I've used VS2008 TSDBE in a team environment with the database objects all in source countrol in TFS. It works really well, especially the new GDR version that works with...

Functionally, I don't see any major difference between the two. Seriously. However, since we're dealing with human beings, I agree with you. Never over-write an existing back-up, using a single...

Jack Corbett (1/12/2009)

---

Of course these means that CTE's are out...

Can post the whole execution plan? Save it as .sqlplan file and zip it up.

On a guess, it's performing an aggregation to satisfy the criteria. It might be accessing the...

rons (1/12/2009)

---

I am confused about 2 things regarding the restore script:

1) What is the "logical device" and how is that usually expressed? Same question for the physical device location?

...

gary (1/12/2009)

---

I think ive just found a snag to the previous code

Im on SQL Server 2000 and i read CTEs are not supported?

From what ive read also, my first example...

Beating accepted. 😀

I just remember seeing the solution in his book. It's not something I played with a lot myself, mainly because I long stopped worrying about gaps in an...

Yeah, but "reflect in another block"?

Utterly and completely lost me on that one.

Jack Corbett (1/9/2009)

---

Every married man has a "She who must be...