Microsoft...

"Single box" = 1 physical server (or virtual server if you are using those - although that is definitely NOT a best practice for high-performance).

You should absolutely NOT us multiple instances on a single box to manage large numbers of databases. The various 'overheads' of multiple instances should be avoided (actually it should...

I have a client with 6600 databases. I now have them running efficiently on a single 2 CPU dual core 64bit box with terrible I/O underlying it. yes,...

As Sergiy said, indexing could be a key here. But you should read and UNDERSTAND all of the material contained in parts 1-3 of this series by Bard Duncan...

I would think something like this would do it:

BEGIN TRAN

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

--note: this will give your sproc another output set. I am not sure though if...

SriSun (1/13/2008)

I finally changed my code (procedure) and came to this end.

if not exists(select [name] from workspace.sys.tables where [name] = 'geoleveltbl')

begin

...

HEY!! I bet we can have some fun with this. Let me start it off:

O - Obtuse

R - Repugnant

A - Arcane

C - Costly

L - Lexical

E - Executer

48GB sounds like a lot - unless you only have a few massive tables in the database. Don't forget too that sp_spaceused (if that is what you used to...

how much free space is there in the database and what is the growth increment for the data file(s)?

Sounds like it is time for you to trot out one of my favorite lines from the movie 'The Princess Bride' - "get used to disapointment". 😀

I thought I did address your question directly: "you can see tremendous throughput improvement...". And the question cannot be answered as explicitly as you ask. I could...

Short answer - no. Long answer - well ... let ... me ... think ... for ... a ... while ... ... ... no. 🙂

1) It has been my experience that queries are almost NEVER as optimized as my clients think they are.

2) You can pick up tremendous throughput improvements with appropriate data placement.

3)...

That is exactly the kind of statement I was addressing when...