What the heck do you...

2000 makes no difference here. Best thing to do is to rebuild the stats as well. But it's not critical

If this is a low usage server don't bother...

crookj (1/6/2012)

---

Been suffering from NEI

Not Enough Info. Can't make a good battle plan...

Such a huge number,...

With yearly rollup please?

So stop giving TMI 😛

Autostats will rebuild all the stats it needs. However if you have created stats manually then you need to copy those. If you changed stats settings you also...

No (we) don't.

I use on to make the join

then I use where to filter data I don't need after the join is made

Then I use having to filter on aggregates

Then...

Brandie Tarvin (1/6/2012)

---

At the risk of being virtually lynched, I can see the use in underscores in table names and especially in constraint names.

I shall now run away and hide...

Where the 1000 pages actually comes from... & the guy who wrote that code at MS!

http://sqlskills.com/BLOGS/PAUL/post/Where-do-the-Books-Online-index-fragmentation-thresholds-come-from.aspx

Greg Edwards-268690 (1/6/2012)

---

Ninja's_RGR'us (1/6/2012)

---

Kit G (1/6/2012)

---

All caps in the naming convention sucks. Using the "_" in the naming convention can make things more understandable at a glance, but makes...

Kit G (1/6/2012)

---

All caps in the naming convention sucks. Using the "_" in the naming convention can make things more understandable at a glance, but makes it a major...

Brandie Tarvin (1/6/2012)

---

Stefan Krzywicki (1/5/2012)

---

Speaking of venting vaguely, don't you just love when there's a third party tool (maybe even made by another group in your company) with a database...

Well actually I'd be concerned if it took 1 whole second to return so little data.

But I'll go on a limb and assume it's much less than 1 and let...

GilaMonster (1/5/2012)

---

Ninja's_RGR'us (1/5/2012)

---

GilaMonster (1/5/2012)

---

Ninja's_RGR'us (1/5/2012)

---

It's almost like they want to punish you for daring asking for money and making sure you NEVER ever want to go through that process ever...