Grant Fritchey (9/3/2013)

---

You must use COPY_ONLY when backing up a database on a secondary server. When backing up a database on the primary you can run a regular backup, or...

Yes, but you need a union query. Each FTS query is single language. Use two with the LCID for each, joined by a UNION.

There isn't a "everything run faster" set of changes.

When you adjust indexes, you potentially adjust execution plans as well. This means some queries may run faster, some may not, choosing...

You can shrink it by specifying a size. Note that this might fragment your indexes quite a bit, and you'll need to rebuild them. If you don't have enough space...

Not sure that's true. I think 2000 supported named instances like the others. Don't see a restriction here: http://msdn.microsoft.com/en-us/library/aa176582%28v=sql.80%29.aspx

I might be wrong, but I'd think it would work.

Good draft, and good luck to everyone.

dwain.c (9/2/2013)

---

dwain.c (9/1/2013)

---

Brandie Tarvin (8/30/2013)

---

YAY! I have a new computer at work.

Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc....

Better explanation here: https://connect.microsoft.com/SQLServer/feedback/details/799431/please-dont-get-rid-of-the-mcm-and-mca-programs

However, IMHO, it's a poor one. If they are re-evaluating, no need to end this program before they build another one. If they aren't getting uptake, then...

TravisDBA (8/29/2013)

---

Miles Neale (8/29/2013)

---

TravisDBA (8/29/2013)

---

chappellc (8/28/2013)

---

Steve,

I would hope that you would at the very least forward this forum link to the person in question. Perhaps a solid verbal bashing...

One more vote for separate access and accounts in dev and production. It won't prevent it, but it can stop lots of silly mistakes.

Agree. I don't have...

Stunned

GilaMonster (8/28/2013)

---

Licensing for SQL Server is all about paper, the instances themselves have no idea how they are licensed.

Go speak with whoever did the software purchasing or is responsible for...

Never. We will always have prejudices and bigotry. We're human. We're frail and fallible...

I don't know you can do away with all of them. Most you can, and there isn't a summary that I know of. There are examples of where a cursor...