Forum Replies Created

Viewing 15 posts - 40,531 through 40,545 (of 49,552 total)

  • RE: Simple Recovery Mode, Yet Logfile Very Large?

    rmechaber (3/5/2009)

    If a database regularly creates, say, 50 Mb a day in transactions, but once a year I create 500 Mb of transactions, then every day I'll be backing up...

    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

    March 5, 2009 at 12:05 pm

    #954278

  • RE: Distinct going slower than *

    Derek Dongray (3/5/2009)

    Also I'd be interested to see the source of the User-defined function FFG_FX_JUST_DATE since, although it doesn't add the the estimated cost

    Scalar functions never do. It's one of...

    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

    March 5, 2009 at 11:47 am

    #954259

  • RE: Simple Recovery Mode, Yet Logfile Very Large?

    rmechaber (3/5/2009)

    Would you recommend as a best practice that I include a Shrinkfile for the log in my daily Agent backup job?

    Absolutely not. Worst thing you could do (short of...

    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

    March 5, 2009 at 11:45 am

    #954257

  • RE: Simple Recovery Mode, Yet Logfile Very Large?

    Transactional replication?

    Done any index rebuilds recently?

    rmechaber (3/5/2009)

    I thought that Simple recovery mode wiped the transaction log on a full backup

    No. In Simple the log is truncated whenever a checkpoint occurs....

    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

    March 5, 2009 at 10:32 am

    #954196

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (3/5/2009)

    I suggested he post the thread in the MVP groups and see who was acting unprofessional.

    Ooohhhh... I sooooo wanna see the results if he does!

    😀

    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

    March 5, 2009 at 10:26 am

    #954189

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/5/2009)

    I took offense to the post he made in reply to your post, and sort of

    went off a bit on him for his comments. I then...

    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

    March 5, 2009 at 10:11 am

    #954176

  • RE: Triggers

    sam.marsden (3/5/2009)

    thats great guys thank you for your help i think i'll be able to cope - there's just one last thing that baffling me - how will i transfer...

    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

    March 5, 2009 at 10:08 am

    #954171

  • RE: Are the posted questions getting worse?

    Chris Morris (3/5/2009)

    Hey Grant, your chum's back in town. I'm in the bleachers with a couple of beers.

    I'll join you. Got any coffee?

    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

    March 5, 2009 at 10:07 am

    #954169

  • RE: Reducing execution time of sproc

    sql-oholic (3/5/2009)

    I was hoping to get some tips & tricks .. best practices when using temp tables in sproc

    Without seeing code the best I can offer is very general advice.

    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

    March 5, 2009 at 10:07 am

    #954168

  • RE: reducing execution time of Stored Procedure

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic669345-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

    March 5, 2009 at 10:05 am

    #954165

  • RE: Triggers

    This assumes you have created a table called MailQueue that has, at minimum columns ToAddress, MailSubject and MessageBody.

    This is to give you an idea, it will obviously need modifying

    CREATE TRIGGER...

    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

    March 5, 2009 at 9:37 am

    #954138

  • RE: Up Your Value

    Steve Jones - Editor (3/5/2009)

    If a manager doesn't appreciate what you've done, re-examine it and be sure that you have gone above and beyond. Talk to someone else you trust...

    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

    March 5, 2009 at 9:22 am

    #954125

  • RE: Triggers

    sam.marsden (3/5/2009)

    The configuration option 'Database Mail XPs' does not exist, or it may be an advanced option.

    You need to enable advanced options first

    exec sys.sp_configure 'show advanced options', 1

    reconfigure

    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

    March 5, 2009 at 9:06 am

    #954106

  • RE: Profiler states insert has long duration

    That shouldn't cause a problem for inserts. Large range-scan reads yes, but not singleton inserts.

    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

    March 5, 2009 at 8:08 am

    #954064

  • RE: Urgent : Sql server db tuning

    jparker2 (3/5/2009)

    If you want to prove this with a test, ask them to append the output of each loop to a local text file instead of creating a DB record....

    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

    March 5, 2009 at 8:07 am

    #954063

Viewing 15 posts - 40,531 through 40,545 (of 49,552 total)