Forum Replies Created

Viewing 15 posts - 4,126 through 4,140 (of 9,722 total)

  • RE: NonClustered index vs Unique NonClustered Index

    EDIT: You misread Gail's first sentence. Go back and re-read. She refers to both Clustered and Non-Clustered Unique indexing properties.

    As Gail said, the images are useless for us. You need...

    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: run SSIS package in 2008 designed in 2005

    BTW, it is not entirely painless. If you have any OLE DB Destinations in a Data Flow Task, you will get a number of SSIS warnings about the FastLoadMaxInsertCommitSize. 2005...

    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: NonClustered index on Clustered table

    SQL Server has pointers that tell it which indexes refer to which records. Your James names with different IDs won't get lost. However, if you don't have your indexes written...

    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: Using SSIS Execute Process Task to save command prompt output

    The answer is configuration files.

    I wouldn't use an XML file unless you can put it on a drive where no one else can access it. This seems to call for...

    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: Uploading file option in Report Manager

    Chaithanya M,

    Again, Books Online should have the answer for this 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.

  • RE: Report Builder in Report Manager vs Report Model Project Template

    Chaithanya M,

    I see you have a number of basic SSRS questions that can be answered if you look at SQL Server's native help file "Books Online." As I referenced in...

    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: Difference between Standard and Data Driven Subscription

    Do you have access to Books Online? This question is easily answered by looking in there.

    Also, Microsoft has a Books Online are that you can find the answer in. Google...

    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 execel sheet

    asranantha (7/27/2012)


    HI friends, i have smal doubt in ssis plz tell me the answers

    i have soure table that is sql server table that table name is sample and its...

    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: Create dynamic feeds using SSIS

    Is this a one-off or will this be a reoccurring thing?

    If reoccuring, will the 20+ records always have the same dynamic format?

    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?

    Back to the semi-technical discussion...

    If joining a VARCHAR(8000) to a VARCHAR(MAX) value degrades performance, how does one get around this?

    I'm not speaking in the context of the splitter function. I'm...

    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?

    WayneS (7/26/2012)


    You'll might find this interesting: http://www.sqlperformance.com/2012/07/t-sql-queries/split-strings

    Very interesting indeed. Poor Jeff. Poor Tally Tables.

    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?

    WayneS (7/26/2012)


    GilaMonster (7/26/2012)


    And the vague question of the week award goes to: http://www.sqlservercentral.com/Forums/Topic1336028-391-1.aspx

    Too tempting... had to post there.

    Wayne, you are so mean.

    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?

    OMG. This is so appropriate for us:

    http://dilbert.com/strips/comic/2012-07-26/%5B/url%5D

    Tell true, Threadzians. How many of you fell into this trap?

    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?

    dwain.c (7/25/2012)


    Jeff Moden (7/25/2012)


    Please join me in reporting this and all other posts of this nature by this person. This has got to stop. If anyone of us...

    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: Job failed:The owner does not have server access.

    Welsh Corgi (7/25/2012)


    I just got the same error.

    I had created jobs perform backups and I'm the owner.

    I'm backing up to the local machine.

    I'm sysadmin and all of I sudden...

    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,126 through 4,140 (of 9,722 total)