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: Friday, December 19, 2014 3:02 AM
Points: 1,298, Visits: 2,270
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 22, 2014 6:49 AM
Points: 845, Visits: 744
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: Yesterday @ 6:46 AM
Points: 13,646, Visits: 11,524
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: Tuesday, December 9, 2014 9:45 AM
Points: 1,446, Visits: 1,603
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 @ 3:03 AM
Points: 568, Visits: 76,760
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: Yesterday @ 9:29 AM
Points: 40,656, Visits: 37,115
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: Yesterday @ 9:29 AM
Points: 40,656, Visits: 37,115
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: Monday, December 22, 2014 12:15 AM
Points: 9,928, Visits: 11,207
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: 2 days ago @ 3:32 PM
Points: 18,068, Visits: 16,111
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