Viewing 15 posts - 8,461 through 8,475 (of 49,552 total)
Wait. There's nothing you can do to speed up a rollback.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2014 at 10:43 am
Quick solution for what? I see a list of things that happened, but not a problem.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2014 at 8:43 am
Position of the columns within the table has no effect other than on queries doing a SELECT *
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2014 at 8:04 am
Probably, but they're far less preferable ways than expanding the drive.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2014 at 8:00 am
Oooh, vague questions for a Friday afternoon.......
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2014 at 6:50 am
http://www.amazon.com/gp/product/1430242035/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2014 at 6:49 am
Reinitialise the log shipping. Investigate why the log chain was broken
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2014 at 6:18 am
Viewing 15 posts - 8,461 through 8,475 (of 49,552 total)