Viewing 15 posts - 166 through 180 (of 2,640 total)
think you're going to have to be more specific here. If you're talking about app/web tier connections timing out for clients, these usually have deafult timeouts, about 30 secs...
June 2, 2011 at 6:22 am
a good read of BOL , a training course or buying the admin companion might be useful! I also have to ask if you're actually the right person to be...
June 2, 2011 at 6:18 am
what a stupid setting! But very useful to know about, thanks.
June 2, 2011 at 6:14 am
having a re-read I assume you mean you have 32 cores + HT == 64 effective cores vs your original 16 ?
Not having a go but why there is this...
June 2, 2011 at 6:10 am
other than making sure you should have the latest service packs and patches applied, moving versions never assumes better or equal performance as changes to the optimiser may alter the...
June 2, 2011 at 6:05 am
I wonder if you ever taught any of my developers? < grin >
May 31, 2011 at 6:31 am
can't say I've ever tried this - bind it into an exec statement and execute on the remote server - or set up a rpc call.
May 31, 2011 at 6:30 am
no merge replication does not load balance.
You can load balance sql server ( don't need clusters ) by using peer to peer replication.
Your clients need load balancing to share the...
May 31, 2011 at 6:27 am
clustering isn't always an advantage - look at the cons for clustering. A while ago at a technet meeting at Microsoft we did a straw poll on whether people thought...
May 31, 2011 at 6:21 am
there's no way anyone could answer such a question because all our experiences would be different. You do the same stuff on call as you do in your working day...
May 31, 2011 at 6:11 am
the issue with x32 and awe is that memory is not released, I'd suggest you consider x64. You should also realise that the 2gb you allocate to each instance is...
May 31, 2011 at 6:03 am
you can alias an instance to any name you like, use the client tools on your workstation.
It's juts that managing this type of stuff for lots of users is a...
May 31, 2011 at 5:57 am
our data centre uses shavlik, http://www.shavlik.com/products.aspx
but I think they may apply sql patches manually as they do alternate nodes on alternate days.
May 31, 2011 at 5:54 am
well I wouldn't use SQL_ collations as they're only there for backward compatibility with SQL Server 7.
You may get some issues if your user databases have a different collation to...
May 31, 2011 at 5:50 am
Viewing 15 posts - 166 through 180 (of 2,640 total)