Forum Replies Created

Viewing 15 posts - 2,341 through 2,355 (of 49,552 total)

  • RE: Effort to configure Logshipping/Mirroring/Replication/Always on

    Benki Chendu (9/22/2016)

    I would probably factor an hour each for the configuration alone.

    So you're assuming that everything will go right, there will be no delays, no missing passwords, non-working connections,...

    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

    September 22, 2016 at 8:50 am

    #1902500

  • RE: Stuck on a problem with EXEC() (I think)

    Replace the EXEC with PRINT, to print the query to the messages tab and post the resulting dynamic SQL output?

    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

    September 22, 2016 at 7:39 am

    #1902462

  • RE: Are the posted questions getting worse?

    jasona.work (9/22/2016)

    BrainDonor (9/22/2016)

    jasona.work (9/21/2016)

    So a book I'm currently reading (highly recommend, I've actually laughed out loud because of what I'm about to tell you) has possibly the BEST explanation for...

    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

    September 22, 2016 at 6:20 am

    #1902426

  • RE: Database Size Discrepancy

    Mike Scalise (9/22/2016)

    Is it true that indexes are always stored in the ndf, or could they be stored in the mdf too, and both the mdf and ndf are equivalent...

    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

    September 22, 2016 at 6:19 am

    #1902425

  • RE: Database Size Discrepancy

    sys.master_files is, iirc, as-of the time that SQL last started, so if the DB's grown since then it'll be out of date.

    2) Is it surprising that the ndf file is...

    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

    September 22, 2016 at 6:00 am

    #1902417

  • RE: Effort to configure Logshipping/Mirroring/Replication/Always on

    The configuration time, for any of those, is small. It's the design and planning that takes time, and that time is going to be completely dependant on what they 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

    September 22, 2016 at 5:55 am

    #1902414

  • RE: Auto Rollback tran ?

    There are a small number of DDL-related errors (data definition) that abort transactions, a very small number. They're not documented, it's a trial and error to find them, they're exceptions...

    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

    September 22, 2016 at 5:53 am

    #1902413

  • RE: Auto Rollback tran ?

    SSMS will not automatically roll back transactions.

    If you're explicitly turned the XACT_ABORT session setting on, SQL Server (the DB engine, not the client tool) automatically rolls your transaction back on...

    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

    September 22, 2016 at 4:45 am

    #1902400

  • RE: how to make a query for series of records ?

    The stuff you posted in the #tamp table, do you have that data at the start, or is it part of what you want to generate?

    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

    September 22, 2016 at 4:00 am

    #1902392

  • RE: Auto Rollback tran ?

    No. SSMS will not automatically roll back transactions.

    If the update had an error, the update as a whole would have failed, but your transaction is still open and still needs...

    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

    September 22, 2016 at 3:55 am

    #1902391

  • RE: how to make a query for series of records ?

    Recursive CTE can work, but it'll be slow and it's not a good solution.

    Better is to use a calendar table/numbers table. If you don't have one in the DB, create...

    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

    September 22, 2016 at 3:31 am

    #1902382

  • RE: Are the posted questions getting worse?

    BrainDonor (9/22/2016)

    jasona.work (9/21/2016)

    So a book I'm currently reading (highly recommend, I've actually laughed out loud because of what I'm about to tell you) has possibly the BEST explanation for why...

    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

    September 22, 2016 at 3:30 am

    #1902381

  • RE: Strange Blocking

    You need to check the blocked resource, there's no way to tell from what's posted what happened. There could be an explicit transaction and locks taken by earlier statements, 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

    September 22, 2016 at 3:29 am

    #1902379

  • RE: When Is an Execution Plan Cached?

    BWFC (9/22/2016)

    TL;DR: when does an execution plan get a)cached

    When it's run and there is no plan in cache (assuming no recompile hints or options)

    b) cleared from the cache?

    That's much...

    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

    September 22, 2016 at 3:25 am

    #1902377

  • RE: Isolation level inside stored procedures

    Yes, it'll also run with that isolation level.

    I'll give you the same warning as last time. Be very, very careful about read uncommitted. While it makes the symptoms of poorly...

    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

    September 21, 2016 at 8:19 am

    #1902183

Viewing 15 posts - 2,341 through 2,355 (of 49,552 total)