Ah. Could you post that example here, along...

Which is now available to any software assurance customers who have Team System for developers (and vis versa)

http://www.microsoft.com/presspass/press/2008/sep08/09-29VS10PR.mspx

Sorry. 🙁

That's what I get for posting while I'm doing something else.

[ hr ] Remove the spaces to...

Why do you need to rewrite?

Are they suddenly performing badly? Are they giving incorrect results?

Same kind of thing as a select statement that has a derived table (subquery) in the from clause.

The subquery resolves to a rowset that's treated as if it were a...

How big is the table in question? If I had to take a guess, I'd say it's fairly small, under 25 or so pages.

You can get the page count from...

The query processor operates on pages in memory. If it needs a page and the page isn't there, it sends a request to the storage engine to fetch that page....

Pro: SQL can use a lot of memory.

Con: SQL can use a lot of memory.

If you go 64 bit, make sure you set the max memory for SQL. What you...

Records won't be exactly be moved to make space.

If the row has to go onto a page and there isn't space on the page, the page is spit in...

Trace to file, set a reasonable size for the files. Once a file is no longer been written to, load that into a database (preferably on a different server) with...

Luke L (9/30/2008)

---

There are third party utils that basically do the same thing, but allow you to specifiy a threshold or queries that take more than 3 seconds to...

Yup, so something like this should work

UPDATE OrderDetails

SET ShipID = LatestShipping

from OrderDetails

...

Then you're going to need some form of trace running. I recommend a server-side trace as it will have the least impact. Set up the trace within profiler, tracing the...

The reason you can't connect is that your login has, as its default DB, the database that you detached. It doesn't matter where the DB is, just that it's not...