Forum Replies Created

Viewing 15 posts - 22,666 through 22,680 (of 49,552 total)

  • RE: Index scan vs. seek

    David Moutray (10/27/2011)

    I would bet that the statistics for this index are out of date. The statistics are only updated when 20% of the records in the index (plus...

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

    #1400527

  • RE: In which situation OPTION RECOMPILE is required in SProcedure's Definition?

    Abrar Ahmad_ (10/28/2011)

    SQL Server tries best to maintain execution plans of objects as to maximum extent possible, but in case why we need to recompile a stored procedure each time?...

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

    #1400525

  • RE: Index scan vs. seek

    Can you post the index definition please?

    Can you post the execution plan please?

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

    #1400520

  • RE: Help!!!!!! shrink large db files

    Ok, so why are you dropping the nonclustered indexes and trying to shrink 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

    October 28, 2011 at 2:20 am

    #1400519

  • RE: performance problems cpu's at 70%

    81 is a query running in parallel.

    For tuning - http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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 27, 2011 at 4:24 pm

    #1400437

  • RE: Help!!!!!! shrink large db files

    What are you trying to achieve here?

    Are those nonclustered indexes going to be recreated?

    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 27, 2011 at 4:23 pm

    #1400435

  • RE: Maximum Database Size in 2005\2008\R2\Denali 524,258 vs 524,272

    mehmetguzel (10/27/2011)

    This mean maybe max size of log file 16 TB

    32,767*16 TB=524272

    Max size of a log file is 2TB.

    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 27, 2011 at 3:45 pm

    #1400427

  • RE: Non-Clustered Indexes and Truncated Tables

    Indexes are always kept up to date with data modification, so when the table is truncated, so are the indexes. When the table is repopulated, the indexes are updated with...

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

    #1400326

  • RE: Who Ran Queries SQL 2008

    No. SQL doesn't keep track of that. You can use SQLAudit (I think) or a trace for that kind of information.

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

    #1400310

  • RE: Poll - "SQL Server Administrator"

    That's pretty much how things were at the bank. Separation of responsibilities and all that, the DBAs didn't have local admin on the servers, which really limits the ability 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

    October 27, 2011 at 11:10 am

    #1400302

  • RE: Massive IOs!

    TheSQLGuru (10/27/2011)

    In any case I am not actually "in the running" for this non-job consulting gig either. I am (very thankfully) over-booked for months out.

    I wish 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

    October 27, 2011 at 9:30 am

    #1400245

  • RE: sys.dm_db_index_usage_stats

    Adi Cohn-120898 (10/27/2011)

    Just look at the query plan. The number of times that you see the seek operator in the query plan, is the number of times that 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

    October 27, 2011 at 8:55 am

    #1400217

  • RE: sys.dm_db_index_usage_stats

    If a query seeks and returns 32000 rows, it's a single seek, so it should only increase the counter by 1. It's number of seeks, not number of rows returned...

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

    #1400190

  • RE: database crashed

    Step 1: Identify exactly what is wrong, because no resolution is possible until we know exactly what's wrong. Could be that a restore isn't even necessary, so a massive waste...

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

    #1400186

  • RE: Massive IOs!

    Ninja's_RGR'us (10/27/2011)

    Don't you love the smell of backstabbing in the morning? 🙂

    Note to the <non hiring> op. Both these 2 seem to love using knives while I don'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 27, 2011 at 7:58 am

    #1400169

Viewing 15 posts - 22,666 through 22,680 (of 49,552 total)