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: Friday, June 24, 2016 7:42 AM
Points: 1,542, Visits: 2,544
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: Tuesday, May 24, 2016 6:34 AM
Points: 845, Visits: 791
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: Friday, June 3, 2016 7:09 AM
Points: 15,149, Visits: 13,037
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: Tuesday, June 21, 2016 2:38 PM
Points: 1,523, Visits: 1,719
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: Today @ 10:07 AM
Points: 44,737, Visits: 42,615
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: Today @ 10:51 AM
Points: 5,165, Visits: 4,313
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: Today @ 10:07 AM
Points: 44,737, Visits: 42,615
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: Tuesday, June 21, 2016 1:36 PM
Points: 9,932, Visits: 11,340
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Wednesday, June 22, 2016 2:24 PM
Points: 19,803, Visits: 18,086
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