Just out of curiousity, why would you want to do that? I can't see getting any performance advantage out of it.

Now wait a minute. First off, are we talking Windows 2000 or 2003? That makes a big difference. For Windows 2000, unless you're running Data Center Edition, aren't you limited...

Maybe I'm goofy, but I thought the hints were on indexes, etc. MAXDOP would have to be on the executed query - i.e. SELECT col1, col2, col3 FROM (view) OPTION (maxdop 1)

Ramesh,

I disagree. When the databases are on the same server, query plans are built the same from a view in the view-database as if it were querying on the base-table-database. You...

I don't know the answer to this, but wouldn't there be a difference that a SET would be deterministic, while select would not?

There may be implications regarding this (?)

Philip,

I suggest you stick with the GRANT CREATE PROCEDURE so that users can create sp's that are owned by themselves. The hard part comes in when they need to integrate...

nocheck disables the FK constraint...

check enables the FK constraint

If you're only looking to upgrade the existing instance from Developer to Enterprise, you only need to put in the EE CD and run the setup. It will detect the...

I've used ERwin for about seven years, but since CA bought it, it's gone downhill. True - many of the release 4 bugs are gone with the 4.1.4 release -...

Schema locks make sense in that you're dropping them within the transaction. I, personally, would rather focus on fixing the logic and keep the constraints inplace.

If you really need to ignore...

Steve,

Aren't the TRUNCATE_ONLY and NO_LOG synonymous?

Before you go too far with reinstalls, check your SQL Server log and see if you got any Access Violations when you tried to get the properties of a database...

Paula,

If this is not a warehouse/data mart, you're going to need a lot more space than that. First off, for you to optimize indexes, you'd need database freespace to rebuild...

Based on what you can find in the Knowledge Base, I'd be led to believe that you might have a disk subsystem that's failing on heavy utilization. That or it's just...

Don't you still have to backup the log with TRUNCATE_ONLY after switching? Easiest test would be through DBCC SQLPERF(LOGSPACE).