From Microsoft website for x64 standard:

"Windows Server 2003 R2 Standard x64 Edition, supports up to 32 GB of RAM on 1- to 4-way servers"

Your limitation will be what sql2000 can...

Need a little more information.  What version of Sql are you planning to load on this.  Sql2005 has a ram limit of os max.  Which is 4gig per process on...

How often is this report going to be run.  A different approach to a relevant report would be to select the top 2 search phrases from each session id, or...

I would also try turning the table variable into a #temp table.  I have seen different performance based on using the different table expressions.  You should also have an index...

I usually just fire up profiler on my local machine and give it the databases that I want to look at.  You'll have to add the dbid to the default...

You shouldn't care.  If you create two indexes one in ascending and one in descending orders.  In one index it would be in rec no 1 and one it would...

Better than detaching them, I would just take them offline.  Are there any current users in the databases.  The other thing you can do is setup a profiler trace and...

So, if I am reading correctly, the other offsite systems data is never going to tape?  I don't know if you have access to a NAS, but that is where...

Thanks for the good info.  Although if you do just insert you will get fragmentation, only it will come at the end of the page.  As the last page fills...

Dave,

Your in a tough spot.  I have a vendor here for one of our oracle instances, that has a lot of procedures.  I have had to add hints to their...

Read up on dbcc showcontig.  Fill factor needs to take into account what the clustered key is, and what kind of insert/update/delete activity is going on in the database.  For instance,...

Is this a 24x7 shop?  I have to agree with the owner on this one.  Why spend the money on expensive software when the Sql tools work just fine.  You...

Yeah, I thought about the 4 limit.  As you said you can always build some fluff in.   # of tables expected = the increment value.  Scope for upto 10 tables...

How many rows are in each table?  You could create the identity in each table and use a different range for each. say 1-1000, 1001-2000, 2001-3000, 3001-4000.  If you used...

I forgot to add that I would turn the update into a select so I could tune that statement.  At least to run the estimated execution plan.

-- pMxGetGainInfo

--update @portGainTable

--  set...