Forum Replies Created

Viewing 15 posts - 46 through 60 (of 212 total)

  • RE: Schema & Renaming Fun

    Thanks, it was an easy one. 😀

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: Filegroup for indexes

    This one was easy:) Thanks!

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: T-SQL SELECT..INTO

    +1 Easy question, it's very logical.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: Global Configuration Settings

    Strange feature, but I would always use the full name of the option to avoid "the shit to hit the fan".

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: Orphaned users

    Tricky question, only got it right as I had to click 4 options and the only 4 compatible options were the correct ones.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: Automatic Page Repair

    Thanks, easy question as I have seen the automatic page repair live in a production system. It's a really cool feature. The status of the corrupt pages are stored in...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: REPLACE behavior

    Thanks, easy one, it's even documented in BOL. 🙂

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: Auto Create Statistics

    Easy question, but important to remeber. You may need to create multicolumn statistics manually sometimes.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: EXCEPT 2

    crussell-931424 (3/4/2014)


    Yep, a repeat. We should get the EXCEPT question here shortly, I hope.

    Thats true, I didn't notice the heading of the question. 🙂

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: Filtered Index vs Indexed View

    Excellent question, learned something new today. It's absolutely logcial, but I've never thougth about it.

    😀

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: Compression

    Igor Micev (1/30/2014)


    patricklambin (1/30/2014)


    Hello John Mitchell ,

    Thanks for your reply which is confirming what I was thinking especially about LOB and maybe FILESTREAM ( and what about the FileTables ?...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: EXCEPT 2

    Easy Point, thanks! 🙂

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: Serious bug in SQL Server 2012 SP1, due to msiexec process keep running

    avi_ka (12/23/2013)


    Hi,

    I have a serious problem. The registry is so bloated that it won't let me install any hotfix.

    Any ideas what to do?

    Is there any remote registry cleaner authorized by...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: Parameter sniffing

    Nice question, didn't think of the statement LEVEL recompile caused by the force of recompile of all statements that uses the table.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • RE: Syncing/Refreshing data from one environment to another

    Koen Verbeeck (9/11/2013)


    sql_novice_2007 (9/11/2013)


    Can I rollback the changes in case if something goes wrong with the sync?I am not sure if this option is there in sql compare and data...

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

Viewing 15 posts - 46 through 60 (of 212 total)