Viewing 15 posts - 1 through 15 (of 495 total)
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...
May 5, 2016 at 9:33 am
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...
May 5, 2016 at 9:17 am
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...
May 5, 2016 at 9:11 am
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...
May 5, 2016 at 8:25 am
For example, our domain is xyz but on...
May 4, 2016 at 9:57 am
Eric M Russell (5/4/2016)
May 4, 2016 at 7:41 am
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...
May 4, 2016 at 7:04 am
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...
May 4, 2016 at 7:02 am
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...
May 3, 2016 at 2:25 pm
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...
May 3, 2016 at 2:22 pm
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...
May 3, 2016 at 1:55 pm
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...
May 3, 2016 at 1:48 pm
Detach and reattach works fine (beware the stats updates though - make sure you tell the script to not do those).
If this is a...
May 3, 2016 at 12:17 pm
Lynn Pettis (5/3/2016)
Lynn Pettis (5/3/2016)
Some people should not be allowed any where near a database server.
So, if the server is in a locked room, that...
May 3, 2016 at 12:10 pm
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. ...
May 3, 2016 at 10:38 am