Viewing 15 posts - 7,441 through 7,455 (of 49,552 total)
Ok, so what metrics/stats/info do you have for the period in question?
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
October 22, 2014 at 3:10 am
What monitoring did you have running at the time it happened?
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
October 22, 2014 at 2:32 am
Additionally, the only time that mirroring is supported between different versions is as part of a rolling upgrade. To be honest it makes no sense any other time, because you...
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
October 22, 2014 at 2:29 am
Jack Corbett (10/21/2014)
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
October 21, 2014 at 11:13 am
Rather use two parameters. It's one of those good coding practices, a parameter should be one thing only.
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
October 21, 2014 at 8:11 am
Not possible
A restore recreates the database exactly as it was at the time of the backup. You'll have to do that in two parts, restore first, then split it up...
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
October 21, 2014 at 7:46 am
Me: I should probably get a DBA hat for when I'm focusing on security, encryption, data protection...
GM (Development): So that we know when to ignore you.
I do so hope he...
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
October 20, 2014 at 10:15 am
TheSQLGuru (10/20/2014)
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
October 20, 2014 at 9:21 am
It's a lot of work. It'll work, except for PRIMARY. It will leave test different to prod though.
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
October 20, 2014 at 8:40 am
How big is the database now? You said it was 50MB before, what is it now?
What does the query actually do?
How many rows are in the table now? How...
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
October 20, 2014 at 8:39 am
Ok, you don't need to get the IDs back. What you want to do is send parent and child data to the stored proc (table-type parameters are fine for this),...
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
October 20, 2014 at 7:52 am
Shrink, then rebuild. As long as you don't shrink to 0% empty space, you shouldn't see too much of a file growth.
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
October 20, 2014 at 7:44 am
TheSQLGuru (10/20/2014)
If the column-based filters are on the same table I think you can manually create mutli-column statistics to alleviate the problem at hand here.
Doesn't work well, the histograms...
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
October 20, 2014 at 7:41 am
Sending multiple rows to the procedure's a great idea, but not if you then sit and loop through those rows one by one and insert them. You've done nothing to...
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
October 20, 2014 at 7:35 am
Wrap the COMMIT transaction in a check to see whether or not there are any open transactions. At the moment, if an error occurs and the catch block runs, SQL...
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
October 20, 2014 at 7:24 am
Viewing 15 posts - 7,441 through 7,455 (of 49,552 total)