Forum Replies Created

Viewing 15 posts - 2,236 through 2,250 (of 49,552 total)

  • RE: Stock Updation Trigger on multiple rows deletion

    tahirfarooq (10/14/2016)

    Can you give me example code Plz

    Gianluca gave you an example you can start from.

    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

    October 14, 2016 at 5:05 am

    #1906532

  • RE: Add data to Clustered Table Or Building Clustered Index after inserting data - Which is better ?

    BrainDonor (10/14/2016)

    For your statistics updated date - run a query that filters on the clustered index and then check for your statistics update. Of course you could run UPDATE STATISTICS...

    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

    October 14, 2016 at 5:03 am

    #1906531

  • RE: Performance question

    Easy enough, you've got the queries. Schedule them run for a day or so.

    But I suspect you're looking in the wrong place. Deadlocks are extremely unlikely to be caused by...

    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

    October 14, 2016 at 5:01 am

    #1906530

  • RE: Stock Updation Trigger on multiple rows deletion

    Keep it simple, an update to Products from deleted, use the pseudotable to see the quantity on the deleted rows.

    No cursors, no loops!

    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

    October 14, 2016 at 2:05 am

    #1906507

  • RE: Performance question

    river1 (10/14/2016)

    Available physical memory is high

    There's your answer on the memory

    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

    October 14, 2016 at 1:55 am

    #1906505

  • RE: Are the posted questions getting worse?

    Grant Fritchey (10/13/2016)

    Sean Lange (10/13/2016)

    WOW...http://www.sql-datatools.com/2016/05/sql-queries-tuning-and-optimization.html

    This is supposed to be a list of things to do to optimize queries. While some of these are valid most of them lack context or...

    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

    October 13, 2016 at 8:17 am

    #1906336

  • RE: Performance question

    river1 (10/13/2016)

    Is there a way to see if SQL server is asking for more memory?

    Deadlocks are unlikely to be caused by insufficient memory. They're caused usually by inefficient queries and/or...

    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

    October 13, 2016 at 8:10 am

    #1906330

  • RE: Are the posted questions getting worse?

    BLOB_EATER (10/13/2016)

    I watched your sqlbits conference ( first time I got to see what you look like) I thought you were mid 30s..

    Not too far off. 40 later this year...

    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

    October 13, 2016 at 6:28 am

    #1906299

  • RE: Are the posted questions getting worse?

    20 years ago I was at University. 2nd year specifically, Maths, Physics, Computer Science.

    And I'm one of the oldest people at my current company (CEO is 2 years younger than...

    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

    October 13, 2016 at 6:05 am

    #1906294

  • RE: DBCC CHECKDB error

    JasonClark (10/12/2016)

    Try the below steps:

  • Copy database files to another location
  • Delete main files
  • Restart SQL Service.

  • In management studio the database will be shown with "Recovery Pending" in front of its name, delete...

    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

October 13, 2016 at 3:19 am

#1906275

  • RE: Transaction log is not truncated even after log backup in FULL recovery model

    Why do you say the log isn't being truncated? Where are you looking and what are you expecting to see that you aren't?

    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

    October 13, 2016 at 3:09 am

    #1906272

  • RE: Stored procedures access count

    Without some custom monitoring or auditing, you can't.

    The procedure_stats DMV shows execution count since the procedure was last compiled, but that's all you can get, and last compile won't usually...

    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

    October 12, 2016 at 3:53 am

    #1906064

  • RE: What do you do or think about on the way to work?

    Rod at work (10/11/2016)

    ... and Pluralsight subscription with downloadable capabilities. The Pluralsight subscription is pricy, but if you're like me and don't have reliable cell phone coverage, you take what...

    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

    October 12, 2016 at 3:29 am

    #1906060

  • RE: Are the posted questions getting worse?

    BLOB_EATER (10/12/2016)

    Hi guys, is anyone willing (and kind enough) to review a post I am doing on SQL Memory? Basically I want to talk about total vs target and show...

    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

    October 12, 2016 at 3:23 am

    #1906057

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (10/11/2016)

    GilaMonster (10/10/2016)

    Brandie Tarvin (10/10/2016)

    Hugo, are you heading west (over the Atlantic) or east (over the Pacific) on your Amsterdam to Seattle leg?

    North. The flight goes over Greenland and...

    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

    October 11, 2016 at 4:26 am

    #1905851

    • Viewing 15 posts - 2,236 through 2,250 (of 49,552 total)