Forum Replies Created

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

  • 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

  • RE: Are the posted questions getting worse?

    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 do and when would 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 16, 2012 at 10:32 am

    #1474181

  • RE: Are the posted questions getting worse?

    He was applying for the Ninja Dev job. I take it he passed? @=)

    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 7:05 am

    #1474001

  • RE: CAREER ADVICE: Applying for DBA Jobs?

    Gabe T. (4/13/2012)

    4) With recruiters, be patient with them, and understand their standpoint. Typically they can hardly spell SSIS, let alone tell you what the difference between a foreach container...

    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 4:56 am

    #1473932

  • RE: Are the posted questions getting worse?

    capn.hector (4/13/2012)

    ok on topic: http://www.sqlservercentral.com/Forums/Topic1283271-392-1.aspx how do you long time posters keep going when you run into people like this. (one thread there are more out there)...

    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 4:36 am

    #1473927

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