Jeff, that is awesome stuff! Thanks! I see what you're saying about the earlier post and the missing DBCC UpdateUsage... all around cool stuff!...

Jeff Moden (7/17/2009)

---

The following takes about the same time as the sp_MSForEachTable and has the distinct advantage of returning the row counts as a sortable single result set instead of...

Nice! Like the column name...

Try this:

[font="Courier New"]

USE *your_db_name_here*;

GO

sp_MSforeachtable 'select ''?'' Tablename, count(*) ''Rows'' from ?';

[/font]

Michael D'Andrea (2/15/2009)

---

TJ (2/13/2009)[br]

............If you think it's a hoax then demonstrate it, where and how is any of the current theory incorrect, misguided, improperly researched. Let me guess, you have...

Michael D'Andrea (2/12/2009)

---

I am disheartened by the responses to this topic. There is plenty of climate change denialism going on here, and for people purportedly in the higher percentile of...

If you came to me and told me that you had results from a test that showed something MIGHT be happening, but you could only rely on a small subset...

Global warming has been debunked!

http://www.junkscience.com

http://www.discussglobalwarming.com/blog

http://www.newsbusters.com

mtucker (2/12/2009)

---

AspiringGeek (2/12/2009)

---

Here are two interesting articles. The first is a review of the scientific literature:

Environmental Effects of Increased Atmospheric Carbon Dioxide

http://www.michaelcrichton.com/speech-ourenvironmentalfuture.html

The next...

cgreen (2/12/2009)

---

*wonders* is global warming the earth's way of shaking us off?

The earth will be here for billions of years global warming or no. I am merely concerned for your/other...

Yes, I found that back in 2007 here too:

http://www.discussglobalwarming.com/blog/2007/03/06/the-great-global-warming-swindle-to-air-on-uks-channel-4/

The sun is our primary source of climate issues. I'd like to see these arrogant people consider tweaking...

cgreen (2/12/2009)

---

I read about global warming in book about the solar system from the 70s - I don't think Al Gore invented it!

the predicted rate of change is about 50...

Maybe Al didnt "invent" it, but he has surely found it to be a vehicle to fatten his wallet. "The Earth has a fever!" -- oh please. ...

Global warming is a hoax that is conceived and perpetuated by Al Gore, and his cronies, to advance his wallet via this "carbon credits" scam. That inconvenient truth movie...

Global warming is a hoax that is conceived and perpetuated by Al Gore, and his cronies, to advance his wallet via this "carbon credits" scam. That inconvenient truth movie...