Forum Replies Created

Viewing 15 posts - 6,736 through 6,750 (of 9,720 total)

  • RE: Indexes

    The Missing Index feature of SQL Server is just recommendations by the server and is not necessarily something to follow. Sometimes, based on bad statistics and other stuff, it can...

    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: Indexes

    subha.mcts2005 (1/19/2011)


    I am asking why indexes are missing?

    As the others have indicated, you need to give us more information. How did you find out indexes were missing? What process, error...

    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: Today's Random Word!

    Daniel Bowlin (1/19/2011)


    CirquedeSQLeil (1/18/2011)


    Rumor

    The administrators of Area 51 have decided that since everyone knows about them that they are going to hold an open house on April 1st in an...

    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: DB backup to network drive

    Ditto to Lynn's comment.

    I've found that if there's network connectivity disruption during a file move, that the connection on my side doesn't necessarily know that it's been broken. So 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: Indexes

    I'm not sure I understand the question. Did you actually create the indexes? If so, are you sure they actually created and didn't just error out?

    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: Query on using BIDS and connecting to Analysis Services database

    I don't see them in SSMS either. I think this is probably the way it's supposed to be.

    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: Could not load file or assembly 'file:///C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.ScriptTask\10.0.0.0__89845dcd8080cc91\Interop.ADODB.dll' or one of its dependencies. The system cannot find the file specified.

    Does the .dll need to be registered?

    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 Package to export data to a spreadsheet

    What you want to do can be as easy (or as hard) as you want it to be. Look up SSIS tutorials on Google or Microsoft's websites. Books Online 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.

  • RE: Date table not in cube

    I should add that this Date table is based off a Named Query pre-exists in the DSV, so it's not one I'm creating from scratch.

    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: Automate Restore 1

    And I could do one on auto restores to another instance / server. If you wanted something that comes after the basic.

    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: .mdf / .bak / .ldf

    I've actually seen people use the data file extension for backup and vice versa. Then they complain when they can't restore because they grab the wrong one.

    <headdesk>

    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?

    jcrawf02 (1/18/2011)


    Not sure I'm following the paradox of the free range chicken. Are you saying it's a paradox because they no longer roam the great plains in vast flocks, covering...

    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: How to prevent a sore throat after hours of presenting ppt ?

    jcrawf02 (1/18/2011)


    Steve Jones - SSC Editor (1/18/2011)


    Did nobody mention some bourbon or brandy to smooth things out?

    For the speaker or the audience?

    Ba-DUM-da (Cymbal crash)

    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: SSAS Cube missing attribute keys

    Steve,

    I just tried what you instructed with the Unknown. I actually had the Unknown Member already set to Visible, but I missed changing the Error process part of it originally....

    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: SSAS Cube missing attribute keys

    Okay, I don't think these scenarios will work, but maybe I'm just confused. Let me try to re-phrase what I was trying to say earlier and see if I'm missing...

    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 - 6,736 through 6,750 (of 9,720 total)