Viewing 15 posts - 1 through 15 (of 93 total)
Your problems will arise if your SQL Server is in a running state where it will consume the 8Gb of memory on that node and then that node fails! This will...
July 25, 2006 at 2:22 am
We've actually hit a bit of a blocker on the upgrade to SQL2k5 due to some replication features being deprecated (alternate Sync Partners), and no reasonable alternative being offered by...
July 21, 2006 at 9:28 am
u just HAD to confirm it for me, didnt u!?
Ah well ... if there was an easy(er) answer i'd have figured it out...
January 5, 2006 at 11:24 am
I think it's the failure scenario ur not understanding and that is ALL has to be merge replicating. As i mentionioned, worse case scenrio is the WAN link to the...
January 4, 2006 at 8:28 am
Track2 would need to have a Merge Relationship also with Track1 (then also alternate sync partners) ... i didn't think this was allowed!??
ie Factory1 ---Merge Repl ---> Track1 ---Merge Repl...
January 4, 2006 at 7:53 am
"Be sure you know the sa of have given explicit rights to a windowsaccount you know the password of that is sqlserver sysadmin, before you revoke builtinadmin !"
So, not just...
December 22, 2005 at 7:51 am
just as a general note from the first posting, you dont need to have built-in\admins on the SQL Server when clustering! As long as you put the Cluster and SQL...
December 22, 2005 at 3:38 am
Only ever had the "failed on node 2" scenario once ... and i've done quite a few clusters over the years. The site in question did (does!) have some network...
December 19, 2005 at 2:53 am
uurrrmmm ... Yeah! Not putting the Cluster and SQL Service accounts in the Local Admins WILL have some minor issues!?
I'd be a little...
December 16, 2005 at 10:20 am
BTW ... dont use a Blade Center for a cluster. We ran into some significant issues when attempting this ... and then got free(ish) hardware from OUR IBM suppliers cos...
December 16, 2005 at 10:08 am
did we honestly need to go to the nth level on the context and definition of what a virtual server is! We all knew that he meant he had VMWare...
December 9, 2005 at 10:18 am
Right click on the database in EM and select "Properties" ... then goto the filegroups tab! U can add new filegroups and set the default in there! From there, u...
December 9, 2005 at 3:35 am
The only time i've ever heard of virtual server being used in conjunction with SQL server is to emulate a Cluster ... There's nothing inherently wrong with it (apart from...
December 9, 2005 at 2:55 am
bumping my own posts now!? lol
Anyway, i posted this just before i was on holiday ... so ask again, has anyone run into this before??
Cheers
Vinny
December 5, 2005 at 6:13 am
BOL says this (see "composite index") :
"Covered queries can improve performance. Covered queries are queries where all the columns specified in the query are contained within the same index."
The example...
November 25, 2005 at 2:49 am
Viewing 15 posts - 1 through 15 (of 93 total)