GilaMonster (1/13/2009)

---

A single transaction is a single transaction, regardless of whether it's in one huge procedure of split up among several smaller procedures all called from a parent. Locks are...

DavidB (1/13/2009)

---

However, the template file will be usable in Profiler. If you script it out then you can run it via SSMS or a job and still have the same...

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

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