Forum Replies Created

Viewing 15 posts - 7,966 through 7,980 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Anyone feel up to some trigger fun?

    http://www.sqlservercentral.com/Forums/Topic1609279-1292-1.aspx

    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

    September 1, 2014 at 7:35 am

    #1742234

  • RE: Can you perform 3 actions in one trigger?

    crazy_new (9/1/2014)

    The way it determines which one to remove is by the @RoleID on the @NameID. @NameID is the client and @RoleID is the Role.

    But you're not using the inserted...

    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

    September 1, 2014 at 7:34 am

    #1742233

  • RE: Can you perform 3 actions in one trigger?

    There's a lot wrong with that trigger. To start, the fact that it does not reference the inserted table, hence isn't working with the rows just inserted. Also looks like...

    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

    September 1, 2014 at 3:43 am

    #1742195

  • RE: Database Log file not able to delete

    The EmptyFile option of shrinkfile is only relevant to data files. Specifying the option when shrinking log files has no effect whatsoever. You cannot move the active portion of the...

    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

    September 1, 2014 at 3:22 am

    #1742190

  • RE: Can you perform 3 actions in one trigger?

    crazy_new (9/1/2014)

    Hey guys, is it possible to delete from a table,then insert into that same table, and then delete from a second table, all in one INSERT trigger?

    Yup. If it's...

    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

    September 1, 2014 at 2:59 am

    #1742186

  • RE: On the importance of a complete break

    Gary Varga (9/1/2014)

    The issue is similar, but not the same, for freelancers. There is a fear that one cannot ignore calls from agencies, queries from the current client or contact...

    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

    September 1, 2014 at 2:34 am

    #1742174

  • RE: Restoring a database :

    Vimal Lohani (9/1/2014)

    But what if you have only backup file. even you can't read it on lower version through labels or headeronly.

    Download SQL Evaluation edition of the version of the...

    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

    September 1, 2014 at 2:28 am

    #1742171

  • RE: After Insert Trigger not executed

    rot-717018 (8/29/2014)

    I added manually a record to the table but it did not fire the trigger either ?!?

    A manual insert (INSERT INTO) absolutely will fire triggers, no way that a...

    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

    August 29, 2014 at 6:33 am

    #1741874

  • RE: After Insert Trigger not executed

    Yeah, that's what I thought. It's a bulk load (high-speed inserts). The bulk loads (bcp in, BULK INSERT and that Insert bulk) don't fire triggers unless the application running it...

    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

    August 29, 2014 at 6:32 am

    #1741873

  • RE: After Insert Trigger not executed

    rot-717018 (8/29/2014)

    @venonym: I'll try to check whether triggering is enabled for the database/table ...

    There's no table or database setting which disables triggers, don't waste time looking for one.

    @GilaMonster: the rows...

    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

    August 29, 2014 at 6:00 am

    #1741861

  • RE: After Insert Trigger not executed

    How are the rows added to CounterData?

    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

    August 29, 2014 at 4:31 am

    #1741840

  • RE: Materialized Views, how often they updated in MS SQL?

    It's updated as part of the transaction which modified the base tables.

    You'll have 1.5 million if you query one microsecond after the commit for the insert into the base table.

    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

    August 28, 2014 at 11:42 am

    #1741705

  • RE: Can a loop lock itself?

    jcb (8/28/2014)

    Anyway can you explain how the insert can work and the update fail?

    Maybe, if you explain what exactly you mean by 'fail'?

    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

    August 28, 2014 at 6:57 am

    #1741627

  • RE: MCSE Data Platform 2012 and salary

    xsevensinzx (8/28/2014)

    I am studying for my Microsoft SQL 2008 R2 Database Development certification though.

    Don't. If you want to study now, get the 2012 ones. The 2008 exams are likely going...

    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

    August 28, 2014 at 6:28 am

    #1741616

  • RE: Read only database

    Replication if you need real-time. Log shipping the DB will be be behind prod. The less often the log backups are restored, the more behind it can get. The more...

    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

    August 28, 2014 at 6:26 am

    #1741614

Viewing 15 posts - 7,966 through 7,980 (of 49,552 total)