GermanDBA (1/13/2009)

---

Hi Grant,

as of yet no issues in itself. It looked extremely clumsy when you want to control the database objects between DEV,QAS and Prod systems. Maybe I/we...

I'm not a fan of maintenance plans, not enough control.

Use the TRY/CATCH mechanism to trap the errors. As long the error doesn't cause a disconnect, you should be able to...

nitinpatel31 (1/13/2009)

---

3. For code maintainability, it is always better to write SPs. But sometimes it may cause performance prolem. Sometimes it may cause the deadlocks. So it is...

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...