Forum Replies Created

Viewing 15 posts - 41,461 through 41,475 (of 49,552 total)

  • RE: SQL Server Architecture? What's going on behind the scenes?

    ashepard (1/23/2009)

    I've been told to make database page size an even multiple of disk page size.

    If you are working with short rows, like a domian table of values then...

    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 23, 2009 at 1:26 pm

    #932014

  • RE: Newbie:Why is select doing a table scan?

    See here - http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/

    Edit: don't use index hints unless you are really sure you know what they're doing and why the optimiser didn't pick that index 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 23, 2009 at 1:07 pm

    #932009

  • RE: Are deadlocks more frequent in 2005 due to page level locks?

    Grant Fritchey (1/23/2009)

    I haven't run averages on my systems recently, but 20ms just for recompiles seems a bit high for an average.

    The 20 is compiles/sec, not sec/compile. There's no counter...

    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 23, 2009 at 12:58 pm

    #932004

  • RE: Backup successful but can't write to msdb - due to space issues backups of msdb limited

    Keena Ferguson (1/23/2009)

    Gail,

    You are correct ... I only copied the first few lines ... I have attached the entire results set ... I have been looking at the DBCC CHECKDB...

    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 23, 2009 at 12:47 pm

    #932001

  • RE: Backup successful but can't write to msdb - due to space issues backups of msdb limited

    Is that the full output from CheckDB? It doesn't look like it. Can you please the full output. (If it's large, save it to a text file, zip and attach)

    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 23, 2009 at 1:06 am

    #931674

  • RE: PROCEDURE WITH IN THE PROCEDURE

    MarkusB (1/23/2009)

    But I also noticed that this is a MYSQL procedure, not SQL Server. So you might better post it to a MySQL forum.

    Good catch. I didn't even read 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 23, 2009 at 1:03 am

    #931673

  • RE: [newbie] [error] Incorrect Syntax near the Keyword

    What you can do in VS is build that up as a string, assign it to a variable, do a debug.print (or equivalent) to get the string that will be...

    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 23, 2009 at 12:54 am

    #931671

  • RE: Query has terrible performance

    I think I've found the major problem. You're missing brackets in the where clause. ANDs have precedence over ORs, so the way your where clause is written (with an 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

    January 23, 2009 at 12:53 am

    #931670

  • RE: Query has terrible performance

    Jessica (1/22/2009)

    I don't think I can upload the actual sqlplan file on here.

    Zip it and attach it. If possible, for the actual exec plan, not the estimated.

    The jpg doesn't have...

    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 23, 2009 at 12:39 am

    #931664

  • RE: PROCEDURE WITH IN THE PROCEDURE

    You say you're getting an error when calling that? What would the specific error message be?

    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 23, 2009 at 12:30 am

    #931661

  • RE: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

    It means you're calling a procedure, view or function from your procedure, and then from that proc calling another, etc 32 levels deep. Or it could be recursive with 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 23, 2009 at 12:29 am

    #931660

  • RE: Dead lock occured

    madhu.arda (1/22/2009)

    Is these dead locks are anyway related to having different collation settings.

    Unlikely. Different collation would give you a collation mismatch error if there was a problem.

    All I know 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

    January 23, 2009 at 12:28 am

    #931659

  • RE: Conistency Errors on SQL 7.0 DB

    The_SQL_DBA (1/22/2009)

    Paul, one question as a DBA what is the best way to avoid corruption in the first place..

    I'm not Paul, but...

    Ensure your IO subsystem is stable and performing...

    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 22, 2009 at 2:26 pm

    #931481

  • RE: SQL Server Architecture? What's going on behind the scenes?

    ashepard (1/22/2009)

    Gail, do you have a good web rescource showing all the internal procecess that SQL 2005 or 2008 runs (log writer, dead lock detection, memory manager, etc)

    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

    January 22, 2009 at 2:14 pm

    #931469

  • RE: Are deadlocks more frequent in 2005 due to page level locks?

    Ummmm... forced parameterisation's not a band-aid. It can hurt more than help. It's used when you don't have access to the source code and hence can't change the queries 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 22, 2009 at 2:02 pm

    #931451

Viewing 15 posts - 41,461 through 41,475 (of 49,552 total)