You should read BOL to understand the limitations and uses of various objects in SQL Server. You might be able to do this through a dot net function although I'd...

varchar in 2005 takes unlimited size ( check out BOL ) change your text to varchar. You'll want to test against other issues ( if any ) first though.

The biggest disadvantage of multiple instances is the division of memory as a resource.

I guess the biggest advantage is consolidation - msdtc and mssearch are common services that I know...

Just think about what you're suggesting!! A solution however is to use a three node setup where 1 node covers failover for two other nodes - but as you add...

you should be able to add objectid and also return the tsql being run - with this info you should be able to track it down.

hmmm .. so you inlcuded the plan data in the trace then? Well you should be able to extract the sql that runs the query from profiler and then run...

so it's embedded sql then? so how have you compared query plans?

No the settings are not important as such, I was just working through a check list.

There's never really one whole answer, you have to make decisions always. Only a two phase commit will guarantee the transaction, however, this is only one part of "protection" for...

the question should be mirroring or replication - clustering does not provide any redundacy other than for server hardware ( excluding storage ) the disk storage is still a single...

The key here is SCAN - a clustered index scan is a table scan and it's the absolute last thing you want in your query - so unless you're just...

efficient data partitioning will always be faster, however the upkeep and complexity of partitioned tables ( or views if 2000 ) should always be considered.

To be honest 30 million rows...

At first read this seems to be an interesting read with some useful conclusions, however on more careful analysis I would suggest that the heading and conclusions are somewhat misleading.

In...

Cool isn't it? Welcome to my world!!

You don't need access to code to get the query plans - queries can be extracted by profiler or third party tools such...

Actually that does raise a valid point - the cultures of international companies can cause stress - managers and above - can sometimes be difficult to adapt to.