Viewing 15 posts - 43,786 through 43,800 (of 49,571 total)
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....
October 15, 2008 at 1:24 am
Data cache? Procedure cache?
What do you want to know about it?
October 15, 2008 at 1:20 am
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...
October 15, 2008 at 1:15 am
billross (10/14/2008)
October 15, 2008 at 1:12 am
No. Recursive triggers are a database-level setting.
What are you trying to do that requires recursive triggers?
October 15, 2008 at 1:08 am
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...
October 15, 2008 at 1:03 am
Please post the table structure, some sample data and your desired output.
October 14, 2008 at 2:48 pm
Then you're looking for numeric(18,0)
What did you try inserting and into what datatype?
October 14, 2008 at 2:41 pm
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...
October 14, 2008 at 2:33 pm
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...
October 14, 2008 at 2:26 pm
Daniel C (10/14/2008)
What you're saying over there doesn't work at all for the intended purpose - smalldatetime/datetime/bigdatetime uniqueness enforcement.Still looking for a solution on this.
Did you try it?
October 14, 2008 at 1:49 pm
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...
October 14, 2008 at 1:47 pm
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...
October 14, 2008 at 1:17 pm
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...
October 14, 2008 at 12:25 pm
The_SQL_DBA (10/14/2008)
How long does it take to Rebuild Indexes on a table with 110Million rows.
How long is a piece of string?
The answer to your question depends on the server...
October 14, 2008 at 10:54 am
Viewing 15 posts - 43,786 through 43,800 (of 49,571 total)