We recently did a consolidation evaluation - multiple instances have memory issues, i.e. you really need to set min & max memory otherwise you will get problems, adv server only...

It's not really a proper question is it as the proc queries the system tables. < grin >

Each instance adds an overhead plus you will have to allocate fixed memory to each instance, well you don't have to - but expect problems if you don't. So in answer...

I would expect a log shrink to be almost instantaneous, even if it's very large.

try using    dbcc sqlperf(logspace)    to check how much free space you have to shrink, if your...

I've found that shrinkfile can sometimes "hang", if I can I switch the database model to simple before shrinking the file(s)  I realise that sometimes this isn't possible but it...

A lot depends upon many things and I have heard of Hyperthreading causing problems - however, my server is a 4 way P4 zeon, with hyperthreading turned on and so...

it's a long time since i did 6.5 but I'm pretty sure that you can't alter columns in 6.5 as you can it 2000.  I seem to remember I used...

CXPacket waits are usually down to parallelism, I've found they can be an indicator of poor sql, select into statements and out of date stats can produce lots of cxpacket...

Will do my best to remember, Ken Henderson's book on sql internals has some stuff on this, it's a great book even if I don't understand large parts of it...

You may be right, but there again going forward dot net will replace the com or extended procs dll, our developers are moving forward with dot net and don't want...

Thanks, I sometimes wonder if even half the provided tools and methods are ever used. I haven't found anyone calling dot net from sql server, not that this proves too...

I have a series of environments to test under thankfully, it does seem that largely the concept is seen as being ok, just can't find anyone actually using it! Sources...

As you can probably guess this is not an area I'm totally at home with, :-),  however I suspect you're probably right. Our web services people think this is so...

I've found out that the maximum buffer size ia actually 1Mb or thereabouts based upon 250 x 4000 nvarchar strings. I now wonder if the conversion to nvarchar occurs for...

They want to manipulate xml documents, the current methods are giving some problems.