Viewing 15 posts - 136 through 150 (of 237 total)
GilaMonster (10/31/2013)
SQLSteve (10/31/2013)
So you would advise to turn Row Locking off?
I wouldn't recommend that, not without a very good reason (of which to be honest there aren't many)
Default has...
October 31, 2013 at 5:56 am
HI,
So you would advise to turn Row Locking off?
I was going to enable page locking either way but wasn't sure whether to have both enabled or not.
October 31, 2013 at 5:48 am
Did you take a backup of the system databases prior to the to the upgrade? If so, and you have no idea (you haven't provided much information) about how to...
October 30, 2013 at 8:04 am
muthyala_51 (4/29/2013)
Does the new Service account is added in the Local administrator group on both the servers (Primary and seconday)?
This is not required - The account just needs to be...
October 30, 2013 at 5:59 am
easy way to unlock an account without actually knowing the password is to
1) be alerted the the account is locked
2) Take password policy off
3) put password policy on
This does...
October 30, 2013 at 5:31 am
In addition, i have also just noticed all of my VMs which have (hypervisor) at the end are running SQL 2008 r2.. then ones with (VM) are running non R2.
So...
October 30, 2013 at 5:23 am
The majority of the time I normally just have my system databases (Data and log files) with the user data files
C Drive - no SQL
1) system databases, user data files
2)...
October 29, 2013 at 4:49 am
What is the reasoning behind this? Alerting?
Theres an app for your phone called 'touch mon' this has the functionallity to allow you to monitor alerting on the go.
October 24, 2013 at 5:14 am
I am a DBA and yes it was accidental, I applied for an IT job not really knowing what I would be doing after college and 5 years later.. here...
October 23, 2013 at 3:26 am
Appreciate your feedback guys and Gail I have also had situations where processes have come to a standstill, I have updated stats and it has helped it move forward.
Update stats...
October 10, 2013 at 9:08 am
George M Parker (10/10/2013)
SQLSteve (10/10/2013)
Whats the rule of thumb for this? There...
October 10, 2013 at 7:08 am
RTaylor2208 (10/10/2013)
October 10, 2013 at 7:07 am
Also,
Can you still reindex\Rebuild an Index if page locking is not allowed? Only Row locking?
October 10, 2013 at 3:10 am
Viewing 15 posts - 136 through 150 (of 237 total)