Viewing 15 posts - 6,031 through 6,045 (of 9,253 total)
SkyBox (1/25/2012)
coded into VB6
God that shows how behind the times they are, have you also explained that Ronald Reagan is no longer president 😀
SkyBox (1/25/2012)
February 5, 2012 at 3:24 am
beejug1983 (2/1/2012)
Hi,Does quorum in Mirroring works as a quorum in Clustering. Please describe how quorum works in mirroring.
Thanks
If anything the quorum in database mirroring rather more matches the new clustering...
February 5, 2012 at 3:15 am
hayden_jones (1/23/2012)
What I'm still not clear on is the starting of the instance with the NET START command. Usually, I bring SQL up and down from the Cluster Administrator.
leave...
February 5, 2012 at 2:32 am
SQL_Giant (1/31/2012)
To achieve seemless failover, you would have to implement Database mirroring
Mirroring does not guarantee to provide seamless failover, in fact, a mirror session can take sometime to failover depending...
February 4, 2012 at 9:46 am
yes, it is possible. Are you using the mirroring GUI or T-SQL?
February 4, 2012 at 9:24 am
sohairzaki (2/4/2012)
The transaction log file is continually growing.
I read that if i backed up the transaction log say every 15 minutes this will...
February 4, 2012 at 8:51 am
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.
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
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...
January 30, 2012 at 10:12 am
thanks Jason, appreciate the feedback
January 30, 2012 at 10:06 am
SQLRNNR (1/27/2012)
Release to Manufacturing
or Release to market!
SQLRNNR (1/27/2012)
January 30, 2012 at 6:24 am
thanks Mohammed
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...
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...
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...
January 29, 2012 at 3:49 pm
Viewing 15 posts - 6,031 through 6,045 (of 9,253 total)