Forum Replies Created

Viewing 15 posts - 29,191 through 29,205 (of 49,552 total)

  • RE: SQL Server Baseline

    Well I don't know where you stand and I don't know what your job description is so.... everything. 😉

    If you don't have a firm grip of backups and restores, start...

    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 24, 2010 at 9:17 am

    #1255154

  • RE: Column Order in an Index

    gosh (11/24/2010)

    I expected proof that there was a performance difference between the order of columns in a composite index or a performance difference in the order of columns in 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

    November 24, 2010 at 9:14 am

    #1255153

  • RE: Licensing Questions

    Each user would need a CAL. If you don't know how many users there will be (normal for a web implementation) then you need to go per-processor.

    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 24, 2010 at 6:58 am

    #1255056

  • RE: SQL Server Baseline

    For example SQL Cache Memory (KB) has several 1072 and 1088 entries. Is this good? Is this bad?

    It depends. What's normal for your system?

    That's the answer for most 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

    November 24, 2010 at 6:54 am

    #1255048

  • RE: DBCC checkdb error in master database

    Restore from backup. Those kind of errors usually indicate irreparable corruption.

    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 24, 2010 at 6:53 am

    #1255047

  • RE: Filtered indexes from DMVs?

    Can you expand on what you're thinking?

    The missing index DMVs (if those are the ones you mean) will never suggest filtered indexes, it's one of their limitations. I think 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

    November 24, 2010 at 6:49 am

    #1255044

  • RE: Is there any Performance impact on database while taking the backup

    A) Yes

    B) No

    C) Maybe (offhand not sure)

    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 24, 2010 at 4:07 am

    #1254981

  • RE: Default value should be 0 or NULL usually?

    Depends on the column, what it stores, what the data means and what 'unknown' means in the context of that data column.

    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 24, 2010 at 3:51 am

    #1254973

  • RE: slow query due to index fragmentation?

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

    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 24, 2010 at 3:47 am

    #1254972

  • RE: Split Backup

    That's referred to as striping the backup.

    Check out the backup database command in Books Online. If you specify multiple destinations, the backup is striped across them. Restore works the same...

    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 24, 2010 at 2:07 am

    #1254938

  • RE: Split Backup

    What do you mean by 'split backup'?

    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 24, 2010 at 1:56 am

    #1254933

  • RE: Help with SQL SCRIPT Causing Deadlock

    GilaMonster (11/23/2010)

    If it's deadlocking, we need to see what it's deadlocking with and on what resources.

    Enable traceflag 1222. That will write the output of the deadlock graph into the error...

    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 24, 2010 at 1:05 am

    #1254922

  • RE: Column Order in an Index

    taylor_benjamin (11/23/2010)

    In the case of your article, the optimizer was intelligent enough to know that the existing index was more optimized than a table scan. When this doesn't work, simply...

    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 23, 2010 at 10:58 pm

    #1254893

  • RE: Are the posted questions getting worse?

    Paul White NZ (11/23/2010)

    I haven't done enough with mirroring to justify the purpose before, and wasn't aware of the assemblies book. The third one would be the service broker...

    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 23, 2010 at 2:52 pm

    #1254768

  • RE: DBCC Commands like CHECKDB and calculating estimated Duration

    As I mentioned earlier, any corruption is an indication of problems in the IO subsystem.

    Corrupt pages don't usually appear and disappear, unless the pages are getting deallocated (index rebuilds, deletes)

    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 23, 2010 at 1:22 pm

    #1254710

Viewing 15 posts - 29,191 through 29,205 (of 49,552 total)