Forum Replies Created

Viewing 15 posts - 2,341 through 2,355 (of 26,488 total)

  • RE: Query taking more time

    jkramprakash - Tuesday, November 28, 2017 10:35 AM

    I have a Master table.This table contains two fields

    Listings(Master Table)--------

    TableID   EntityID
    30047     100
    30047     101
    30047     102

    In...

  • RE: Subquery vs join

    ScottPletcher - Tuesday, November 28, 2017 10:45 AM

    There actually is, in theory, a fundamental different between those queries:

    The first query will drop/ignore...

  • RE: Fantasy Football 2017

    Well, Steve was right, he managed to snatch defeat from the jaws of victory.

    The SQL Bolts have managed to secure a playoff berth with a victory over Prestige Worldwide. ...

  • RE: Delete trigger dont fire on related tables

    Can't attest to the validity of the following, but give it a try in a test/development environment:


    CREATE TRIGGER [dbo].[trg_DeleteRecordRelatedtable]
    ON [dbo].[ft]
    FOR DELETE
    AS
    SET...

  • RE: Delete trigger dont fire on related tables

    The simple answer, your trigger will not work as designed when more than one row of data is deleted from the table ft.

    In addition, the variable @ftstamp will...

  • RE: Track Sensitive Data with SQL Server Extended Properties

    Stephen Merkel - Monday, November 27, 2017 7:25 AM

    Seems like a value here is from the record keeping/auditing perspective.
    To lessen the 'out...

  • RE: Fantasy Football 2017

    Sequelsurfer - Monday, November 27, 2017 2:04 PM

    Lynn Pettis - Monday, November 27, 2017 11:55 AM

    November 27, 2017 at 2:05 pm

    #1969612

  • RE: Unusually Expensive Deletes

    sh856531 - Saturday, November 25, 2017 1:21 PM

    Hi all,

    I have a scenario on a few of our servers that I can't quite...

  • RE: Automatic Plan Correction

    Something I was reading about last week so was fresh in my memory.  Amazed I actually remembered it.

  • RE: Are the posted questions getting worse?

    drew.allen - Monday, November 27, 2017 1:13 PM

    Thom A - Monday, November 27, 2017 7:21 AM

    November 27, 2017 at 1:18 pm

    #1969605

  • RE: Fantasy Football 2017

    At this time I am going into next week as the underdog and the British Bulldogs as a slim leader in their last match up.
     

  • RE: Fantasy Football 2017

    Ray K - Monday, November 27, 2017 11:18 AM

    Lynn Pettis - Monday, November 27, 2017 9:39 AM

  • RE: Fantasy Football 2017

    Ray dropped a third game.
    The Full Division may have three teams 6-6.
    In the Bulk Logged Division SQL Bolts still have a one game advantage over the British Bulldogs.  The leader...

  • RE: Table Design

    RonKyle - Sunday, November 26, 2017 4:35 PM

    Adding my vote against the use of GUIDs except for certain circumstances.  Replication comes to...

  • RE: Are the posted questions getting worse?

    Jeff Moden - Thursday, November 23, 2017 11:54 AM

    Lynn Pettis - Wednesday, November 22, 2017 3:34 PM

Viewing 15 posts - 2,341 through 2,355 (of 26,488 total)