Viewing 15 posts - 43,771 through 43,785 (of 49,552 total)
No. Recursive triggers are a database-level setting.
What are you trying to do that requires recursive triggers?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 1:03 am
Please post the table structure, some sample data and your desired output.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 2:48 pm
Then you're looking for numeric(18,0)
What did you try inserting and into what datatype?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 10:54 am
How have you set the linked server up? What errors is it giving?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 10:49 am
GSquared (10/14/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 10:48 am
I don't suppose you have a backup of distrbution?
Did you drop the database, or did you delete the files of distribution? If you query sys.databases, is distribution listed?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 10:42 am
Is the drive full? Is there a max size set for the file?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 10:40 am
Viewing 15 posts - 43,771 through 43,785 (of 49,552 total)