Forum Replies Created

Viewing 15 posts - 4,471 through 4,485 (of 9,726 total)

  • RE: Abnormal SQL issue

    You are welcome. We all hope it helps.

    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.

    April 20, 2012 at 4:50 am

    #1476524

  • RE: Are the posted questions getting worse?

    I am starting to do guest posts on my writing blog and I'm wondering if any of you Threadzian authors (who have done editing or writing on SQL Server books)...

    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.

    April 19, 2012 at 6:31 am

    #1475968

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (4/18/2012)

    SQLRNNR (4/18/2012)

    Stefan Krzywicki (4/18/2012)

    jcrawf02 (4/18/2012)

    Stefan Krzywicki (4/18/2012)

    Just complaining for a second

    Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes,...

    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.

    April 19, 2012 at 4:24 am

    #1475920

  • RE: Are the posted questions getting worse?

    How about a slight change of subject. Still "worst questions" but of the humorous sort.

    We've all heard about the admin assistant who switched from typewriters to computers and started whiting...

    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.

    April 18, 2012 at 12:13 pm

    #1475575

  • RE: creating DDL having datetime field

    Does that mean you are good to go, or that you still need help?

    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.

    April 18, 2012 at 11:45 am

    #1475557

  • RE: Are the posted questions getting worse?

    In the spirit of bad questions getting posted, here's mine.

    I have a "Incorrect syntax near ncp". How do I resolve?

    And now I shall hide in the Tent. Guard Hippo, defend...

    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.

    April 18, 2012 at 11:42 am

    #1475553

  • RE: Today's Random Word!

    Tootsie

    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.

    April 18, 2012 at 4:45 am

    #1475248

  • RE: fetching date from 1 sp to another

    hbtkp (4/17/2012)

    Arithmetic overflow error converting expression to data type float.

    Use Google and search for that exact message. You will get lots of articles that will help you troubleshoot the issue.

    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.

    April 17, 2012 at 8:53 am

    #1474784

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/17/2012)

    WayneS (4/16/2012)

    Brandie Tarvin (4/16/2012)

    If any would-be employee claims to be a Threadzian, we have two questions that we can now ask them during the interview.

    1) What does sp_kleenex...

    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.

    April 17, 2012 at 5:18 am

    #1474639

  • RE: Search billions of records from multiple tables

    Sorry, but that's not detailed enough. We need CREATE TABLE statements (that's what DDL is) and INSERT statements with a longer list of sample data. One line per table is...

    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.

    April 17, 2012 at 5:14 am

    #1474637

  • RE: Search billions of records from multiple tables

    If you can give us table / index DDL, sample data (we don't want your real data, feel free to fake it), and a sample query, we can help 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.

    April 17, 2012 at 4:02 am

    #1474604

  • RE: Search billions of records from multiple tables

    My experience says that the best solution is entirely dependent on your database schema. As I don't know what your schema is, and I don't know anything about your data,...

    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.

    April 16, 2012 at 12:29 pm

    #1474277

  • RE: Today's Random Word!

    SQLRNNR (4/16/2012)

    L' Eomot Inversé (4/16/2012)

    Revenant (4/16/2012)

    L' Eomot Inversé (4/16/2012)

    Daniel Bowlin (4/16/2012)

    Pollen

    Bees

    Fleas > sneeze

    tease

    knees

    PT

    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.

    April 16, 2012 at 10:59 am

    #1474206

  • RE: Are the posted questions getting worse?

    WayneS (4/16/2012)

    Brandie Tarvin (4/16/2012)

    If any would-be employee claims to be a Threadzian, we have two questions that we can now ask them during the interview.

    2) How many parameters does DBCC...

    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.

    April 16, 2012 at 10:58 am

    #1474205

  • RE: SSIS Pkg with Web Service Call - Troubleshooting Advice

    Actually, I found a solution. Sort of.

    The queries touch 4 tables. 1 has 2 indexes (1 clustered, 1 non), and the other 3 only had clustered indexes on the PK....

    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.

    April 16, 2012 at 10:35 am

    #1474186

Viewing 15 posts - 4,471 through 4,485 (of 9,726 total)