Forum Replies Created

Viewing 15 posts - 22,156 through 22,170 (of 49,552 total)

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

    Dev (11/16/2011)

    I had one of those. I sat down with the architect and explained to him what NoLock actually did and what effects it could have. The standards...

    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, 2011 at 11:08 am

    #1408768

  • RE: Catch Query Timeout attention event. Is it possible?

    You'll have to catch it in the application. To SQL Server, it's not an error. It's the same as clicking 'stop' in management studio.

    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, 2011 at 11:03 am

    #1408765

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

    Dev (11/16/2011)

    But what I am saying is a fact (Live Example). My customer is forcing us to write NOLOCK hint in all queries. It's primary QA check (per...

    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, 2011 at 10:17 am

    #1408731

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

    ashuthinks (11/16/2011)

    hmm alright but my use of WITH(NOLOCK) in delete block is correct or not?

    Syntactically it's correct. It's almost certainly the complete wrong way to go about this, but I'm...

    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, 2011 at 8:16 am

    #1408585

  • RE: Application gets installed but creates only one table in SQL - Please help..!

    Your first stop for this kind of problem should be the application vendor's support people. They're more likely to have a clue than we are (since we have no idea...

    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, 2011 at 8:13 am

    #1408580

  • RE: DBCC Shrinkfile

    derekr 43208 (11/16/2011)

    For instance: I need it to check the size, check the free space, if the free space > a certain % - it needs to shrink the file...

    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, 2011 at 8:10 am

    #1408575

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

    ashuthinks (11/16/2011)

    many reports are accessing this stored procedure at the same time so TO AVOID DEADLOCK I'M USING THI 🙂

    So, if you don't use it you are definitely getting deadlocks?...

    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, 2011 at 8:03 am

    #1408564

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

    ashuthinks (11/16/2011)

    i.m just using this stored procedure for reporting purpose..

    please let me know my usage is at right or not?

    Since when does reporting run deletes?

    Why are you so determined 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

    November 16, 2011 at 7:58 am

    #1408553

  • RE: index record count difference

    Wiesinger (11/16/2011)

    to find the problem I created a simple select with and without the use of an index. Last week we had the same problem with 12 records, so I...

    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, 2011 at 7:53 am

    #1408546

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

    Firstly those 2 hints mean exactly the same thing, so you're just repeating yourself.

    Secondly, those hints have NO place in most code most of the time.

    Thirdly, did you read through...

    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, 2011 at 7:51 am

    #1408539

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/16/2011)

    Logitech Wireless Performance Mouse MX

    +1000000

    I love that mouse.

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

    #1408500

  • RE: index record count difference

    Wiesinger (11/16/2011)

    the checktable (including indexes) reports no error.

    No, it won't now, because the problem went away when you rebuilt the indexes.

    Indexes with a different number of rows 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

    November 16, 2011 at 3:07 am

    #1408323

  • RE: Shrinking a database

    In that case, I'd say don't shrink. Just leave the free space in the data file for the DB to reuse.

    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, 2011 at 3:06 am

    #1408322

  • RE: What should be the standard best practices drive size for tempdb size in capacity planning.

    As Anthony said...

    anthony.green (11/16/2011)

    This is one of them where "how long is a piece of string" comes in to play.

    Unless you know excatly what is thrown through TempDB its a...

    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, 2011 at 3:06 am

    #1408321

  • RE: Shrinking a database

    How big's the DB? How long do you expect it will take to reuse that 250GB (based on the database's current growth rate)

    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, 2011 at 2:59 am

    #1408314

Viewing 15 posts - 22,156 through 22,170 (of 49,552 total)