Viewing 15 posts - 8,461 through 8,475 (of 49,571 total)
Wait. There's nothing you can do to speed up a rollback.
July 12, 2014 at 11:13 am
Giova (7/12/2014)
De default values are basically wrong: the one for cost made sense some years ago, the one for degree has always to be changed.
Cost threshold should always be...
July 12, 2014 at 11:12 am
btw, you do realise that if you offload the backups onto the secondary it's considered to be active for the purposes of licensing?
July 11, 2014 at 11:00 am
So it does work. What's the problem then (and you probably shouldn't be using the GUI in a disaster situation, especially if it's throwing incorrect error messages)?
p.s. That error is...
July 11, 2014 at 10:49 am
*sigh* Why do people post questions in the forums and then send me PMs, occasionally multiple ones notifying me of that fact?
July 11, 2014 at 10:43 am
Quick solution for what? I see a list of things that happened, but not a problem.
July 11, 2014 at 10:42 am
Newbie0809 (7/11/2014)
I could not apply any trx log backups on a copy only backup. This means I need to run my full backups on the primary server?
You're tested that...
July 11, 2014 at 10:41 am
Your reply has nothing to do with what I asked...
Have you checked and verified that the application can handle the connections being killed? If not, do you have any idea...
July 11, 2014 at 10:36 am
Grant Fritchey (7/11/2014)
You would want the fixed length columns stored first and then any variable length columns.
Not really, because SQL stores the columns on the page that way no matter...
July 11, 2014 at 8:43 am
Position of the columns within the table has no effect other than on queries doing a SELECT *
July 11, 2014 at 8:04 am
Probably, but they're far less preferable ways than expanding the drive.
July 11, 2014 at 8:00 am
Oooh, vague questions for a Friday afternoon.......
July 11, 2014 at 6:50 am
July 11, 2014 at 6:49 am
Reinitialise the log shipping. Investigate why the log chain was broken
July 11, 2014 at 6:47 am
Plus recompile relaxes the rules about the plan being safe for reuse, plus there's the additional visibility into table variables, probably other stuff too.
July 11, 2014 at 6:18 am
Viewing 15 posts - 8,461 through 8,475 (of 49,571 total)