Forum Replies Created

Viewing 15 posts - 4,276 through 4,290 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    robert.sterbal 56890 (11/16/2015)

    GilaMonster wrote:

    Second? Well past 20th in the two cases that triggered that post.

    I'm going to ignore your (repeated) implication that I don't try to teach people. Feel free...

    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

    November 16, 2015 at 1:23 pm

    #1840119

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/16/2015)

    Ed Wagner (11/16/2015)

    BrainDonor (11/16/2015)

    djj (11/16/2015)

    I will be the first to admit I am not the smartest person, but at least I try to ask questions by providing requested...

    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

    November 16, 2015 at 9:13 am

    #1839996

  • RE: Are the posted questions getting worse?

    robert.sterbal 56890 (11/16/2015)

    Can you use it as a teachable moment? Maybe the second time you observe the lack of thought?

    Second? Well past 20th in the two cases that triggered that...

    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

    November 16, 2015 at 9:09 am

    #1839994

  • RE: 150 GB Backup (compressed) taking over 1 day

    Backup time is mostly IO subsystem, reads from the source DB, writes to the backup device.

    Check perfmon for the latency on the drives involved, speak with your storage admin about...

    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

    November 16, 2015 at 8:59 am

    #1839991

  • RE: Increasing speed of sys.dm_db_index_physical_stats

    PageIOLatch is an IO subsystem wait. Maybe chat with your storage admin as to why you're seeing IO-related waits?

    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

    November 16, 2015 at 3:40 am

    #1839901

  • RE: update statement in batches versus straight up all at once update - assessing which is better

    polkadot (11/15/2015)

    I have been in a situation though where the maintenance window for updating tables was narrow and the straight up update (no predicate) would be better because it'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

    November 15, 2015 at 4:13 pm

    #1839862

  • RE: update statement in batches versus straight up all at once update - assessing which is better

    Also note that your tests are not actually equivalent

    The first one updates all rows to a particular value, not, as you indicated "update the values in the Unitcost column of...

    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

    November 15, 2015 at 2:00 pm

    #1839857

  • RE: NOT IN versus IN

    polkadot (11/15/2015)

    I usually wonder why LIKE isn't used instead

    ie.

    where yourColumn has numbers eg. LIKE '%[0-9]%'

    Probably because they do two different things

    NOT LIKE '%[^0-9]%'

    Return the rows where the column consists of...

    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

    November 15, 2015 at 1:37 pm

    #1839855

  • RE: Assigning TOP 1 value to a variable in a stored procedure

    TOP 1 goes before the variable name, not after. As written, you're saying

    @currentMYID = TOP, which is obviously not what you intend.

    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

    November 15, 2015 at 4:33 am

    #1839844

  • RE: Are the posted questions getting worse?

    I am getting seriously tired of the lack of thought and understanding evidenced by recent questions from certain individuals. Is a little bit of independent work and research really too...

    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

    November 14, 2015 at 12:27 pm

    #1839826

  • RE: Access SQL Server DB from multiple computers

    That's exactly how you normally use SQL Server. Install SQL in the central server, put the database on there, then you application connects to that SQL instance.

    If you don't know...

    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

    November 14, 2015 at 12:06 pm

    #1839824

  • RE: Show First Order With All of User Orders

    Try MIN(OrderMonth) OVER (<windowing clause>)

    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

    November 14, 2015 at 7:57 am

    #1839807

  • RE: Choose Best Clustering Plan For Always On - in sql server 2014

    You should have been clear in your title and post that you were asking about Availability Groups, not clustering (which the title stated)

    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

    November 14, 2015 at 7:56 am

    #1839806

  • RE: Choose Best Clustering Plan For Always On - in sql server 2014

    Neither of those are feasible for Always On Failover Clustering. With failover clustering, the instance fails over. The first would work if you put two instances on the HA server,...

    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

    November 14, 2015 at 1:45 am

    #1839795

  • RE: Query Performance Problem

    To be honest, the performance if probably the smallest problem there. That code has race conditions in it. I suspect it's throwing the occasional unique constraint violation (and if not,...

    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

    November 14, 2015 at 1:41 am

    #1839794

Viewing 15 posts - 4,276 through 4,290 (of 49,552 total)