Forum Replies Created

Viewing 15 posts - 42,961 through 42,975 (of 49,552 total)

  • RE: Why separate data, log and backups on SAN?

    Sure. Tonnes

    Try these for starters:

    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

    http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx

    http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx

    http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx

    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 26, 2008 at 7:45 am

    #903733

  • RE: Can we change 1st table read in an exection plan

    shekihan (11/24/2008)

    However my experiments with Query Analyzer (SQL Server 2005) confirm that regardless of whatever order you use in JOIN there is no difference in query plans! From here out...

    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 26, 2008 at 7:28 am

    #903714

  • RE: Memory Paged out every 30-40 mins with Memory Utilization around 50% (and 13GB available RAM)

    Jerry Hung (11/25/2008)

    Thanks Gail

    I think Total Working Sets dropped when it happened (_Total and sqlservr)

    it was 7000000+, and now 1.3e+010 (sql: 1.2818e+010)

    That's not a decrease. 1.3e+010 is scientific notation...

    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 26, 2008 at 7:26 am

    #903711

  • RE: Stop using the SA login

    Windows groups are best. Get the developers added to a windows group, grant that group a login to SQL. Create roles for permissions and add those roles to the group.

    Make...

    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 25, 2008 at 12:23 pm

    #903366

  • RE: Script for index defrag on badly fragmented tables

    How big were the tables in question?

    Small tables don't show changes in fragmentation, and there's no need to worry about fragmentation on small tables. (~100 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 25, 2008 at 12:16 pm

    #903361

  • RE: Pass Summit - Lessons Learned

    Nov 3-6 2009, Seattle.

    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 25, 2008 at 12:10 pm

    #903358

  • RE: problem with function

    Stick a print or select inside the IF block, see if that prints out, or if the update is coming from somewhere else.

    You can also trace the exact steps 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 25, 2008 at 12:05 pm

    #903352

  • RE: Memory Paged out every 30-40 mins with Memory Utilization around 50% (and 13GB available RAM)

    Check the Total Working Sets counter in perfmon. See if the total working set of all processes decreases or if it remains steady when this happens.

    What else is running on...

    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 25, 2008 at 11:55 am

    #903343

  • RE: problem with function

    It prints results on each execution? Means that the exists is correct, there are always rows.

    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 25, 2008 at 11:51 am

    #903342

  • RE: Pass Summit - Lessons Learned

    Couple more recommendations

    Chat with other people between sessions. Everyone has something that they can teach you, and you can make friends that you can chat with long after the conference

    Chat...

    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 25, 2008 at 11:48 am

    #903340

  • RE: Query Performance Issue

    The first problem is that you have two table scans. Second problem is that you're getting a hash join because you have no indexes.

    Add indexes to support the join and/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

    November 25, 2008 at 11:43 am

    #903339

  • RE: problem with function

    Try putting a check just before the exists, run the proc from management studio and see what you get back.

    SELECT @foundFolderId

    SELECT * FROM pageList WHERE folderID = @foundFolderId AND...

    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 25, 2008 at 11:29 am

    #903336

  • RE: High Disk I/O performance

    Multiple separate RAID arrays is best. The log and data files should be physically isolated from one another.

    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 25, 2008 at 11:17 am

    #903327

  • RE: Lost MDF file but I have LDF file

    supatpong (11/25/2008)

    Thank you for many support. Now I trying to find software tool.

    Don't bother. All the log reader tools need the database to be online. Besides, all that you'll...

    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 25, 2008 at 11:06 am

    #903317

  • RE: problem with function

    Exists doesn't return false results.

    Are you sure that the variables are such that rows may not exist? Maybe put a statement just above that to insert the rows 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 25, 2008 at 10:53 am

    #903313

Viewing 15 posts - 42,961 through 42,975 (of 49,552 total)