Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Triggers Expand / Collapse
Author
Message
Posted Thursday, December 22, 2011 6:05 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, December 1, 2016 3:10 AM
Points: 1,633, Visits: 2,645
Not unlimited - limited by the size of the underwear, and what else you've got in there
Post #1225759
Posted Thursday, December 22, 2011 6:43 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, December 5, 2016 6:30 AM
Points: 846, Visits: 812
Good question...and a good time to share a bit of wisdom about triggers:


Note:
Because SQL Server does not support user-defined triggers on system tables, we recommend that you do not create user-defined triggers on system tables.

Sounds like a sound recommendation to me.

Post #1225785
Posted Thursday, December 22, 2011 6:56 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:35 AM
Points: 15,510, Visits: 13,170
Andrew Watson-478275 (12/22/2011)
That's the second or third R2 limits question we've had - I've now got that page on favourites, ready for the next one .

I always find some of the limits a bit overkill; does anyone really need 2 billion objects in their DB?


You don't have 2 billion objects in your DB?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1225788
Posted Thursday, December 22, 2011 7:07 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, November 16, 2016 12:05 PM
Points: 1,523, Visits: 1,726
Koen Verbeeck (12/22/2011)
Andrew Watson-478275 (12/22/2011)
That's the second or third R2 limits question we've had - I've now got that page on favourites, ready for the next one .

I always find some of the limits a bit overkill; does anyone really need 2 billion objects in their DB?


You don't have 2 billion objects in your DB?


We limit ourselves to 1 billion to allow for future growth...


I'm still processing the Deer ticks in the underwear concept...
Post #1225796
Posted Thursday, December 22, 2011 8:35 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 26, 2015 8:51 AM
Points: 568, Visits: 81,110
Nice question, almost fooled me with the answer of 32 there which is simply nested triggers not triggers per table.
Post #1225846
Posted Thursday, December 22, 2011 8:41 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
I think the correct answer (like the max number of indexes per table) is 'Too Many'


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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1225852
Posted Thursday, December 22, 2011 10:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:06 AM
Points: 5,446, Visits: 4,621
GilaMonster (12/22/2011)
I think the correct answer (like the max number of indexes per table) is 'Too Many'

How many is 'too many'?
Post #1225906
Posted Thursday, December 22, 2011 11:00 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
Revenant (12/22/2011)
GilaMonster (12/22/2011)
I think the correct answer (like the max number of indexes per table) is 'Too Many'

How many is 'too many'?


One more than 'just right'.



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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1225927
Posted Thursday, December 22, 2011 4:17 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, December 7, 2016 6:42 AM
Points: 9,932, Visits: 11,347
Happy to have chosen the wrong answer.

32 seems much more reasonable anyway.




Paul White
SQLPerformance.com
SQLblog.com
@SQL_Kiwi
Post #1226038
Posted Thursday, December 22, 2011 10:59 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 2:52 PM
Points: 20,083, Visits: 18,257
Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1226083
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse