Forum Replies Created

Viewing 15 posts - 496 through 510 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Steve, something changed in the notification emails?
    I don't think I shout be getting users' emails instead of username.

    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

    January 4, 2018 at 1:22 pm

    #1974522

  • RE: Multiple Files in a FileGroup but still space issue error.

    If there's a second file in primary, new pages should be allocated with proportional fill, meaning the full file gets no pages and the empty gets all new pages. 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

    January 4, 2018 at 1:06 pm

    #1974518

  • RE: Trigger to avoid drop online database

    DDL triggers are AFTER triggers, meaning they fire within the transaction *after* the changes have been made. So at that point, there is no record in sys.databases for the DB...

    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

    January 4, 2018 at 1:10 am

    #1974393

  • RE: Insert Into Where NOT Exists

    shannonphillips - Wednesday, January 3, 2018 1:28 PM

    Scott Coleman - Wednesday, January 3, 2018 12:58 PM

    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

    January 3, 2018 at 2:17 pm

    #1974349

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Wednesday, January 3, 2018 12:42 PM

    I remember the one time it snowed in South Carolina when I lived there....

    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

    January 3, 2018 at 1:05 pm

    #1974331

  • RE: Insert Into Where NOT Exists

    One option:
    Instead of DISTINCT

    GROUP BY <primary key> and then decide what you want to do with each of the other columns (MIN, MAX or other aggregation)

    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

    January 3, 2018 at 12:57 pm

    #1974329

  • RE: Is there a way to identify dynamic sql that may be vulnerable to sql injection?

    Thom A - Wednesday, January 3, 2018 11:47 AM

    GilaMonster - Wednesday, January 3, 2018 11:21 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

    January 3, 2018 at 12:07 pm

    #1974311

  • RE: Replayable Extended Events?

    Google search for "DReplay Extended Events" First result:
    https://borishristov.com/blog/t-sql-tuesday-67-extended-events-and-distributed-replay/

    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

    January 3, 2018 at 12:04 pm

    #1974310

  • RE: Insert Into Where NOT Exists

    That shouldn't even compile, because this does not exist as a table: [EDIImpTbl_ComputerInventory].[Service Tag]

    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

    January 3, 2018 at 11:53 am

    #1974307

  • RE: issue joining on Temp Table

    JOIN #Temp ON ...
    Then you can reference it further down. Same as any other table.

    You can't say
    FROM Customers inner join OrderDetails on Customers.ID = Orders.CustomerID, same...

    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

    January 3, 2018 at 11:31 am

    #1974302

  • RE: Replayable Extended Events?

    There is a way to convert an extended events output to trace so that DReplay can read it. Don't have links offhand, google should turn them up.

    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

    January 3, 2018 at 11:29 am

    #1974301

  • RE: Is there a way to identify dynamic sql that may be vulnerable to sql injection?

    sp_statement_completed & sql_statement_completed and look for sp_executesql or EXEC with brackets.
    Or the entire batch with sql_batch_completed and RPC completed. Eitherway, a second filter is necessary, and probably better to...

    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

    January 3, 2018 at 11:21 am

    #1974300

  • RE: Insert Into Where NOT Exists

    SELECT 1 means just that. Select the literal value 1. It's used in EXISTS because SQL doesn't care about the columns in an EXISTS. You could replace it with SELECT...

    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

    January 3, 2018 at 10:41 am

    #1974286

  • RE: Is there a way to identify dynamic sql that may be vulnerable to sql injection?

    juniorDBA13 - Wednesday, January 3, 2018 7:05 AM

    My questions was how to identify if you are currently vulnerable to attacks and how...

    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

    January 3, 2018 at 7:52 am

    #1974228

  • RE: Trigger to avoid drop online database

    What do you mean 'it can't fetch state_desc'?

    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

    January 3, 2018 at 7:51 am

    #1974227

Viewing 15 posts - 496 through 510 (of 49,552 total)