Perry Whittle (5/25/2009)

---

the MOVE is only used when restoring a backup. When moving a data file location via ALTER DATABASE use MODIFY FILE. You can issue the statement while the...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic722961-392-1.aspx

What are the exact startup parameters that you have now?

There's no script to change an index from nonclustered to clustered. Drop the index and recreate it as clustered. Be careful which one you change. A poorly chosen clustered index...

There are side effects. Because the plan won't be recompiled...

Jeffrey Williams (5/24/2009)

---

So, of course - they changed that whole thing in 2008 and you can't have this database anywhere other than in the same directory as the master database....

No. Reason is that to move the files, SQL has to not be using them....

Excellent.

Now make sure that you have regular integrity checks scheduled. No need to specify data purity in them, it's a default once it's run successfully once.

If you have 8GB memory, make sure that SQL's max memory setting is set to no more than 6 GB. This is especially important on 64 bit.

What service pack do...

Sankar Reddy (5/24/2009)

---

Try this to pull the queries that have been executed the most on the server from the last server reboot:

-- Cached SP's By Execution Count

SELECT TOP (25) qt.text...

Not that I'm aware of.

What precisely is the problem? What are you trying to do, what is the...

It's cumulative since the server started. I wouldn't just divide by the number of days, that assumes that the IO load is identical every day (which it may not be)....

That's an apology?

It might, depends how active the server is and...