Forum Replies Created

Viewing 15 posts - 841 through 855 (of 49,552 total)

  • RE: Select queries deadlocking each other??

    SELECTs alone can't deadlock.

    The statements you see in the deadlock graph are the ones that completed the deadlock, not all of the statements involved. From a look 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

    August 25, 2017 at 6:21 am

    #1956805

  • RE: Are the posted questions getting worse?

    jasona.work - Friday, August 25, 2017 5:44 AM

    Thankfully the customer has a plan to refactor their mess of an application once we...

    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 25, 2017 at 6:11 am

    #1956804

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Friday, August 25, 2017 5:13 AM

    Wow. He deleted the entire TRY CATCH thread too.

    I find myself wondering if he'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

    August 25, 2017 at 5:55 am

    #1956802

  • RE: Updating 60 column of null value ?

    Yes, make the column NOT NULL, then any attempt to insert/update to NULL will throw an error.

    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 25, 2017 at 4:36 am

    #1956776

  • RE: Implicit converts for inserts

    The only place where implicit conversions can cause scans is when they happen in the JOIN or WHERE clause of a statement (any statement)

    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 25, 2017 at 4:33 am

    #1956773

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, August 24, 2017 1:04 PM

    Sadly in my first response I stated the format of his error handling...

    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 24, 2017 at 1:08 pm

    #1956711

  • RE: Are the posted questions getting worse?

    @Lynn
    This is how he's handling transactions: https://www.sqlservercentral.com/Forums/1893210/Are-These-Two-Code-Fragments-Equal

    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 24, 2017 at 11:45 am

    #1956689

  • RE: Are the posted questions getting worse?

    Anyone want to help here?
    https://www.sqlservercentral.com/Forums/1893562/Using-Try-Catch-With-Stored-Procedures

    I'll pass, he's taken none of the advice from the last two threads that I participated in about why the design...

    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 24, 2017 at 7:52 am

    #1956625

  • RE: Temp table

    Grant Fritchey - Thursday, August 24, 2017 5:52 AM

    She just likes Star Wars (although I don't hold that against her).

    😛

    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 24, 2017 at 6:20 am

    #1956592

  • RE: Left outer join make duplicate column name

    Put cursor next to the * in the SELECT. Press TAB. Remove columns you don't want.

    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 24, 2017 at 6:16 am

    #1956591

  • RE: Temp table

    Looks more like you want a subquery, not a temp table.

    Something like:

    SELECT U.actionID,
       M.CardNum,
       M.serieID,
    ...
    FROM  Upgrades U

    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 24, 2017 at 5:00 am

    #1956565

  • RE: Why i am not being able to insert values into table variable ?

    sunilchand - Thursday, August 24, 2017 3:47 AM

     I want to ask you if there there is way to run them separately...

    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 24, 2017 at 4:42 am

    #1956562

  • RE: Why i am not being able to insert values into table variable ?

    Your code runs fine.

    What version of SQL are you running?

    Edit: I see what you're doing.
    Table variables are batch-scoped, like normal variables. You can't create 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 24, 2017 at 3:37 am

    #1956555

  • RE: Are These Two Code Fragments Equal?

    vincentshanecurtis - Wednesday, August 23, 2017 7:16 AM

    Data Source=.\SQLEXPRESS;AttachDbFilename=E:\Yu-Gi-Oh\db\Yu-Gi-OhCardsDBSQL.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

    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 23, 2017 at 7:39 am

    #1956374

  • RE: Best Approach For Junction Table Mainrenace

    Orlando Colamatteo - Wednesday, August 23, 2017 6:40 AM

    vincentshanecurtis - Wednesday, August 23, 2017 12:35 AM

    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 23, 2017 at 6:53 am

    #1956362

Viewing 15 posts - 841 through 855 (of 49,552 total)