Forum Replies Created

Viewing 15 posts - 25,156 through 25,170 (of 49,552 total)

  • RE: Transparent database encryption

    Thomas Abraham (7/5/2011)

    But I still don't understand why I was flamed for making an honest attempt to improve the situation.

    You considered that a flame? Really??

    That was an (obviously poor)...

    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

    July 5, 2011 at 2:43 pm

    #1348592

  • RE: how to implement a Multirow insert trigger?

    tpcolson (7/5/2011)

    How would the existing trigger work with multi-row inserts if all it is capable of reading is only one row from the inserted table?

    The existing trigger reads all 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

    July 5, 2011 at 2:39 pm

    #1348588

  • RE: insert trigger for related table?

    No further replies here please. OP started a new thread with that question.

    Direct replies to http://www.sqlservercentral.com/Forums/Topic1136799-391-1.aspx

    Please in future keep it to one thread for a question. Thanks.

    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

    July 5, 2011 at 2:37 pm

    #1348586

  • RE: Can we take it to another level, please?

    Winston Daley-344648 (7/5/2011)

    Of course, when I just signed up, like, 5 years ago, it was the best site to me, but as knowledge & experiences grow, it ( SSC )...

    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

    July 5, 2011 at 2:36 pm

    #1348585

  • RE: how to implement a Multirow insert trigger?

    Test to show there's nothing wrong with the trigger as written:

    CREATE TABLE TBL_LOCATIONS (

    Location_Id UNIQUEIDENTIFIER, -- guessing that's what it is

    SomeText VARCHAR(20) -- Since I don't know what the rest...

    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

    July 5, 2011 at 2:30 pm

    #1348581

  • RE: how to implement a Multirow insert trigger?

    The trigger itself will work fine for any number of rows inserted. I can write up a simple test to prove that.

    How are you inserting those multiple rows? You...

    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

    July 5, 2011 at 2:25 pm

    #1348576

  • RE: how to implement a Multirow insert trigger?

    That trigger will work fine for any number of rows inserted.

    If you're doing bulk inserts (bcp, BULK INSERT, SSIS's OLEDB destination), that doesn't fire triggers by default. Tell us 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

    July 5, 2011 at 2:01 pm

    #1348561

  • RE: SQL syntax

    Use EXISTS instead of IN.

    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

    July 5, 2011 at 1:24 pm

    #1348541

  • RE: Change Data Type

    You need to make sure that all the data is compatible with a datetime. Now, the only reason a value in a DATE column would not be castable to DATETIME...

    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

    July 5, 2011 at 1:24 pm

    #1348540

  • RE: SQL syntax

    Use EXISTS.

    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

    July 5, 2011 at 1:19 pm

    #1348538

  • RE: Transparent database encryption

    Thomas Abraham (7/5/2011)

    Here's a thought, how about a small (10 or less) person question review panel to spot problems with questions BEFORE they are posted. That would be a check...

    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

    July 5, 2011 at 1:15 pm

    #1348536

  • RE: user requests

    Read up on the Resource Governor

    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

    July 5, 2011 at 12:42 pm

    #1348525

  • RE: Relationship between logical reads and stats sampling rate

    Indianrock (7/5/2011)

    Improvements are being made to some of our worst-performing select statements, but management really wants specific information like " improvements to these queries means we can run stats at...

    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

    July 5, 2011 at 11:40 am

    #1348494

  • RE: indexes

    You can have a clustered index and up to 999 nonclustered indexes on a table.

    For a well-performing system you will likely need a few nonclustered indexes on each table (generalisation),...

    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

    July 5, 2011 at 11:09 am

    #1348477

  • RE: sql profiler

    allamiro (7/5/2011)

    I think what you meant is enabling trace logs and this can be done through service profiler I think

    Errr.... Trace logs? Service profiler?

    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

    July 5, 2011 at 10:38 am

    #1348450

Viewing 15 posts - 25,156 through 25,170 (of 49,552 total)