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,...

You're going to have to do this manually. I would suggest that you find a better way to do this moving forward. Kevin's script is good, but if you have...

I hate to say it depends, but it does. If you start a synchronous transaction on the primary, and it can't be committed to the mirror, it doesn't get committed...

Chris Harshman (1/23/2015)

---

My point was merely that no matter how much you THINK you know the business, you don't really know it like the people actually doing the business work....

Yep, but you need both files. If you lose one, then no restores.

Jack Corbett (1/23/2015)

---

Steve Jones - SSC Editor (1/21/2015)

---

So....

What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for the Friday...

Multiple files are striped backups - http://www.sqlservercentral.com/articles/Video/65295/

xsevensinzx (1/23/2015)

---

That's a pretty bold and general statement about open source that as someone said, depends on the situation. I mean, I use open source all the time. I use...

Andrew..Peterson (1/23/2015)

---

Sadly - that is NOT a very good sign. Other than PASS, where do they get their insight?

Now, if a company has a product that is not...

We don't have one. I see some in the BI forums, some in General.

What's the hotkey and definition here?

I think that ID as an acronym has a lot of meanings, including Identity Data or Identifying Data.

However, either way, I happily admit that I'm not necessarily consistent here. Orders...

Some info here: http://www.sqlservercentral.com/articles/FILESTREAM/67668/

Also, a free book we have: http://www.sqlservercentral.com/articles/books/94934/