doug 88182 (8/24/2015)

---

I have a similar challenge.

I have 40 servers.

Each server has a [dbadb] database.

Each database has a view named v_DatabaseFiles that shows information on the database files...

Jeff Moden (8/24/2015)

---

I thought you just wanted commands. As for "top scripts", I'm not...

Ha! That's the plan, but I'm wondering now if I should...

I don't know. That's weird. But the site seems a little off today. A disturbance in the force perhaps.

In over 20 years working with SQL Server, I've only ever seen the OS files defragmented in handful of cases. Most of the time if you build your database files...

Threadizens, please don't skip posting your top scripts. I need help on this article.

Without seeing the query, I can't tell what you're running. As Jeff said, if you're using the Maintenance Plan wizard to do this, it's running for all indexes.

For index maintenance,...

lgluna20 (8/21/2015)

---

Hello

Thanks you very much for your answer

Sorry in case of the questions number 3 I was not clear about it.

Basically as you know SQL Server include Maintenance...

Please don't cross post questions. It just confuses the conversation.

Please post responses to this question over here.

You're basically doing the same thing as a side-by-side upgrade. That's a very straight forward mechanism. Lots of documentation out there on it. You have options and it depends on...

What it does is acts as a marker for if a given row has been updated. So you can read the data, get the current rowversion, then when you go...

Eric M Russell (8/21/2015)

---

We already have the SSMS Template Browser to cover commonly used commands and DMV queries.

However, the MERGE statement is complicated enough that it could use a GUI...

If you want to help out, here's the thread.

It really depends on your system. Most...

THREADIZENS!

Your knowledge is needed. I've got an idea for an article. It's meant to be a basics article for introductory level people. I want to put together that standard list...