Viewing 15 posts - 6,031 through 6,045 (of 9,241 total)
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
check the cluster error events within failover cluster manager for more info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2012 at 11:53 am
MarkThornton (1/24/2012)
I TRUNCATEd the offending table
There was never any doubt this would work as the truncate will de allocate all the pages, no ghost records to clean up!
MarkThornton (1/24/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2012 at 10:40 am
You shouldn't treat the VM any different to s physical machine. How do you back up these?
Options such as VMWare vmotion make a virtual machine highly available and all...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2012 at 1:16 pm
Viewing 15 posts - 6,031 through 6,045 (of 9,241 total)