Triggers

  • Comments posted to this topic are about the item Triggers

  • 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

  • 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

  • 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?

  • Thank you for the question

    Iulian

  • Thanks for the question.

    😎

  • 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!
  • Nice easy question.

    And today isn't even Friday! 😛

    Tom

  • 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

  • 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

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

  • 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.

  • 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

  • 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:

  • 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