Looks like Numeric(4,2) would do what you need, but keep in mind that you're likely to end up with rounding causing issues.

Comparing I/O rates between two complex systems is tricky. What are the bus speeds for the two servers? How much cache on the two drive systems? Spindle...

"If" statements have to make sure every possible outcome can compile and run without errors. That's why they give errors as if an option had run that really didn't....

While it's possible GetDate() will be removed at some point, there's nothing indicating it will be at this time.

I prefer it, because:

select getdate()

looks like it's selecting a function, while:

select current_timestamp

looks...

There is a Time datatype in SQL 2008. You posted in the 2005 forum, so I'm assuming you don't have access to that.

Just use Datetime and don't worry about...

The probability of it being duplicated is tiny. You'll reduce the impact of the query by changing it so instead of checking before-hand, it captures any insert error and...

Are you talking about installing two copies of BIDS on the same computer, one from each version? If so, yes, that's possible.

There are a number of different ways to do this. Perhaps the easiest is to import it into a staging table, and do a select with Unions to select...

There are a few key things to look for in any execution plan. The first is any warnings on it. These will usually be marked in red and...

It depends on the security rights you have, if I'm not mistaken.

That makes some sense then.

I'm assuming the clustered index on the table is NOT based on some sort of "date added" column. If it were, that would make the...

Derrick Smith (10/22/2010)

---

If I'm restoring a database for the first time, or one that I don't do regularly enough to already have a script for, I will always go through...

It'll take as long as whatever you have the trigger do takes.

If, for example, the trigger just immediately returns, then it'll take microseconds.

If, for example, the trigger writes a large...

That it's still SQL

All the things they should know about any ACID, relational database

Set-based CRUD

SQL is Declarative, not procedural/OOP

Table input parameters

Merge

Modifications to "Values" (data sets)

That's not 10, but it'll get...

You could probably run the disable and enable in the same context as the insert and get it that way, but it doesn't guarantee results.

Any problem with just inserting, and...