Forum Replies Created

Viewing 15 posts - 37,156 through 37,170 (of 49,552 total)

  • RE: stored procedure and if statement

    I'd probably use the built-in date functions, like dateadd. They've been sufficiently tested that there should be no edge cases left.

    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

    August 10, 2009 at 3:05 pm

    #1037088

  • RE: How do you associate .bak broken into parts to an incremental backup?!

    There's no associating of differentials to fulls, except when doing a restore.

    Do you have anything else backing up this database? Any system backup tool that has a sql component. I've...

    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

    August 10, 2009 at 2:54 pm

    #1037080

  • RE: How do you associate .bak broken into parts to an incremental backup?!

    Are you trying to restore a differential backup? If so, you need to restore the full WITH NORECOVERY and then restore the differential.

    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

    August 10, 2009 at 2:43 pm

    #1037077

  • RE: Twenty tips to write a good stored procedure

    timothyawiseman (8/10/2009)

    GilaMonster (8/10/2009)

    timothyawiseman (8/10/2009)

    I am not clear on if temp tables generate better execution plans than table variables. I have not formally tested it, but intuitively I would expect...

    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

    August 10, 2009 at 2:37 pm

    #1037074

  • RE: Twenty tips to write a good stored procedure

    timothyawiseman (8/10/2009)

    Off the cuff, one thought might be to circulate an article through a few volunteers prior to posting. They could send their comments to the author and send...

    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

    August 10, 2009 at 2:35 pm

    #1037073

  • RE: Backup to the Clode - No Excuses

    jay holovacs (8/10/2009)

    In other words... the editing (and responsibility) is somewhere in the cloud...

    More accurately perhaps in the mountains, or off camping or something like that. Translate, Steve's on vacation...

    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

    August 10, 2009 at 2:34 pm

    #1037071

  • RE: Twenty tips to write a good stored procedure

    timothyawiseman (8/10/2009)

    I am not clear on if temp tables generate better execution plans than table variables. I have not formally tested it, but intuitively I would expect the opposite....

    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

    August 10, 2009 at 2:27 pm

    #1037068

  • RE: Are the posted questions getting worse?

    Chad Crawford (8/10/2009)

    I don't think any of you have to worry about too much. English is my first and pretty much only language, but I still don't dare call...

    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

    August 10, 2009 at 2:25 pm

    #1037065

  • RE: Twenty tips to write a good stored procedure

    Ion Freeman (8/10/2009)

    Thanks, Gail. You saved me a lot of time 😉

    Pleasure. What exactly did I save you time in regards to?

    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

    August 10, 2009 at 2:19 pm

    #1037059

  • RE: Twenty tips to write a good stored procedure

    Wanderer (8/10/2009)

    anyways: 1 useful piece of information I got from a Kalen Delaney course. sp_ is NOT Microsoft's "stored procedures". It actually means special, and works for tables as well....

    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

    August 10, 2009 at 2:17 pm

    #1037056

  • RE: Explain plan save as pdf file

    3 main options.

    Save as .sqlplan and ask them to install management Studio Express. Easiest to do, easiest plan to read.

    As I explained in the article I referred you to, use...

    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

    August 10, 2009 at 2:13 pm

    #1037051

  • RE: Explain plan save as pdf file

    Install management studio express on the user's machines (it's a free download from Microsoft), then they can view the exec plan with full details. No other way is as easy...

    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

    August 10, 2009 at 2:04 pm

    #1037044

  • RE: Explain plan save as pdf file

    Probably the only way to pdf will be via screen shot, which loses most of the information in the plan. Have a look at this article for a way to...

    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

    August 10, 2009 at 12:43 pm

    #1036978

  • RE: Twenty tips to write a good stored procedure

    yadavmanoj (8/10/2009)

    What about NO LOCK in the Select?

    Only if you like your data dirty.

    See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.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

    August 10, 2009 at 12:14 pm

    #1036958

  • RE: Explain plan save as pdf file

    Why do you want to save it as pdf?

    Right click on the graphical plan, select save as. Save as a .sqlplan file. It's a form of xml. Anyone with management...

    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

    August 10, 2009 at 12:12 pm

    #1036954

Viewing 15 posts - 37,156 through 37,170 (of 49,552 total)