Forum Replies Created

Viewing 15 posts - 4,396 through 4,410 (of 8,753 total)

  • RE: Deadlocks

    Looking at the DG again, I think the Workflow table has nothing to do with the deadlock, it is just part of one of the implicit transactions that are trying...

  • RE: Deadlocks

    Lynn Pettis (10/2/2015)


    There are no foreign key relationships between any of the tables in the database. There is no table above the base report tables (OperationsSIGACTDraftReport OperationsSIGACTPublishedReport, etc)....

  • RE: Are the posted questions getting worse?

    Lynn Pettis (10/1/2015)


    In my Deadlock thread, was I wrong to admonish the former MVP over his first post? It just hit me wrong.

    I think it was on the overreacting...

  • RE: Deadlocks

    Quick question, are the ReportKey columns in in both tables coming from a third table or are there any other such indirect relationships?

    😎

    +---------------+ ...

  • RE: Today's Random Word!

    djj (10/1/2015)


    Ed Wagner (10/1/2015)


    anthony.green (10/1/2015)


    crookj (9/30/2015)


    Ed Wagner (9/30/2015)


    DonlSimpson (9/30/2015)


    Ed Wagner (9/30/2015)


    anthony.green (9/30/2015)


    Ed Wagner (9/30/2015)


    anthony.green (9/30/2015)


    whereisSQL?(9/30/2015)


    Pour

    Pitcher

    Beer

    Brew

    Pub

    Bar

    Prohibit

    Disallow

    Explicit

    Implicit

    Convert

    Morph

  • RE: Incorrect Syntax Near 'Go'

    andy 61637 (10/1/2015)


    Is there a way to have SSMS generate a create script using ; instead of go ? My create script is huge, quite a lot of editing...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have...

  • RE: Are the posted questions getting worse?

    David Burrows (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have you found ESB on draught?

    Many many moons...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have you found ESB...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have you found ESB on draught?

    The Ale&Pie...

  • RE: Like Statement With Parameters

    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    Here is a quick solution that fits nicely for simple usage.

    😎

    Your plan shows a seek for a double-wildcarded parameter...must play with this at home. Thanks for posting,...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have you found ESB on draught?

    The Ale&Pie on High...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

  • RE: Like Statement With Parameters

    Here is a quick solution that fits nicely for simple usage.

    😎

    Test data set for demonstration

    USE TEEST;

    /* Safe place to play in */

    GO

    SET NOCOUNT ON;

    IF OBJECT_ID(N'dbo.Person') IS NOT NULL DROP TABLE...

Viewing 15 posts - 4,396 through 4,410 (of 8,753 total)