Forum Replies Created

Viewing 15 posts - 29,296 through 29,310 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Oh for crying out loud...

    Conversation from 5 min ago.

    PM: We agreed that you'd start the investigation for <really complex and possibly impossible data extrapolation> on Monday. Is there any way...

    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 19, 2010 at 5:37 am

    #1252970

  • RE: Query optimization for huge tables

    Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Optimising big tables is about the same as small tables, just a little less forgiving

    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 19, 2010 at 5:31 am

    #1252967

  • RE: Transaction table updation

    Huh?

    Imagine you know nothing about the situation, then read over what you wrote and see if you think anyone can understand it. Please clarify and explain further.

    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 19, 2010 at 4:25 am

    #1252944

  • RE: Datbase is in Suspect mode

    Restore from backup and do some investigation of the IO subsystem.

    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 19, 2010 at 4:22 am

    #1252940

  • RE: SQL 2008 Profiler

    If login name has the form machineName\LoginName, it's a windows authentication connection. SQL Authentication will show the Login just as the login name (no machine prefix) and NTUsername 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

    November 19, 2010 at 4:17 am

    #1252939

  • RE: SQL 2008 Profiler

    It's only populated if the user logged in using Windows authentication. If they're using SQL authentication that will be blank and the LoginName will just display the SQL Login name.

    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 19, 2010 at 1:36 am

    #1252903

  • RE: Age-old question: Cluster on Date or ID?

    Craig Farrell (11/18/2010)

    I'm rather shocked that it decided to seek off one and not on the other. It makes a twisted kind of sense though, but one I'd...

    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 19, 2010 at 1:12 am

    #1252895

  • RE: Age-old question: Cluster on Date or ID?

    Craig Farrell (11/19/2010)

    Hm, I had though the key lookup would seek the index, for groups, not single row loop. Interesting. I'll have to explore more deeply into that....

    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 19, 2010 at 12:59 am

    #1252891

  • RE: AutoIncrement number

    Simple reason - efficiency. Same reason that, should an insert fail, those identity values are not reused.

    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 19, 2010 at 12:51 am

    #1252890

  • RE: CHECKDB - Catalog Msg 3853

    You don't need to export and recreate the database, there's an easy fix for this corruption that works in most cases

    See http://sqlinthewild.co.za/index.php/2009/08/26/corruption-in-sysdependencies/

    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 19, 2010 at 12:46 am

    #1252888

  • RE: Age-old question: Cluster on Date or ID?

    Craig Farrell (11/18/2010)

    If the rows are properly located via the NC index, and then a lookup is performed back to the Clustered to get the attribute not INCLUDEd, this 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

    November 18, 2010 at 11:10 pm

    #1252867

  • RE: How to change SQL Server Collation

    I chatted with a few friends on this.

    The trace flags aren't necessary. 4022 ignores startup procedures. 3659 is used as part of installation.

    The -q does change collation of everything....

    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 18, 2010 at 11:08 pm

    #1252866

  • RE: Use of temp table

    Jeff Moden (11/18/2010)

    Actually, that's not the best advice. IIRC (Gail, please correct me if I'm wrong), Temp Tables have space reserved and the definition is preserved for a bit...

    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 18, 2010 at 10:48 pm

    #1252861

  • RE: How to make data(.mdf) to equal size slices!

    pavan_srirangam (11/18/2010)

    the DDL is select * into table and then drop table commands

    But there are several queries like that

    Long term, I'd be looking at changing those to temp tables...

    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 18, 2010 at 11:37 am

    #1252675

  • RE: How to make data(.mdf) to equal size slices!

    What kind of DDL are you doing in that DB (table create/drop) that has that kind of effect on the allocation pages?

    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 18, 2010 at 11:30 am

    #1252670

Viewing 15 posts - 29,296 through 29,310 (of 49,552 total)