I have got a small example at http://rajanjohn.blogspot.com/2008/04/dynamic-tsql-vs-case.html; see if that can help you anyway

Mark, if we can preallocate space, cant we avoid page splits as there is no need of new page allocations? I am saying about a coniguous insertion on an index...

can please you explain why you think 2000 be installed before 2005?

hmmm..yes u are right; the size column does get updated in sql2k5. This wasnt the case with 2k. I checked other tables as well like master_files; they also are getting...

nope. The size column of the sysfiles table of each database will give u the current size (in pages). sysaltfiles givesyou the initial values.

can u please explain enough, what you really expect?

and make sure that the statistics are updated and compatability level changes are taken care of...

http://rajanjohn.blogspot.com/

well...the "default" is the cuprit this time 🙂

http://rajanjohn.blogspot.com/

I second Gila on securing the db from ad-hoc querying. I had this L2 support person who ran a select scan on a 27 million log records table on a...

Check the "size" value in master..sysaltfiles (sql2k) or sys.sysaltfiles (sql2k5)

http://rajanjohn.blogspot.com/

Are we looking too much into the questions and answers provided? Or do we think that the questions should be accurately deterministic? I believe a healthy debate/discussion is always good...

I think this could be either 1) a new Reporting Services installation, or 2) you directed the Reporting Services databases to a different database server.

In case 1), check the versions...

I think you posted the same conversation twice; please delete one to avoid confusions

I have seen this where there is a difference in the version/edition on the database server instance you use, and the Reporting Services instance you use. You should have both...

Great news! Congratulations to Steve for his efforts; public demand worked!