Double post by Safari 🙁

If you don't know hour data, and how your data is used, you cannot determine your best clustering key. You can run database engine tuning advisor (DTA), but I would...

+1

Oh, I know. Btw, can you imagine that .net I unaware of mounted volumes? I find thata bit surprising. WMI is great 🙂

I'm already working on a similar case, but I won't post my result until it's finished. Unfortunately, you cannot find information about mounted volumes using T-SQL only.

Kimberly Tripp - The Clustering Index Debate is what you're looking for.

Thanks for the tip Grant. Evalutating the need for updating stats or optimizing the indexes was already on my todo list.

If I understand your scenario right. First of all, have you checked the link I posted? Secondy, SQL Server does not know what files or filegroups were in the previous...

Thanks a lot. Dropping RI would be, as you said, a pain when I had to implement it back, and most likely be guaranteed to include the same clustered index...

First of all, have a look at your execution plan, it can give you a few hints. If you do, you'll notice that the execution plan only has inner joins,...

Collation describes the following: Sort order for both unicode and non-unicode characters, codepage used for non-unicode data. As such, UTF-8 as collation makes no sense, as UTF-8 does not give...

Very much so yes. You specify that you want to replace the existing database with the one in your backup.

For more information: Restore arguments

CLR Table-Valued Functions

Almost at the bottom of the page.

rahulr.sharma (1/18/2011)

---

Well I just need a process to test it out. The Service Pack to be installed are already tested on different servers. I need a way to just automate...

There is nothing for you to do on your SQL Server, but the mail server you are using must allow relaying to external email addresses, and be able to forward...