Viewing 15 posts - 4,546 through 4,560 (of 49,552 total)
No.
A snapshot is not a backup. It's just a collection of the original version of pages that have changed in its source database since the snapshot was created. It...
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 12, 2015 at 2:46 am
If you want people to help you, you're going to have to post more than that. Start with table definitions, sample data (in the form of insert statements) and your...
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 12, 2015 at 2:42 am
nadersam (10/11/2015)
1. The inner joins between tables.
2. Where conditions defined in the view
3....
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 12, 2015 at 2:41 am
There's no such thing as a nested transaction. It's just syntatical lies.
Naming a transaction does nothing at all. It's basically a form of documentation, it's ignored almost everywhere.
The first begin...
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 12, 2015 at 2:39 am
Duplicate post. No replies here please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1727146-3077-1.aspx
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 12, 2015 at 2:36 am
Why do you want to shrink the log? Have you identified and fixed what caused the log to grow in the first place?
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 12, 2015 at 2:35 am
Before you do anything, you need to identify why the database went suspect. Check the error log. Look for ALL messages relating to the database from when the disks went...
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 12, 2015 at 2:34 am
MiguelSQL (10/9/2015)
http://www.braindump2go.com/70-462.html --> $100
Buyer beware.
https://www.microsoft.com/learning/en-us/certification-exam-policies.aspx
If a candidate violates any testing rule, exam policy or term within the exam agreement (NDA), or engages in any misconduct that diminishes...
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 9, 2015 at 1:15 pm
Which one you go for depends on your requirements.
If node 2 fails, and instances 3 and 4 fail over to node 1, are the applications which use them required 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 9, 2015 at 9:31 am
Probably still too high, the OS needs more than 6GB or memory to manage 256GB. I'd suggest no higher than 110 for each instance to start with, or you're going...
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 9, 2015 at 8:53 am
Those new values are way too high, you're leaving no memory for the OS under normal conditions, and near guaranteeing major memory contention if there's ever a failover. Even the...
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 9, 2015 at 8:43 am
Sean Lange (10/9/2015)
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 9, 2015 at 7:56 am
thebrewersinaz (10/9/2015)
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 9, 2015 at 7:55 am
Perry Whittle (10/9/2015)
are you saying with a restore you wont see enough recovery to cause any impact?
No, I'm not saying that.
I'm saying that the recovery process after a restore...
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 9, 2015 at 7:47 am
thebrewersinaz (10/9/2015)
I am not really sure how a view would speed things up.
It won't.
If I have 20 users and they all call a view the view is created 20 times...
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 9, 2015 at 7:09 am
Viewing 15 posts - 4,546 through 4,560 (of 49,552 total)