Viewing 15 posts - 3,796 through 3,810 (of 9,241 total)
Firstly, a couple of questions,
Are the servers all firewalled from each other?
Are the instances all default instances?
The snapshot files are delivered via means of an NTFS share. Accessing a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2014 at 4:18 am
Even more worrying, why are all the connections using system administrator??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2014 at 2:24 am
JoshDBGuy (1/6/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2014 at 5:11 pm
Ginga (1/6/2014)
The in place upgrade went ahead this weekend just gone and it was a simple, albeit lengthy process. I decided to shut...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2014 at 11:17 am
What command did you use to check the frags?
Can you post the before and after outputs?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2014 at 1:04 am
VossSQL (1/3/2014)
I understand that SHRINK data/log files should be the last option due to all problems it generates. But how can I proceed on the following situation?
SQL Server 2008 R2....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2014 at 3:33 pm
cherish.j.wang (1/3/2014)
I am confused recently weeks for SQL Server 2012 Alwayson AG HA could not failover automatically when SQL Service is running as built-in account.
according
From Microsoft SQL Server 2012 online...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2014 at 11:24 am
when you setup the central management server you can create a group and register instances. You may then execute a t-sql script against the group affecting all the registered instances
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2014 at 11:11 am
JimS-Indy (1/3/2014)
I have access to an app that lets me manage group membership for groups I "own".
What is the app called
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 10:07 am
you can detach by all means.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 7:12 am
EdVassie (1/3/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 6:41 am
the only time i would be shaky would be a major platform change, for instance in place upgrade from Windows 2003 Std to Windows 2008 R2 Std, etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 4:28 am
gautham.gn (1/3/2014)
I want to find those columns which are in main table but are not present in _dup table.
Try this
SELECTc.TABLE_SCHEMA
, c.TABLE_NAME
, c.COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS c
LEFT OUTER JOIN INFORMATION_SCHEMA.COLUMNS cd
ON c.TABLE_SCHEMA =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 4:12 am
arrjay (1/2/2014)
All 5 database instances are being used by the users.
sounds like you're hitting this from an Oracle terminology point, theyre different entirely.
Each instance will default to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 3:25 am
similar to HP Polyserve then by the sound of it.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 3:20 am
Viewing 15 posts - 3,796 through 3,810 (of 9,241 total)