I came up with the one-at-a-time approach when I was dealing with a third party app that mandated dozens of indexes and had 300 GB of data in it; even...

Yes, in fact that is the standard. Each connection to the primary is independently defined as synch or asynch, and in fact what you describe is the textbook approach...

This is how I do deletes when I don't want to impact production and I don't have a window dedicated to the deletes:

1) create a small table in the database...

If you are doing mass inserts and deletes to the same table, there is no magic bullet to speed that up. DML statements require more overhead by default to...

SQL!$@w$0ME (5/4/2016)

---

curtkrueger (5/4/2016)

---

I had this issue before, and it was due to me not using the fully qualified domain name when using VPN.

For example, our domain is xyz but on...

Eric M Russell (5/4/2016)

---

One downside of being a DBA is that we don't have interesting narratives to tell at the dinner table or at social gathering. Lawyers, school teachers, even...

If you ever end up in Columbus, OH (where I live), this is the nicest bookstore in town. It's not where you go to find a specific book, but...

The original store is gone, though the business still exists (wonder what they look like now). In the early 90s, this was pure heaven. Four stories of basically every...

Plus Jeff's suggestion on hitting the worst queries too.

Honestly, what I do as a DBA is make sure I have a monitoring tool on all of my instances. My...

You are on the right track with a baseline and deviation from the baseline. Really, that is all you have. Numbers that are bad on one server might...

This is the mentality that drives me crazy as a DBA. At my last job they were building a dashboard-type of report and wanted me to give them criteria...

Part of the confusion I think is because there are infrastructure DBAs and development DBAs and they are different tasks. The latter will spend most of their time in...

TheSQLGuru (5/3/2016)

---

Backup and restore works fine.

Detach and reattach works fine (beware the stats updates though - make sure you tell the script to not do those).

If this is a...

jasona.work (5/3/2016)

---

Lynn Pettis (5/3/2016)

---

jasona.work (5/3/2016)

---

Lynn Pettis (5/3/2016)

---

jasona.work (5/3/2016)

---

So, if the server is in a locked room, that...

Someone needs to find out what company the poster works for and put it on a list of places NEVER to work at no matter what they pay you. ...