I was thinking the same thing....

I was thinking in terms of giant terabyte dbs, I guess. 🙂 Anyway, no index has a page_count higher than 21 from what I can see in sys.dm_db_index_physical_stats.

Thanks for...

All our tables are relatively small -- the biggest has about 266,000 rows. So you think I shouldn't be too worried about it then? I appreciate the feedback.

Thanks!

Ron...

Will Smith and Jeff Goldblum were not characters in Independence Day. They are actors who *played* characters in Independence Day. The characters were Steven Hiller and David Levinson....

Looks like I'm not alone in thinking we need some kind of editorial review over these Q&As, eh? I know English isn't everyone's first language, so I don't mean...

FYI: The link to your Optimizing Stored Procedure Recompiles article results in a 404, at least for me.

Ron Moses

ConEst Software Systems

Thanks AJ. I have tried using IDENT_CURRENT() but what I found is that it returns the same result on both a virgin table and a non-virgin table that has...

That's useful info, AJ.

Forgive me if this is an obvious question, but is there a way to get those values in script so they can be used in a conditional?...

This has been a headache for me, not knowing whether a table is going to reseed at 1 (virgin) or 2. Every technique I've tried to determine the "virginity"...

WayneS (5/2/2008)

---

Since the question clearly states:

use could use:

where DatePart(m, ) IN (1,3,4,5,7,8)

OR is not used, so since they BOTH...

Good script! This would be perfect for me if it included one additional item: Re-initializing all identity fields to 1. I can do it table-by-table but if there's...