Steve Jones - Editor (1/13/2009)

---

OK, I'm really confused now. I was going to change the picture to a new shirt, but most people like the shirt.

Hmmmmm, I think I...

Brandie Tarvin (1/13/2009)

---

Actually, Grant, I didn't know about this Template scripter. Could you give me that too?

I was going to make due with what I had, but I'd like to...

And, SQL Server 2008 has a monitoring suite built in, although it's not as sophisticated as the offerings from Quest & Idera and others.

Seth Lynch (1/13/2009)

---

Hi

I suspect it is incomplete and someone put SET in by mistake and left it there.

The strange thing it that SQL Server 2000 seems to ignore it and...

It looks like incomplete code. I would have thought what was meant was something like:

DECLARE @fId INT;

SET @fId =42;

Of course with 2008 you can:

DECLARE @fId INT = 42;

Red Gate offers a tool that does a bare-bones, is it up or does it have a problem type of monitoring. Idera has a pretty good tool that does what...

Jack Corbett (1/13/2009)

---

Where I am at right now, part-time contract for 2 more weeks, there is one "minor" system on 2005, the rest are 2000 except for the Quality system...

nitinpatel31 (1/13/2009)

---

If proper transaction...

GermanDBA (1/13/2009)

---

Hi Grant,

I thought it sounded a little complicated the way that they had suggested.

It also seemed a little silly that MS would bring something like that to market, especially...

DavidB (1/13/2009)

---

Understood. Yeah, unfortunately there really is no cut and dry answer when it comes to performance tuning for queries hence why DTA can sometimes struggle. Ultimately what you are...

GilaMonster (1/13/2009)

---

DTA's got two undocumented features that it uses to do evaluations of cost improvement. One is the hypothetical index (an index that has all the metadata and stats of...

The reason I asked is because, what...

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