maybe for performance reasons it is better to split up your queries !

This effort must only be done once (and at maintenance time...

What 's happening if he copies the 65/76Mb files again from his backuplocation to another location (or renames them) at the db-server and then sp_attachdb them to a new db...

I just checked a couple of servers and we also run extra sp_updatestats every 4 months as well as dbcc updateusage because auto-stats get inaccurate after a while.

check out : The Curse and Blessings of Dynamic SQL

http://www.sommarskog.se/dynamic_sql.html

Thanks Razvan Socol  ! That's what I was looking for

I'll take a look at the...

autoextend is indeed a slow process, but 1 - 2 hours

If you create a new db with a datafile of 700mb at...

Thanks for the feedback.

FYI :  we have auto-update-statistics on all our sql7- and sql2k-db.

I know it's a basic rule, but I wanted to work out a litle case so I can show developers the effect. Not only within QA, but also within their...

".. but the second one will return all rows in the table .."

No. Test it.

Left part contains only those with Associated?="No"

Right part contains only those with Associated?="yes"

joined by

July 28, 2004 at 3:46 am