Forum Replies Created

Viewing 15 posts - 4,351 through 4,365 (of 9,726 total)

  • RE: Are the posted questions getting worse?

    So, the house next door went up for short sale. I've seen this house at its worst (when it needed a serious overhaul) and it's looking pretty good right now....

    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.

  • RE: Are the posted questions getting worse?

    GilaMonster (6/6/2012)


    Revenant (6/5/2012)


    Nope - they know you are a safe-to-deal-with customer and they hope that you will get into minus on your checking account, and they will charge you something...

    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.

  • RE: Creating XML from SQL Server 2005 - What are my options?

    Please start a new thread, Suresh. It's considered impolite to hijack a thread with questions that have little to do with the original subject. Especially older threads like this one.

    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.

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (6/4/2012)


    mtillman-921105 (6/1/2012)


    So I suppose a lot of people rent in Europe?

    70% of Italians own the house they live in.

    Well, sort of.

    Who owns the house while you're paying the...

    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.

  • RE: SSIS - Multiple File Export with unknown #

    My data source is a stored procedure which does a SELECT at the end, then sends records in two different directions. One to the file and one to a staging...

    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.

  • RE: Answers to these questions

    SKYBVI (6/4/2012)


    If you memorise answers, you will be lost as soon as the interviewer digs into details. If you've played around and have practical experience you won't be.

    Thats true I...

    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.

  • RE: Answers to these questions

    SKYBVI (6/4/2012)


    Some questions whcih were asked by interviewers :-

    1) Why clustered index are only 1 and non clustered indexes are many?

    Also, if for a table we...

    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.

  • RE: Developing SSIS Packages for Remote SQL Server

    jcrawf02 (6/1/2012)


    Koen Verbeeck (6/1/2012)


    SSIS is a littly crybaby when it comes to changing metadata.

    Ha! So true...

    I hate the XML Source. Any changes to the XSD file, and you have...

    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.

  • RE: Developing SSIS Packages for Remote SQL Server

    My recommendation. Make sure your SQL schema (as Koen said) is the same in the development environment. Get local copies of all dbs for development. Do some unit testing 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.

  • RE: Are the posted questions getting worse?

    Happy release day to meeeeeeee.

    Legend of the Beemen & the June issue of Penumbra eMag (of which I was guest editor-in-chief) are now available for purchase: http://www.musapublishing.com/%5B/url%5D

    Buy it... Buy it......

    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.

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (6/1/2012)


    Cath Trimble (6/1/2012)


    By the way, the houses near the tech center sure are expensive - about $250,000 and up I think?

    Wow, that's cheap by UK standards....

    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.

  • RE: Powershell Proponents - A Question for You

    Is SSIS integrated with Powershell?

    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.

  • RE: SSIS Expression - Looking for the Typo

    DOH!

    Nevermind. I found the issue. I got my subtraction in the end length wrong.

    Code is now:

    (DT_STR,10,1252)SUBSTRING(AllOtherData,382,FINDSTRING(AllOtherData,"~",3) - 382)

    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.

  • RE: Foreach vs set for Database mail stored proc. Is it possible to send many messages with 1 statement?

    There is no guarantee this would be faster, but try a WHILE loop (using your records as a decrementing counter) and see if that has any better performance than a...

    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.

  • RE: HTML Report using T-SQL

    Sean Lange (5/31/2012)


    The first suggestion I would make is to leave formatting to the front end. Put this in SSRS and let the formatting go crazy. I would certainly not...

    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.

Viewing 15 posts - 4,351 through 4,365 (of 9,726 total)