?? I'm confused -- I have a server running a pure 64-bit setup: w2k3 standard edition 64-bit, SS 2005 standard edition 64-bit, 12GB RAM, and SQL...
Thanks, Frank. Yes, we know about that workaround too -- problem is, this is data that we receive, and those creating it either won't do that (nor...
OK, I have to share (read "vent"). My company almost daily gets data to load into SQL Server, and it comes in Excel, because Excel has that nice...
SQL Server 2000 Standard is "capped" at a memory limit that corresponds to the maximum practical memory use on a dedicated SQL box running Windows...
As far as memory goes, SQL Server 2000 Standard is basically designed for a maximum 4 GB 32 bit environment. You can run a pretty beefy application...
There are many factors in sizing a server, but I will tell you this: SQL Server 2000 Std can use all 8 cores of a 2 socket / 4 core box (I've got...
Hi - In general, systems that run SQL Server and are I/O intensive need a large quantity of small drives, rather than a few big ones. This is because...
The only way to tell is to compare the execution plans. For any incoming query of any form, the optimizer will try to refactor the query into the...
Hi - not sure I completely understand the question, but I'll give it a shot: SQL Server 2005 has a "compatibility mode" that you can set "back" to...
Hi all - I notice this morning that if I use DBCC SHRINKDATABASE on a database having multiple data files, only the first data file shrinks while...
Yup Or, based on your photo, maybe I should say 'DOH!'
I'm using Firefox 2, and the site works in general, but the top of each page does not seem to be rendering correctly (looks quite different from IE...
Joe - I located the problem: the server is fine; I had not noticed the following in the test script: In the script called "new in memory read test,"...
You might also find these interesting:...
If you have to do this every day, and that need will continue, you might also look at partitioning the table. That way you might be able to set your...
A quick forum tip y'all: set your query results to "column aligned" and then when you post, enclose the matrix in "code" tags. That will make the...
quote:Originally posted by joechang try openning 4 windows in QA consecutively, ie, they have seqeuential spids, 51,52,53,54 run the test in each,...
Table scan performance is a smidge better (don't know if I can attribute that to powerpath or some other factor) spid Calls ms...
New info: just installed the license for EMC's "powerpath" module, which should be load-balancing across the two HBA's and the two EMC storage...
Hi Joe - yes, I believe so. I took the test scripts directly from your other post. I am puzzled; everything else makes sense to me, but I can't quite...
Separate names with a comma.
