CXPacket is wait caused by a parallel skew. What happens is that SQL runs a query in parallel and, for whatever reason, one of more of the threads lags behind....

Data cache? Procedure cache?

What do you want to know about it?

For what it's worth, I saw a massive reduction in blocking going from SQL 2000 to SQL 2005. It may not apply in your specific case.

You'll get other advantages moving...

billross (10/14/2008)

---

It is non-intuitive to me that triggers are batched. That is, it appears that if you update 5 records, the 5 updates are done, then the 5 deleted and...

No. Recursive triggers are a database-level setting.

What are you trying to do that requires recursive triggers?

You should always declare the precision and scale of a numeric. If you want something that takes 18 digits and no decimal places, it's numeric (18,0). Don't rely on the...

Please post the table structure, some sample data and your desired output.

Then you're looking for numeric(18,0)

What did you try inserting and into what datatype?

The only way to downgrade a database (2008 to 2005, 2008 to 2000, 2005 to 2000) is to script the database and bcp the contents out.

And before anyone asks or...

Ints don't have a max number of digits. They have a minimum and maximum value that they can store. As I gave above.

It's the numeric and decimal datatypes that have...

Did you try it?

Smallint is 2 bytes and stores values between -32768 and 32767

Int is 4 bytes and stores values betweeen -2,147,483,648 and 2,147,483,647

bigint is 8 bytes and stores values between -9,223,372,036,854,775,808 and...

rbarryyoung (10/14/2008)

---

There are two problems with this approach:

1) there is no definitive list of "all known bad characters", especially given the strange things in Unicode and even just...

Unless you have a datemodified column in the table that you're updating when rows are changed, or some form of audit triggers, there's no way to tell when a table...

How long is a piece of string?

The answer to your question depends on the server...