Post reply

Triggers

  • December 21, 2011 at 8:34 pm

    #100803

    Comments posted to this topic are about the item Triggers

  • December 21, 2011 at 11:21 pm

    #1424585

    It's trivia time! 😀

    Thanks for the question Steve.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 22, 2011 at 12:58 am

    #1424608

    Thanks Steve - a point before coffee this morning, it must be getting close to Christmas

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • December 22, 2011 at 3:35 am

    #1424677

    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?

  • December 22, 2011 at 4:16 am

    #1424702

    Thank you for the question

    Iulian

  • December 22, 2011 at 4:58 am

    #1424721

    Thanks for the question.

    😎

  • December 22, 2011 at 5:17 am

    #1424727

    very good question!!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • December 22, 2011 at 5:23 am

    #1424730

    Nice easy question.

    And today isn't even Friday! 😛

    Tom

  • December 22, 2011 at 5:52 am

    #1424741

    And our IT manager gets nervous when there are four triggers on a table - performance concerns! (So much of our ERP front-end has the business rules in the forms. Maintenance nightmare.)

    Thanks for the question Steve.

    Merry Christmas to All!

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • December 22, 2011 at 6:01 am

    #1424746

    That's kinda like saying you can have an unlimited number of deer ticks in your underwear. Sure, you can... but why would you want to?

    ron

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • December 22, 2011 at 6:05 am

    #1424747

    Not unlimited - limited by the size of the underwear, and what else you've got in there :w00t:

  • December 22, 2011 at 6:43 am

    #1424771

    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.

  • December 22, 2011 at 6:56 am

    #1424774

    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? :hehe:

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 22, 2011 at 7:07 am

    #1424782

    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? :hehe:

    We limit ourselves to 1 billion to allow for future growth...;-)

    I'm still processing the Deer ticks in the underwear concept...:crazy:

  • December 22, 2011 at 8:35 am

    #1424824

    Nice question, almost fooled me with the answer of 32 there which is simply nested triggers not triggers per table.

Viewing 15 posts - 1 through 15 (of 22 total)

You must be logged in to reply to this topic. Login to reply