Viewing 15 posts - 4,906 through 4,920 (of 9,253 total)
TJ-356724 (10/3/2012)
We are migrating from our current production environment from sql 2000 to 2008 r2 in about two weeks. Like the old environment...
October 4, 2012 at 7:23 am
October 4, 2012 at 5:24 am
GilaMonster (10/3/2012)
Anyway, read committed snapshot has the lower tempDB impact, snapshot isolation is usually more impact.
Is that absolutely true?
The way i understand it is that with snapshot isolation you first...
October 4, 2012 at 5:20 am
Jai-SQL DBA (10/4/2012)
Date 2:A went Crashed and B was made as Primary .
Please provide details of the steps you took!
Jai-SQL DBA (10/4/2012)
October 4, 2012 at 4:29 am
ananda.murugesan (10/4/2012)
I have checked at 9 AM there is no table locking and blocking that particular table...
October 4, 2012 at 3:47 am
saidapurs (10/4/2012)
Hi Scogeb,Database will not go off line....
Thanks
Satish
Incorrect, if you only have the primary and the witness and the witness goes down the principal...
October 4, 2012 at 1:12 am
you're welcome
October 3, 2012 at 11:50 am
To help combat sql injection ensure you assign only the required privileges to your accounts that access the database.
October 3, 2012 at 1:11 am
I'm still learning at the moment, caught some of it though
October 2, 2012 at 5:40 am
qew420 (10/1/2012)
1. Can I build SQL 2012 on it and migrate 2k8 to it and then get rid of 2k8
qew420 (10/1/2012)
October 2, 2012 at 2:48 am
This will display the data more accurately
selectdf.name AS LogicalFileName
, isnull(fg.name, 'Log') AS FilegroupName
, physical_name AS PhysicalOSName
, (df.size * 8 / 1024) AS SizeMBs
, case df.max_size
when 0 then 'No Growth'
when -1...
October 2, 2012 at 2:42 am
you would need to use the forcequorum switch, have a search for this and you'll find more info
October 1, 2012 at 8:24 am
Larry Kruse (9/28/2012)
I was hoping that there might be a DMV which might...
September 29, 2012 at 9:48 am
Hmm, this is a difficult one as there are already some very good scripts "out there".
I'm sure others will jump in here. 1000 pages is generally the perceived point at...
September 29, 2012 at 5:28 am
Viewing 15 posts - 4,906 through 4,920 (of 9,253 total)