Viewing 15 posts - 4,546 through 4,560 (of 49,571 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...
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...
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....
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...
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
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?
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...
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...
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...
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...
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...
October 9, 2015 at 8:43 am
Sean Lange (10/9/2015)
October 9, 2015 at 7:56 am
thebrewersinaz (10/9/2015)
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...
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...
October 9, 2015 at 7:09 am
Viewing 15 posts - 4,546 through 4,560 (of 49,571 total)