Forum Replies Created

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

  • 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

  • RE: Are the posted questions getting worse?

    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 makes sense when 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.

    December 3, 2010 at 8:33 am

    #1258443

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

    sqldba_icon (12/3/2010)

    Brandie the column i have deleted is a ntext data type.

    Would DBCC Cleantable still help? If not how do i clear space , please advice.

    Do you have 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 3, 2010 at 8:29 am

    #1258440

  • RE: SSMS & Database snapshot

    Patrick2525 (12/3/2010)

    Within SSMS, click on Replication -> Publications, right click -> New Publication, and follow the wizard for either a Merge or Snapshot replication, and a snapshot will be created!...

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

    #1258429

  • RE: Are the posted questions getting worse?

    Articles like this always interest me. .

    http://education.yahoo.net/articles/quick_career_changes.htm?kid=1BOPU

    Forget about the paralegal reference. Look at the others. How many of you have ever been in a situation where salaries like this would...

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

    #1258396

  • RE: replicating records w/o using a cursor

    Chris Morris-439714 (12/3/2010)

    What folks often forget about tally tables is that they are a source of rows as well as numbers.

    I've actually used a Tally Table to do that too,...

    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 6:43 am

    #1258369

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