Forum Replies Created

Viewing 15 posts - 6,901 through 6,915 (of 9,720 total)

  • RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

    Mike McIver (12/7/2010)

    SELECTPATINDEX('%[^0-9]%','<whatever value>')

    Only zero indicates the value is an integer.

    Not true. Integers can be negative numbers.

    Dictionary.com

    in·te·ger /'?nt?d??r/ Show Spelled

    [in-ti-jer] Show IPA

    –noun

    1. Mathematics...

    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.

    December 7, 2010 at 6:04 am

    #1259484

  • RE: Job Scheduling

    Stefan Krzywicki (12/6/2010)

    I have a job that is now approaching 20 steps. If I were to place each functionally grouped set of steps in its own job, I would 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.

    December 7, 2010 at 4:51 am

    #1259462

  • RE: Are the posted questions getting worse?

    Craig Farrell (12/6/2010)

    Well, this amused me... I recieved this PM. Allow me to share my reply with you: ...

    It amazes me how people fall for that sort of stuff,...

    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.

    December 6, 2010 at 12:11 pm

    #1259165

  • RE: dropping a column doesnt create space at all..?

    Glad we could 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.

    December 6, 2010 at 9:06 am

    #1259082

  • RE: Today's Random Word!

    Flimflam

    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.

    December 6, 2010 at 6:31 am

    #1258976

  • RE: Are the posted questions getting worse?

    Has anyone tried to host a blog via Comcast.net?

    I tried to set up Blosxom through them and was unable to make it work due to Comcast's policies on website...

    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.

    December 6, 2010 at 6:31 am

    #1258974

  • RE: why i can't shrink tempdb data file

    The only thing I can think of is that the files had open transactions in tempdb. Just because the files are read only doesn't mean they don't use tempdb 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.

    December 6, 2010 at 5:13 am

    #1258956

  • RE: Zipping a Text file

    varshakarnik 92752 (12/5/2010)

    I've create batch file:

    @Echo off

    "\\keenm\c$\WinZip\WZZIP.exe" "\\Dell\Tessitura\Source\sso_pacingdata.zip" "\\Dell\Tessitura\Source\sso_pacingdata.txt"

    ---------------

    Now i run

    master..xp_cmdshell 'Text_Zip_Cmd.Bat'

    If you are running this batch file on the server, from the server, you need to get rid of...

    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.

    December 6, 2010 at 5:10 am

    #1258955

  • RE: Loading the Data from different excel files to different excel sheets in one excel file

    prasanna-750812 (12/5/2010)

    The number of sources will not be constant for each run.............so i think we can't use multiple sources or multiple data flow tasks.............

    Sounds like a case of needing 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.

    December 6, 2010 at 5:04 am

    #1258953

  • RE: Flat File not outputting Row Delimiters

    Craig Farrell (12/3/2010)

    For those playing along at home, Ragged Right needs a specific setup, you need to have one extra column in the advanced section for the CR/LF. Basically,...

    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.

    December 6, 2010 at 5:01 am

    #1258951

  • RE: dropping a column doesnt create space at all..?

    PaulB-TheOneAndOnly (12/3/2010)

    Brandie Tarvin (12/3/2010)

    Repopulating a table isn't necessarily that easy. Especially if it has foreign keys, indexes, constraints, etc. If it's a heap, then not so bad. But you're 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.

    December 6, 2010 at 4:56 am

    #1258949

  • RE: SQL Server 2005 Maintainaince Plan excution fails

    guruprasadurs (11/15/2010)

    hi brandie..

    Last time i resolved a issue with the help of u....

    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.

    December 3, 2010 at 11:45 am

    #1258582

  • RE: Are the posted questions getting worse?

    Roy Ernest (12/3/2010)

    Brandie Tarvin (12/3/2010)

    On an interesting side note, I did not know until today that SQL Server considered text, ntext, image, sql_variant, and XML data types as "variable-length."

    Oh, 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.

    December 3, 2010 at 8:50 am

    #1258457

  • RE: dropping a column doesnt create space at all..?

    Paul,

    Repopulating a table isn't necessarily that easy. Especially if it has foreign keys, indexes, constraints, etc. If it's a heap, then not so bad. But you're also forgetting the question...

    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.

    December 3, 2010 at 8:48 am

    #1258454

  • RE: Are the posted questions getting worse?

    Alvin Ramard (12/3/2010)

    I have a confession to make.

    While setting up WordPress yesterday, I had to create a MySQL database.

    I hope y'all will forgive me.

    Blasphemy! Blasphemy! Ban him from 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.

    December 3, 2010 at 8:45 am

    #1258452

Viewing 15 posts - 6,901 through 6,915 (of 9,720 total)