Which script?

The original...

george sibbald (4/2/2010)

---

TheSQLGuru (4/2/2010)

---

1)

3) consider getting Hyperbac. <....snip........>I even don't have to worry about promoting it here on SQLServerCentral any more since Red-Gate just bought them! :w00t:

Disclaimer:...

That looks better.

Thanks Lutz

I just found this comment from Joe Sack concerning the MCM.

The next large update of MCM will be for the version after SQL Server 2008 R2. Those with SQL 2008...

lmu92 (4/2/2010)

---

Btw: What do you mean by "query manager"?

If you're using SQL Server 2000, the query shouldn't run at all since table variable as well as ROW_NUMBER function that I've...

lmu92 (4/2/2010)

---

CirquedeSQLeil (4/2/2010)

---

lmu92 (4/2/2010)

---

Is there any change to have a known maximum range between LOW and HIGH?

If so, you could base your query on the LOW column to narrow down...

I tried that one, but then decided to stick with WP-SynHighlight.

Steve Jones - Editor (4/2/2010)

---

Definitely version specific, though I'd also add I...

Which plugin do you use?

I ended up trying 6 or 7 before finding one that seemed good to me.

Also, what are your indexes for that table?

The default is 0. Your instructor might have set it to 80 for their purposes.

No single default fill factor is appropriate for all indexes. It should be evaluated...

lmu92 (4/2/2010)

---

Is there any change to have a known maximum range between LOW and HIGH?

If so, you could base your query on the LOW column to narrow down the number...

cgreathouse (4/2/2010)

---

OK, here it is

StmtText ...

18 months is barely a blip. I think this is fair.

Yes

Thanks Steve.