Forum Replies Created

Viewing 15 posts - 5,401 through 5,415 (of 9,726 total)

  • RE: Are the posted questions getting worse?

    Help me bug Microsoft about a minor issue that is driving me sane.

    https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

    This one is giving me heartburn. I almost ran something in Production that was supposed to be run...

    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: SSMS Trama (yes, this is really bugging me)

    This is still bugging me, so I opened up a bug issue on MS Connect. If anyone is interested in voting for it, here it is:

    https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

    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: The backup of the file or filegroup "CCT_MSCRM" is not permitted because it is not online

    chris.caines (8/6/2011)


    Interesting fact and partially related to your second suggestion, if I detach, copy and reattach the database to a different SQL server, I can back it up fine. So,...

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

    Stats can be manually created on non-indexed columns, so far as I know, which is what the Create Statistics statement is for. The key info to know is that stats...

    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: Export Import Wizard

    chandan_jha18 (8/1/2011)


    We are not adding any table to an existing one. Tables are different and the import will be creating new tables from scratch.

    My bad. I thought you were merging...

    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: Export Import Wizard

    chandan_jha18 (8/1/2011)


    Is this the correct way and matches the answers in your mind while you replied here:-)

    Yes. That is the correct way.

    Something to be aware of, though. If two 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: The backup of the file or filegroup "CCT_MSCRM" is not permitted because it is not online

    You have two options at this point. Call Microsoft (recommended) or create a work around.

    The work around method is dirty and you will probably forget something (hence the reason 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: SQL timeouts and disconnects?

    Have them put a sniffer on the network regarding those specific machines.

    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: Export Import Wizard

    chandan_jha18 (7/29/2011)


    chandan_jha18 (7/29/2011)


    Brandie Tarvin (7/29/2011)


    The best way to do it is script the tables, indexes, etc. over to your destination server. Then use the Export Import Wizard to append 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: XML help

    Thanks for posting the solution. It's always good to know what works and what doesn't.

    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!

    bopeavy (7/29/2011)


    Revenant (7/29/2011)


    Ray K (7/29/2011)

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

    Daniel Bowlin (7/29/2011)

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

    Clouds

    Computing

    Power

    Out of Space

    Lost in Space

    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 (7/31/2011)


    Anyone willing to read over an article on recovery models and make sure I haven't made any grievous errors?

    Send it my direction, Gail. I'll take a look at 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: new to BI/DWH

    antonio.safwat (7/29/2011)


    So i thought that studying for SQL Server BI certificate and BI concepts (OLAP & DDB & ETL) will help to get the required knowledge for an entry level...

    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: Export Import Wizard

    chandan_jha18 (7/29/2011)


    Brandie Tarvin (7/29/2011)


    The best way to do it is script the tables, indexes, etc. over to your destination server. Then use the Export Import Wizard to append the data...

    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 join two tables using wildcards.

    What is your data source? MySQL? SQL Server? DB2? Oracle?

    What is your data destination? MySQL? SQL Server? DB2? Oracle?

    EDIT: Are you querying MS Access? What is "nia"? A linked server...

    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 - 5,401 through 5,415 (of 9,726 total)