Viewing 15 posts - 11,131 through 11,145 (of 49,563 total)
IgorMi (10/31/2013)
If an escalation occurs then, it'll switch from ROW to TABLE lock, skipping the intermediate PAGE level which is currently OFF. You'd better have PAGE level set to ON.
Escalation...
October 31, 2013 at 5:55 am
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 both...
October 31, 2013 at 5:52 am
tony28 (10/30/2013)
GilaMonster (10/30/2013)
October 31, 2013 at 1:40 am
If you keep maxdop at 0, then there can be as many active threads for each query as you have cores. If you put maxdop to 4, then each query...
October 31, 2013 at 1:32 am
Just 1 \ and an n will do it. How do you escape things? I tried a few random things and didn't work. Can't the software do that?
October 31, 2013 at 1:31 am
Ask yourself, which is preferable, a corrupt database that you know is corrupt or a corrupt database that you don't know is corrupt.
CheckDB when run without a repair option (which...
October 30, 2013 at 3:44 pm
In short, no. You would have needed to have a trace or an extended events session running at the time.
October 30, 2013 at 3:43 pm
A restore recreates a database exactly as it was at the time of the backup.
October 30, 2013 at 1:04 pm
bbsr (10/30/2013)
so on both installation I would have to create named instances - servername\sql2008named_Instance and servername\sql2012_namedInstance and I cannot have a default instance on any of them?
One of them can...
October 30, 2013 at 9:32 am
You can't install two default instances. If you install 2008 as the default instance then 2012 will have to be a named instance. You can install both as named instances....
October 30, 2013 at 9:31 am
I remember seeing a CV where someone had rated himself 10/10 on 4 versions of Windows (XP, 2000, 98, NT4), two versions of SQL Server (2000, 2005) and a version...
October 30, 2013 at 8:29 am
tony28 (10/30/2013)
Like I said, I didnt see yet problem with no lock ...
Doesn't mean it didn't happen. If you have locking problems, consider one of the snapshot isolation levels....
October 30, 2013 at 8:23 am
Task manager is limited, it doesn't show memory allocated with the AWE API (which is used when you have locked pages enabled)
October 30, 2013 at 7:58 am
Viewing 15 posts - 11,131 through 11,145 (of 49,563 total)