The license and limit is per CPU, not per core, so 2 quad-cores can be licensed and used as 2 CPUs. Microsoft is reviewing that as more and more...

The rules for incrementing need to be defined.

What condition causes AAA1001 to increase to AAB1002? The number part, in your example, seems to go up by one each row....

You can avoid a cursor.

Create a temp table with the ID, Prod, Date and Status from the main table, and two extra columns, SetStart and SetEnd, both bit data type.

Then...

Those three characteristics aren't persisted, because they only apply to the command being run on the index, not to the index itself. They're run-time options that have no affect...

It sounds like you're having the usual "parameter sniffing" problem. Look that phrase up, there are ways to test for it and solve it, both on this site and...

Depending on the application, I believe you can set those in your connection manager, rather than having to set them for each insert.

Also, if you use stored procs for your...

If you really do mean PL/SQL, you'll have to try an Oracle forum. This one is for Microsoft SQL.

How about something like this:

create view FuelLog

as

with CTE (Row, FuelLogID, VehicleID, Date, FuelQty, EndingOdometer) as

(select row_number() over (partition by VehicleID order by Date),

FuelLogID, VehicleID, Date, FuelQty, EndingOdometer

from dbo.FuelLog)

select c1.FuelLogID, c1.VehicleID,...

Per Microsoft, Standard Edition can use as much RAM as the OS will give it.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Intermediate steps are the way to go.

Step 1: Do Something; on Failure go to Step 2; on Success go to Step 3

Step 2: E-mail to report failure for Step 1;...

I think I've had to enable RPC to get DTC to work, in similar situations. It was a few years ago, so I don't remember all the details, but...

I've been in life-or-death situations a few times, and it does put DBA emergencies into perspective. Having been held at knife-point by muggers kind of makes a crashed hard...

Print does cut off after a certain point. You might be able to change it to select (instead of print) and output to a file or to text. ...

The Xeon may be reporting itself to SQL as 4 CPUs instead of 4 cores on 1 CPU. I'm not sure how all of that works, inside SQL.

Microsoft recommends a few steps when upgrading from 2000 to 2005 for any database. The upgrade wizard should tell you what you need to change. Make sure to...