Viewing 15 posts - 6,031 through 6,045 (of 9,244 total)
SQLKnowItAll (2/1/2012)
Each data file resides in its own filegroup.
That's not the same as multiple files per file group, which if you don't have a need for, leave well alone.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2012 at 12:53 pm
vijay82 (1/31/2012)
It is win 2003 server.
In that case check the cluster log at the following path
C:\windows\cluster\cluster.log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2012 at 11:46 pm
vijay82 (1/30/2012)
Hi,Can any one please let me know where we have to check the following cluster information.
1).When was the cluster failover was happened and from which NODE it is moved.
is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2012 at 10:12 am
thanks Jason, appreciate the feedback
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2012 at 10:06 am
SQLRNNR (1/27/2012)
Release to Manufacturing
or Release to market!
SQLRNNR (1/27/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2012 at 6:24 am
thanks Mohammed
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2012 at 5:52 am
ananda.murugesan (1/27/2012)
Should I use in Single primary filegroup and create multiple files MDF for using application date, NDF for using index if created?thanks
ananda
Do you have a valid reason for creating...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2012 at 1:25 am
GilaMonster (1/29/2012)
The fragmentation values for a heap are extent fragmentation
funny, thats exactly what it says in BOL. Either way it's not relative to an index maintenance operation, so filter it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2012 at 5:22 pm
DBA_SQL (1/29/2012)
Understood. So how about if we have the following situations:Index Type: Heap
Avg_Fragmentation_IN_Percent: 99
Page counts : 885
heaps by their very nature are fragmented, when pulling index frags ignore index ids...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2012 at 3:49 pm
Sumanta Roy (1/26/2012)
There is a user database which has 1 mdf, 6 ndf and 4 ldf files. I have taken the database offline. I cannot move all the files. For...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 26, 2012 at 5:22 am
Run this and check the results, it will return the cluster groups that are active and the node they're active on
CLUSTER GROUP /NODE:dbhced01
CLUSTER GROUP /NODE:DBHCED02
This will get the cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 26, 2012 at 4:39 am
hwat were the results of your cluster verification report when you first deployed the windows cluster. try running it again to see if it pinpoints any issues
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 26, 2012 at 4:25 am
Yes I have VMWare ESX4i at home and VMWare Server 2.0.2 on my laptop.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 26, 2012 at 3:34 am
Ok so both nodes are part of the windows cluster. Now run the command to list the possible owners of the clustered SQL server resource.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2012 at 1:15 pm
go onto one of the cluster nodes and post the results of this when run from the command prompt
cluster /CLUSTER:yourwindowsclustername NODE /STATUS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2012 at 12:03 pm
Viewing 15 posts - 6,031 through 6,045 (of 9,244 total)