Viewing 15 posts - 11,266 through 11,280 (of 22,214 total)
GilaMonster (2/13/2012)
Dev (2/13/2012)
Just for clarity, what do you mean by "duplicating database is beter than taking backups"?Hot / Warm standby servers.
Those are HA/DR, not backups. They're great...
February 13, 2012 at 7:06 am
Try using OR in the WHERE clause. See what happens then.
February 13, 2012 at 6:04 am
Blocking is a part of the process of the system. You need to define your transactions such that they are as small and as short as possible. Tune the queries,...
February 13, 2012 at 5:12 am
Worth pointing out, if you have some money to spend, another way around this issue is to look at a third party tool like Red Gate Virtual Restore[/url]. It allows...
February 12, 2012 at 7:21 am
Dev (2/12/2012)
February 12, 2012 at 7:14 am
Yes, querying the missing index information from the cache is a useful starting point, but it's just that. Unfortunately, there are no good tools for auto-tuning databases. The Tuning Advisor...
February 10, 2012 at 12:32 pm
GilaMonster (2/10/2012)
pdanes (2/10/2012)
February 10, 2012 at 12:29 pm
Steve Jones - SSC Editor (2/10/2012)
Worth the read: http://www.newyorker.com/reporting/2011/10/03/111003fa_fact_gawande
Absolutely. I enjoyed that one a lot.
BTW, since you guys have no doubt stopped laughing over my applying to the mentor program,...
February 10, 2012 at 12:28 pm
If you don't have access to the report that has all the information, then you must have a traceflag enabled on the server so that the deadlock goes to the...
February 10, 2012 at 12:22 pm
Boy does that sound like an interview question.
Let's assume it is, the answer you give has to basically be, how do you decide if it's a DBA problem or not....
February 10, 2012 at 12:20 pm
My first thought is, OMG that's thick.
I looked through it. Nothing jumped out as obviously out of line. I was able to run it through SQL Prompt for formatting, so...
February 10, 2012 at 12:14 pm
To be sure you're capturing each transaction, the best bet would be to use a server-side trace. Here's an article[/url] that includes an introduction to it.
February 10, 2012 at 12:06 pm
David Benoit (2/10/2012)
sunny.tjk (2/10/2012)
I've the following events and no filtersSQL:BatchStarting
SQL:BatchCompleted
Audit Schema Object Access Event
Existing Connection
RPC completed
Audit Login
Audit Logout
Unless you are looking for connection information to be collected I would remove...
February 10, 2012 at 12:04 pm
pdanes (2/10/2012)
Grant Fritchey (2/10/2012)
I just started working on an article on the backup header, ...
Yay! I'm almost completely out to lunch on the subject of backups. I've been doing a...
February 10, 2012 at 9:09 am
Really depends on what's going on with the query. An inline table function is sort of like a permament CTE in that they're both just queries you're incorporating into your...
February 10, 2012 at 7:06 am
Viewing 15 posts - 11,266 through 11,280 (of 22,214 total)