Defragging tiny tables is a waste of time and effort. I usually set defrag scripts to ignore tables with less than somewhere between 50 and 500 pages, depending on...

icata (1/14/2008)

---

...The benchmark should be fairly close to my situation since the memory allocation for the procedure cache is similar in 2000 and 2005, as you guys pointed out. ......

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)

---

Hi,

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. 🙂