Don't forget: SQL2K 64 bit Edition runs ONLY on Itanium processor ie. NOT on AMD Opteron.

To be able run the 64 bit version you will have to upgrade to SQL2005

Also if you know the ASCII code of your special character then you can insert it like this example is inserting a carriage return (ASCII code 13) between Column1 and...

But you have a performance drawback due to the Unicode storage of 2 bytes instead of 1. It means that you need twice as much storage space as for a...

try this: select cast(IntA, float) / cast(IntB, float) * 100

did you try to create a CLUSTERED index on dt, src, type? In this order. Because you are doing a range seeking (between) and a "LESS THEN" comparison so a...

I've got exactly the same problem but the only reliable solution I've found is to move the rows containing the largest columns into the first 8 row.

This is a known issue with...

First you can copy the required tables vie the select * into newdb.newuser.Newtable from olddb.olduser.oldtable order

Then you have to create the required indexes.

After that the views, SPs, trigger. You can...

For the very first time you have to know some basics:

dbreindex is not useful if your table is less then a segment (8 pages)

Also if you do not have clustered...

Here is an another approach:

declare @d datetime

set @d = getdate()

select cast(cast(@d-0.5 as int) as datetime)

This is almost equivalent to

select CAST(FLOOR(CAST(@d AS DECIMAL(12, 5))) AS DATETIME)

Just have a look in your C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples folder.

You can find a lot of samples there to start you development with

Otto,

What you know is right SQLServer 2000 64 bit runs only on Itanum.

SQL2005 will run on AMD processors as well.

Did you check for your environment the boot.ini, AWE and the...

First I would update the stats then recompile the SP. Also you should check the execution plan whether you are still using all the required indexes

Yes.

And what I mean by this is if you have a wrong written SQL statement with wrong or no index using it doesn't really make sense increasing the HW power,...

All this.

In addition you can check where you bottleneck is (Disk, CPU, Memory, Network, Client app...). What you have to know: Adding more memory always helps. But if you have...

There is no magic number. It depends on your way of doing SQL statements (more long running, ressource intensive queries will allow less concurrent access without a performance penality)

I have...