Forum Replies Created

Viewing 15 posts - 35,146 through 35,160 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Ok, who has the crystal ball? I have a thread that appears to need some foresight or divination

    http://www.sqlservercentral.com/Forums/Topic837021-392-1.aspx

    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

    December 22, 2009 at 1:40 am

    #1095279

  • RE: Backup and insert

    What are the errors that you're getting? It is not possible to help you resolve errors if we don't know what they are.

    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

    December 22, 2009 at 1:36 am

    #1095278

  • RE: Index

    Raghavender (12/21/2009)

    select * from sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED')

    I am getting the same index two or more times on same table with different fragmentations and different page numbers. in 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

    December 22, 2009 at 1:35 am

    #1095277

  • RE: Query Performance

    Please post 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

    December 21, 2009 at 1:50 pm

    #1095088

  • RE: Setting memory

    If you do use AWE, you need to set SQL's max memory to ensure it doesn't use too much and hurt the OS. Set max to 6.5GB at most.

    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

    December 21, 2009 at 1:47 pm

    #1095084

  • RE: Setting memory

    Mark_Pratt (12/21/2009)

    You will need to ensure that you have the /PAE (and maybe /3GB) switch in your boot.ini file and you have set the Enable the Lock Pages in Memory...

    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

    December 21, 2009 at 1:45 pm

    #1095082

  • RE: Moving table data/index to diff file groups

    gk-411903 (12/21/2009)

    Does this mean that ONLY the index is moved to TSTDB_Idx but the data part is still

    remaining in the PRIMARY file group?.

    No. That's index 1, the clustered index. 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

    December 21, 2009 at 11:56 am

    #1094982

  • RE: How do I delete a transaction log file?

    One comment on the code.

    USE [SAMPLE_DB]

    GO

    DBCC SHRINKFILE (N'SAMPLE_DB_Log2' , EMPTYFILE)

    GO

    use master

    go

    /* This next line works in the sample, fails in my actual database */

    ALTER DATABASE [SAMPLE_DB]

    REMOVE FILE [b]SAMPLE_DB_Log[/b]

    GO

    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

    December 21, 2009 at 11:38 am

    #1094970

  • RE: Cannot shrink log file 2 (LOG FILE) because all logical log files are in use.

    Ivanna Noh (12/21/2009)

    Gail - when i query sys.databases the value in the log_reuse_wait_desc column is 'LOG_BACKUP' - is that a result of mirroring?

    Nope. It means exactly what it says. 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

    December 21, 2009 at 11:30 am

    #1094965

  • RE: Setting memory

    32 bit or 64 bit?

    If you're not sure, run this and post the output

    SELECT @@version

    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

    December 21, 2009 at 10:45 am

    #1094935

  • RE: How to Query Extent Information

    An extent is a contiguous 8 pages. So, given that the first page in the database is page 0, the first extent is made up of pages 0..7. The second...

    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

    December 21, 2009 at 10:34 am

    #1094926

  • RE: Baffling performance issue

    Can you post the revised execution plan (after Grant's improvments)? I'm interested in seeing if there are any opportunities for improving the indexing.

    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

    December 21, 2009 at 10:27 am

    #1094923

  • RE: Creatin Job - No Updates In MSDB

    Why? What are you doing that requires explicit permission in TempDB?

    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

    December 21, 2009 at 9:45 am

    #1094887

  • RE: Help:Query slow

    Please post 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

    December 21, 2009 at 9:41 am

    #1094885

  • RE: How to filter some column names based on column names themselve (not value)

    You're probably not going to like my advice...

    Normalise your table structure. Leave the non-repeating columns in the original table (call it Table1) and move all the repeating columns into a...

    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

    December 21, 2009 at 9:39 am

    #1094879

Viewing 15 posts - 35,146 through 35,160 (of 49,552 total)