Viewing 15 posts - 11,251 through 11,265 (of 22,214 total)
GilaMonster (2/16/2012)
Grant Fritchey (2/16/2012)
The real shocker is that you don't occasionally get the 30 minute execution anyway.
Variables, not parameters, so no parameter sniffing and the optimiser probably mis-guessing the row...
February 16, 2012 at 6:26 am
Jody.WP (2/16/2012)
What is your database archiving strategy? I am asking this because I faced similar problems and our infrastructure guys is still taking their sweet time allocating...
February 16, 2012 at 6:17 am
If the amount of log space needed for the processing is 100gb, then I'd give it that much space and leave it alone. If you only have 100gb... yeah, I'd...
February 16, 2012 at 6:11 am
One thing that might make a difference is if you use the variables multple times or call gETDATE() multiple times, the latter can result in different values. If that's what...
February 16, 2012 at 6:07 am
Just remember that backups don't help down time. If you want to improve the recovery time in the event of an outage, in addition to the backups you have, you...
February 16, 2012 at 6:05 am
It sounds like a case of bad parameter sniffing, but you can't be sure unless you investigate. You'd need to capture the two execution plans, one for when it's fast,...
February 16, 2012 at 5:59 am
Yeah, if you have 2005, you can run a backup on one machine and then restore it to the other. That's about the easiest way to move a whole database...
February 16, 2012 at 5:53 am
I'd cheat.
Get a copy of Red Gate SQL Compare and just capture the data that exists in one database, but not the other. Very easy that way. But then, I'm...
February 16, 2012 at 5:51 am
Ah, you have a parallel execution deadlock. Here's a blog detailing this one. It is hard to troubleshoot. The article should help. This is frequently a bug and there's possibly...
February 15, 2012 at 9:37 am
Rowles (2/14/2012)
Here are some differences between derived tables and CTEs:
1) CTEs lend themselves to recursive approaches. Where as derived tables would generally...
February 15, 2012 at 5:27 am
You can also see the compile time values in the execution plan itself. Always check the first operator (SELECT for a query, INSERT/UPDATE/DELETE, as appropriate). That shows compile time parameter...
February 15, 2012 at 5:21 am
If you click on the Deadlock Alert in SQL Monitor it should bring up a window that has the basic deadlock information in it.
You can see the victim and...
February 15, 2012 at 4:42 am
I wouldn't modify anything until the migration was done and successfully implemented.
February 14, 2012 at 12:43 pm
Absolutely use the Upgrade advisor as Jeff says. That has to be step 1. If it identifies issues, address them first.
Run a backup. You want to be absolutely safe during...
February 14, 2012 at 5:08 am
Even the new AlwaysOn capabilities with SQL Server 2012 that include asynchronous updates are still just mirrors of the main database, not historical beyond the delay of the asynchronous updates....
February 13, 2012 at 7:30 am
Viewing 15 posts - 11,251 through 11,265 (of 22,214 total)