Forum Replies Created

Viewing 15 posts - 256 through 270 (of 3,232 total)

  • RE: Week Part

    Alright Jeff....you're making my brain hurt.

    I'm humbled by your formula....would you be so kind as to 'splain it to me?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 11, 2010 at 9:44 am

    #1249572

  • RE: Week Part

    Now that's genius. I knew there would be a way to do this without a function, but time constratints kept me from persuing one.

    Thanks Jeff!

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 11, 2010 at 8:50 am

    #1249543

  • RE: Shrinking Log files on regular basis -SQL Server 2005

    That is a valid scenario where you'd consider shrinking the file. You want your log file to be sized appropriately to be able to handle your normal daily processing...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 11, 2010 at 8:07 am

    #1249518

  • RE: Week Part

    This would be very easy if you had a dates table in your database. Another option would be to use a UDF to find the last day of the...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 8, 2010 at 11:02 am

    #1247783

  • RE: SSIS - If Condition is Met, Send Email

    You mean include the Row Count inside the email message....yes. You'll need to use the expression builder to build out the message body property (MessageSource, I think) and include...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 8, 2010 at 10:33 am

    #1247765

  • RE: Today's Random Word!

    Future

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 8, 2010 at 10:28 am

    #1247760

  • RE: Today's Random Word!

    Verbose

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 4, 2010 at 9:41 am

    #1246643

  • RE: SSIS - If Condition is Met, Send Email

    Phil Parkin (11/3/2010)

    -- Sorry John - I noticed that I almost quoted you verbatim when I looked back at what I'd written 🙂

    That would be a good compliment to me...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 3, 2010 at 3:46 pm

    #1246313

  • RE: How to approach deleting duplicate data

    This should work, but I'd recommend adding a Primary Key constraint on your table and correcting whatever INSERT process is creating the dupes.

    DELETEst

    FROMstudent_test st

    INNER JOIN(

    SELECTstudent_test_id

    FROMstudent_test

    GROUP BYstudent_test_id

    HAVINGCOUNT(*) > 1

    ) t2 ON...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 3, 2010 at 1:39 pm

    #1246259

  • RE: SSIS - If Condition is Met, Send Email

    You can't send the mail from the data flow. Just populate the variable and then use an expression in the precedence constraint to evaluate the variable and envoke the...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 3, 2010 at 1:27 pm

    #1246255

  • RE: Today's Random Word!

    Red

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 3, 2010 at 10:27 am

    #1246152

  • RE: How to tell when a 'RESTORE VERIFYONLY' statement is executed

    You should be able to capture the events via SQL Profiler.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 3, 2010 at 10:26 am

    #1246151

  • RE: Advantage of Stored Procedure?

    In addition to Craig's....

    It makes database changes and tuning so much easier. From a DBA's perspective, you need to maintain the ability to make DB schema changes for performance,...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 2, 2010 at 3:58 pm

    #1245797

  • RE: Reporting Strategy - Looking for suggestions/comments

    Well, they say the 2 best ways to learn are mistakes and mentors. Here at SSC, you'll find both. I will have to say though that it is...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 2, 2010 at 3:49 pm

    #1245794

  • RE: How to tell when a 'RESTORE VERIFYONLY' statement is executed

    I don't think you'll find that anywhere. Why don't you just put some data logic into the SP around the VERIFY command?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 2, 2010 at 3:35 pm

    #1245785

Viewing 15 posts - 256 through 270 (of 3,232 total)