Forum Replies Created

Viewing 15 posts - 32,161 through 32,175 (of 49,552 total)

  • RE: Performance issue got to be done in few hrs need HELP PLZ

    Dave Ballantyne (6/28/2010)

    Update the statistics and issue sp_recompile "STOREROOM", to force the plan out of the cache.

    No need for the recompile, the stats update will invalidate the plan.

    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

    June 28, 2010 at 9:10 am

    #1185844

  • RE: Performance issue got to be done in few hrs need HELP PLZ

    sam-1083699 (6/28/2010)

    Here are execution plans for procedure and view on both servers.

    Which is fast, which is slow?

    Is the procedure slow or are adhod queries of the view slow?

    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

    June 28, 2010 at 9:09 am

    #1185840

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (6/28/2010)

    Gail, I found the perfect present for your birthday!!!

    I always need more coffee coasters, the more colourful the better

    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

    June 28, 2010 at 8:57 am

    #1185819

  • RE: Are the posted questions getting worse?

    Anyone willing to drop everything for an urgent performance issue? http://www.sqlservercentral.com/Forums/Topic943983-360-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

    June 28, 2010 at 8:55 am

    #1185818

  • RE: Performance issue got to be done in few hrs need HELP PLZ

    Post both execution plans.

    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

    June 28, 2010 at 8:54 am

    #1185814

  • RE: Performance issue got to be done in few hrs need HELP PLZ

    Have you tried a statistics update?

    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

    June 28, 2010 at 8:52 am

    #1185813

  • RE: Restore Transaction Log after Database has been Restored

    That'll work, but I strongly suggest that you consider transactional replication.

    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

    June 28, 2010 at 8:05 am

    #1185756

  • RE: check for NULL in a column

    Why do you need a case statement?

    create table #t

    (i int)

    insert into #t(i) values (null)

    insert into #t(i) values (1)

    SELECT Count(*)

    FROM #t

    WHERE i IS NULL

    As for the case statement you have, you're...

    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

    June 28, 2010 at 8:04 am

    #1185753

  • RE: DeadLock while adding a record in table if i have one non-clustered index for 100 users concurrent load at a time

    Please post the deadlock graph

    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

    June 28, 2010 at 7:55 am

    #1185748

  • RE: Restore Transaction Log after Database has been Restored

    rew-370421 (6/28/2010)

    "up to date" meaning that when the Primary Server does a Transaction Log backup every 15 minutes, then that LOG Backup should then be applied to the Report Server...

    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

    June 28, 2010 at 7:55 am

    #1185745

  • RE: SQL 2005

    No, it's from some different event that your trace is picking up. Check what events you have the trace listening for.

    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

    June 28, 2010 at 7:37 am

    #1185736

  • RE: Need Expert advice on my sql query for speed improvement

    A clustered index does not ensure that the data is stored physically in the order of the index. Only if there's 0 fragmentation of index and file does the logical...

    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

    June 28, 2010 at 7:31 am

    #1185728

  • RE: using the "While" statement with "Begin Transaction and Commit Transaction"

    If you are using SQL 2008 and (I believe) .Net 3, you can use the table valued parameter.

    http://www.codeproject.com/KB/cs/CSharpAndTableValueParams.aspx

    http://msdn.microsoft.com/en-us/library/bb675163.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

    June 28, 2010 at 7:02 am

    #1185696

  • RE: Creating a Check Constraint

    Please post new questions in a new thread. Thanks.

    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

    June 27, 2010 at 11:36 pm

    #1185512

  • RE: Automate DMV capture report

    Is reporting services available?

    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

    June 27, 2010 at 11:36 pm

    #1185511

Viewing 15 posts - 32,161 through 32,175 (of 49,552 total)