Forum Replies Created

Viewing 15 posts - 7,141 through 7,155 (of 9,720 total)

  • RE: Why would the same query use 2 different indexes based on date?

    RICHTER-311234 (10/20/2010)

    I have rebuilt the index and ran a updatestats full on the index I am wanting both queries to use, Just a bit at a loss as to what...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 21, 2010 at 4:37 am

    #1240150

  • RE: Delete Records older than 90 days

    Could you please post your table structure and some sample data so we could verify the advice we're giving you before we give it? It's hard to help you when...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 21, 2010 at 4:33 am

    #1240148

  • RE: Can any one please guide,how to split this result,

    There are several ways to split strings in addition to the method Chris mentioned. Google "SQL Server Split Strings," choose one that seems to work, and apply that methodology to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 21, 2010 at 4:32 am

    #1240146

  • RE: Bulk Insert Error: Linked Server "(null)"

    chris.stuart (10/21/2010)

    When you select the table to be populated in the drop down list in the OLE Destination component, you have the "Name of the table or the view:", you...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 21, 2010 at 4:19 am

    #1240141

  • RE: Today's Random Word!

    CirquedeSQLeil (10/20/2010)

    Ray K (10/20/2010)

    Word Code of the day . . .select cup from coffee

    where caffeine = 'high'

    You won't get any that way, try this:

    select coffee

    Into #Mug

    from Pot

    where caffeine = 'high'

    Boys,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2010 at 9:02 am

    #1239748

  • RE: More efficient way

    irobertson (10/20/2010)

    Hi Bill,

    One thing you might like to try is to pre-calculate the two correlated subqueries that you're using to generate criteria and hold the values in variables.

    Also,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2010 at 8:14 am

    #1239712

  • RE: SSIS Mapping documentation

    I'd still like the OP to answer. Assumptions about this sort of thing are dangerous.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2010 at 7:25 am

    #1239673

  • RE: SSIS Mapping documentation

    I'm a little confused. What exactly are you trying to map?

    Are you just trying to show the "guts" of a SSIS package? Or is this something else?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2010 at 7:18 am

    #1239665

  • RE: SSRS Parameter that give users options to insert values manual

    Pitso,

    You should be able to do it just fine using Parameters in SSRS, unless something changed in 2008 that I don't know about. I believe you make the value as...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2010 at 7:15 am

    #1239662

  • RE: Bulk Insert Error: Linked Server "(null)"

    Riiiggght. Quite a DUH moment for me here.

    Bulk Insert Task doesn't work if the table has more or less columns than the file has.

    To make it work, I had to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2010 at 7:10 am

    #1239656

  • RE: Dervied Column conversion from DT_Str to DT_DBTimestamp

    Grateful to both of you for helping out. Thanks!

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2010 at 6:09 am

    #1239615

  • RE: Dervied Column conversion from DT_Str to DT_DBTimestamp

    It was causing all sorts of errors for me, though. Too many to count. I was trying all sorts of variations on the expression.

    LEN() was the magic bullet. I ended...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2010 at 5:48 am

    #1239597

  • RE: Where are you?

    Chris Morris-439714 (10/20/2010)

    Good Lord Tom, I'd always crossed Lanzarote right off my potential places to visit list because of the British tourism. Your account paints it in a completely new...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2010 at 5:20 am

    #1239583

  • RE: Dervied Column conversion from DT_Str to DT_DBTimestamp

    Now see, I've tried the ISNULL(effDt) without the == TRUE and while it didn't "bleed", it did error out on me. But then again, I haven't tried the entire line...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2010 at 5:00 am

    #1239580

  • RE: FTP task when file is not found. A better way to handle....

    Mitch Small (10/19/2010)

    Thanks for your replys. I think what da-zero said makes sense as far as checking to see if the file exists before downloading it.

    Just an FYI: This...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 20, 2010 at 4:52 am

    #1239575

Viewing 15 posts - 7,141 through 7,155 (of 9,720 total)