Sorry guys read the article, it's how microsoft run their technet,msdn and other web-sql server sites. It uses 4 sql servers maintaining seperate databases via peer to peer.

When I...

No you can't do that.  Memory is limited by o/s or sql edition. If you have std edition sql then you're at max memory, if you have advanced server/ent server...

yeah, sorry what I intended to say was that the data is still stored the same way, e.g. if the table spills over into tempdb the data is still written....

the default fill factor may be set on the database, in that case rebuilds will retain the fill factor. Other than that small indexes of few pages sometimes will not...

If the database isn't running on your server then you have a problem as any user to the local admins will get to view the data.

I agree with the comment...

I think you'd have to read from the registry, I'm not aware of any sql functions which return the underlying node name for a cluster.

It's a funny one dbcc updateusage , as a matter of course I always issue this command against every database every day ( if i can ) as part of...

I would beg to differ < grin > seen July Technet mag ? Load balanced sql server 2005 clusters using peer to peer replication .. is that cool or what?...

yeah sorry, only used active - passive with w2003.

yeah sorry .. logical reads .. however sp tuning wouldn't really be concerned with physical or logical because it would depend upon frequency of use , to populate the cache...

you need to be careful with how queries across linked servers deal with the data. It is possible that in your linked server environemnt the entire Oracle table is being...

I'm sure this isn't the case but the sasser worm has the same filename.

page reads and writes

http://www.compman.co.uk/scripts/browse.asp?ref=450145

ISBN 0-7356-1920-4

That's a nice way to do things!! I use this proc to search for a table in procs etc. I'm sure you can grasp the principle - it's not particularly...