Viewing 15 posts - 4,921 through 4,935 (of 9,244 total)
stillconfused (9/28/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 8:29 am
GilaMonster (9/28/2012)
Rather use sys.stats, not sys.indexes. Column stats (whether manually or automatically created) aren't in sys.indexes.
yes, of course, my bad
marygrace_laurente23 (9/27/2012)
Not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 8:12 am
Check and post results of the following query
SELECTt.name
, i.name AS index_name
, STATS_DATE(i.object_id, i.index_id) AS statistics_update_date
FROM sys.objects t inner join sys.indexes i
on t.object_id = i.object_id
where t.is_ms_shipped <> 1
order by statistics_update_date...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 6:00 am
you would have to force service on the 3rd node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 4:55 am
SQLSACT (9/28/2012)
Very interesting, do you know if it's possible to remove a nodes vote in a Windows 2012 Cluster?
Haven't had chance to look at the 2012 OS yet, can't see...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 3:55 am
nelsonaloor (9/27/2012)
We have a two node (NODE1 and NODE3)
Do you mean NODE1 and NODE2?
nelsonaloor (9/27/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 3:52 am
karen_jonesdba (9/27/2012)
Could this be used for a site to site DR test
Not really, no.
karen_jonesdba (9/27/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 1:53 am
mohammed moinudheen (9/27/2012)
Very good one Perry.Rated it 5 star 🙂
Hey thanks Mohammed, appreciate the feedback 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2012 at 11:42 pm
You want to try and achieve an odd number of voting nodes to help maintain quorum, with three nodes Node majority would be default.
However, take this scenario.
You have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2012 at 9:42 am
yes, correct
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2012 at 8:26 am
ok, so you understand that the 2 nodes participating in the failover cluster instance share the resources in the cluster group, they don't each have a G drive, they share...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2012 at 8:06 am
Have you worked with windows server failover clusters before, do you understand the concepts?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2012 at 7:36 am
SQLSACT (9/27/2012)
Non clustered instance "Clusternode3\INST2" installed to Clusternode3.
AO group called "AOGrp1" created between instances "SQLCLUST01\INST1" and "Clusternode3\INST2"
The above setup is an AG combined with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2012 at 6:09 am
SQLSACT (9/27/2012)
For a setup of an AG between 2 servers without incorporating FCI, I just need 2 servers, with it's own storage, right?
That is correct, recall that an availability...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2012 at 5:30 am
joeroshan (9/27/2012)
Great article. Very useful for DBA in production environment.
Hi, thanks for the feedback, please don't forget to rate the article if you found it useful
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2012 at 2:27 am
Viewing 15 posts - 4,921 through 4,935 (of 9,244 total)