it's quite interesting as to what sometimes seems quite simple often isn't.

What I suggest is that you download and install the performance dashboard - this was produced for 2005 but with a couple of fixes it will run in sql 2008,...

what are you displaying the report as? pdf is very slow at times.

I'd try html first.

I had a problem with slow rendering which was releated to the complexity of...

Practically when a cluster resource fails to another node applications will reconnect depending upon the design, I supported one app where a failover resulsted in all users getting locked out....

I'd never given it that much thought to be honest. One extreme measure would be to create 36 individual schedules for a 40 min interval. But that would only work...

There are a few shortcomings with partitioning not least of which is the issue of the partitioning column having to be part of the clustered key. This means if you...

oh yes you can deploy geographically seperated active active clusters for sql server too - but you need other software.

windows clusters have never been able to be load balanced for sql server and as this is a sql server forum my answer was correct. You can have multiple instances...

if you want to either mail me direct or send me a message I'll send you the code I use to ping servers - you can't just issue xp_cmdshell 'ping...

yes that's the problem with federated servers. I asked because I wasn't sure if your model was partitioning across the servers. For queries across servers I tend to execute...

I use a ping from a reporting server, it alerts me if a ping fails.

You can query the service using a linked server but linked server queires can sometime be...

you need an external tool to increase the partition. It's worth noting that windows 2008 R2 allows you to resize partitions on the fly.

I always make sure the C: drive...

you'd need to write a scheduler I guess to do what you want. Or you could use a control job to call your other jobs at the intervals you require,...

sorry forgot to paste!

set nocount on

declare @scount tinyint=65,@scount2 tinyint=70,@scount3 tinyint=68

declare @loop int =1

while @loop<17577

begin

--insert into dbo.LookupCharOne(Squirrel)

select CHAR(@scount)+CHAR(@scount2)+CHAR(@scount3)+'sqlsquirrel'

set @scount+=1;

if @scount>90

BEGIN

set @scount=65

set @scount2+=1

END

if @scount2>90

BEGIN

set @scount2=65

set @scount3+=1

END

if @scount3>90 set @scount3=65

end

well I wrote up my benchmark tests so you can see how I attempted to generate data. I use this type of approach.

http://www.grumpyolddba.co.uk/infrastructure/sqlbenchmark.htm

I used this script to generate character...