Forum Replies Created

Viewing 15 posts - 20,941 through 20,955 (of 49,552 total)

  • RE: Replacing Index Scan with Index Seek

    Short answer, you can't.

    That LIKE has a leading wildcard, it's a non-SARGable predicate and the only way that can execute is with a scan, table or index. (imagine a telephone...

    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 18, 2012 at 6:08 am

    #1435184

  • RE: SQL profiler 2008 "Reads" column

    bathawes 16438 (1/18/2012)

    Surely if this were an issue with the query itself it would always be slow?

    No, not at all. In fact, I gave an hour long presentation last 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

    January 18, 2012 at 5:59 am

    #1435180

  • RE: ssis and ssrs interview questions

    Gazareth (1/18/2012)

    And Wikipedia's "block" appears to be the equivalent of a hand-written sign hanging on an open door saying "We're Closed, honest." :hehe:

    Intentionally.

    http://en.wikipedia.org/wiki/Wikipedia:SOPA_initiative/Learn_more

    Is it still possible to access Wikipedia in...

    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 18, 2012 at 5:23 am

    #1435165

  • RE: SQL profiler 2008 "Reads" column

    No.

    The problem is going to be in the definition of the query and the execution plan chosen

    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 18, 2012 at 5:19 am

    #1435163

  • RE: SQL profiler 2008 "Reads" column

    bathawes 16438 (1/18/2012)

    I would have thought more reads from buffer pool = less reads from disk

    No, not necessarily. More reads from buffer pool = more reads from buffer pool, nothing...

    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 18, 2012 at 5:02 am

    #1435151

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (1/18/2012)

    Since 2000 the databases I've dealt with have been required to deliver a service 24 hours a day 7 days a week, so there's no way any...

    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 18, 2012 at 4:57 am

    #1435148

  • RE: DBCC CHECKDB

    And for one database that shows yesterday?

    Sure there's no maint plan that someone set up? (btw, CheckDB daily is a good 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

    January 18, 2012 at 4:53 am

    #1435145

  • RE: SQL profiler 2008 "Reads" column

    They are logical reads, from the buffer pool.

    All SQL reads are from the buffer pool, the higher levels of the storage engine and the query processor don't access the...

    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 18, 2012 at 4:43 am

    #1435138

  • RE: Index dmv

    Nic-306421 (1/18/2012)

    However to confirm, if level 0 is the leaf and the root is level 1, if I did have intermediate rows what level would these be at, as 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 18, 2012 at 4:40 am

    #1435136

  • RE: ms db crash

    vultar (1/18/2012)

    vultar (1/18/2012)You will also need to stop the SQL agent if it's it still running.

    There's no need to. I would not recommend this (or anyhing else) until the OP...

    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 18, 2012 at 4:34 am

    #1435128

  • RE: Index dmv

    Limited just shows you the leaf level of the index, so that 101 pages is the number of pages in the leaf level.

    Detailed shows you all the levels of the...

    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 18, 2012 at 4:32 am

    #1435125

  • RE: DBCC CHECKDB

    And that query 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

    January 18, 2012 at 4:30 am

    #1435121

  • RE: Does Table Value function caches execution plan?

    And why do you think that hints will

    1) Make the first execution faster?

    2) Be better than what the optimiser comes up with itself?

    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 18, 2012 at 4:12 am

    #1435113

  • RE: SQL 2012 vs SQL 2008 R2

    http://www.google.com/search?q=changes+between+SQL+2008+and+SQL+2012

    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 18, 2012 at 4:00 am

    #1435103

  • RE: need quick reply yes/no from experts

    crazy4sql (1/18/2012)

    ok, so then how sql come to know while restoring the database that it need to add the specific amount of free space in database files and as exact...

    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 18, 2012 at 3:58 am

    #1435102

Viewing 15 posts - 20,941 through 20,955 (of 49,552 total)