Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:09 AM
Points: 1,296, Visits: 2,267
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: Thursday, November 20, 2014 7:11 AM
Points: 845, Visits: 741
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 13,570, Visits: 11,383
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 LessThanDot.

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

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 8:45 AM
Points: 1,443, Visits: 1,600
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: Today @ 12:25 PM
Points: 568, Visits: 75,501
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 @ 8:31 AM
Points: 40,456, Visits: 36,912
I think the correct answer (like the max number of indexes per table) is 'Too Many'


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
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 @ 8:31 AM
Points: 40,456, Visits: 36,912
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 2008, MVP
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: Today @ 4:51 AM
Points: 9,928, Visits: 11,199
Happy to have chosen the wrong answer.

32 seems much more reasonable anyway.




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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:52 AM
Points: 17,980, Visits: 15,983
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