The only real drawback is the pattern of the file changing or you not accounting for something with the conversions.

The other options are writing some type of script that looks...

clustered?

Eric M Russell (1/27/2015)

---

Regardless of datatype, I don't want to see a column names having no contextual prefix, meaning just "ID" by itself, on any table, and much less on...

Wow, what's in there, if you can disclose.

Any chance you want to write about the challenges of doing anything...

GoofyGuy (1/28/2015)

---

... there might be a legitimate complaint, but often we need to discard this one form as an outlier.

Chances are it seemed legitimate to the person who wrote the...

Only time I've used this is when we have the mdf, but not the ldf. This is almost always because someone never set up backups and tried to move a...

Yesterday in Denver

Me too,...

Eric M Russell (1/26/2015)

---

So, deploying a new procedure, table, or column days or weeks before the associated application change is deployed? Yes, that happens all the time in my universe...

mike.gallamore (1/26/2015)

---

Or applications that sit on top of someone else's database: say health care systems, CRM etc. Often it becomes the job of the front end guys to quickly re-wire...

I should, but I don't. I thought more in this article would have the link, but they don't.

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/120925/

I want to say that it's around 600 pixels.

My advice is to think...

We shrink automatically if it doesn't fit. There's an option on those images to zoom in with a click

Maybe a simple question, but after the rebuild, is the fragmentation low or is it unchanged?

Not sure what you mean? The Service Pack is a file you just run. What MSIs do you need?

Whatever you did to add the login on the primary, you need to do on the secondary.

There are scripts that will pull out information for a login from the instance,...