I don't think that's true. The pages are smaller on disk, but in memory they are still 8kb pages. So it's not fewer pages, it's fewer IO operations that you...

So we can help you understand this, but you're asking a very general question, without any work on your part. The answer could be taken in a few contexts, so...

Ha, that's not a test. Unless you mean there...

That was good. Thanks.

http://msdn.microsoft.com/en-us/library/ms187030.aspx

Advanced option.

http://msdn.microsoft.com/en-us/library/ms187882.aspx

Since I work for Red Gate, here's SQL Doc:

http://www.red-gate.com/products/SQL_Doc/index.htm

I think most of them have evals. I'd give them a try and pick the one that works best for you out...

BTW, I had the chance to meet Jeff in Seattle and it was a pleasure. The rest of you should try to look him up if you can.

I missed Roy,...

No worries, Adam, and perhaps I didn't express myself well before.

Price is a good measure, but not perfect. I think it's worth it for us to try different things. Note...

Jeff Moden (11/10/2010)

---

I guess the next question to ask is, has anyone written a "spackle" article (think "Requested Article") on how to return the top 2 items from each group,...

Adam Gardner (11/10/2010)

---

Steve - Ever try to ride your bike to work via Bus/Train in Denver? I have many times. It's a nightmare. Arrive at work sweaty - no place...

Sorry, in 2008 mode. No default trace in SQL 2000.

Look for user objects or data in model. There shouldn't be anything.

never seen this. Creating logins should just touch some system tables in master (principals tables), nothing else. If you were creating lots, possibly you could block some connections checking against...

That's a good question. It's not that you update less pages, but that the pages are smaller when written to disk. I think that the log is still the same...

Partitioning is important, but also if these are LOB type columns in here, think about vertically partitioning because of some of the issues around index rebuilds with LOB columns (no...

You can also start in single user mode, connect with the DAC with a windows admin if you are stuck.