Forum Replies Created

Viewing 15 posts - 661 through 675 (of 7,164 total)

  • RE: CU 6 OR SP1 For Sql server 2014

    For new server builds I like to go with the latest and greatest where possible. SP1 was released on 5/14, so only about a month ago, but unless you have...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: The Case for Specifying Data Types and Query Performance

    I love this article mainly because I can pass it on to one of senior .NET developers and do not have to write up anything myself to demo for him...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Column level data encryption in SQL Server 2014

    SSRS Newbie (6/17/2015)


    Do I need to create a new column in the table for encrypted data? I mean is it possible to encrypt the existing column instead of creating a...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Maintenance commands affect on log file / log file maintenance without log file backups

    HookSqlDba7 (6/18/2015)


    I am testing some maintenance tasks sql commands such as index rebuild, index reorg, update statistics and db integrity check on a SQL Server 2014 Database. This is a...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Copying system databases from SQL Server 2005 to 2014

    Considerations on TRUSTWORTHY

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Side-effects of switching TRUSTWORTHY on a db

    Considerations on TRUSTWORTHY

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: instal bids for 2014

    You will need to go to either VS 2012 or VS 2013. VS 2010 does not host SSDT for SQL 2014.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Demystifying the use of CASE in an ORDER BY statement

    After reading the article and the comments I was left wondering if the author and many of the commenters had a clear understanding of the difference between a statement, an...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Storing a Binary File in a Database

    Jeff Moden (5/28/2015)


    Solomon Rutzky (5/28/2015)


    But SQLCLR is far better than the alternatives of xp_cmdshell, the OLE Automation Procedures, extended stored procedures, and sometimes even OPENROWSET / OPENQUERY

    Extremely personal and grossly...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Storing a Binary File in a Database

    Jeff Moden (5/27/2015)


    Orlando Colamatteo (5/26/2015)


    Jeff Moden (5/26/2015)


    For those cases where you're not going to violate the 2GB limit, you don't even need FileStream to load binaries.

    True, but with in-table storage...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Stored Procedures Local vs. Cloud

    A SQLCLR object that makes a connection to the Cloud database is an option as well. Given the "different domains" comment I suspect any connection between the two instances will...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Programmatic creation or modification of SSIS

    SSIS is metadata-driven and as you have found an out of the box setup needs to be modified each time the set of source or destination columns that need to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Storing a Binary File in a Database

    Jeff Moden (5/26/2015)


    For those cases where you're not going to violate the 2GB limit, you don't even need FileStream to load binaries.

    True, but with in-table storage the cost per GB...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Storing a Binary File in a Database

    mwpowellhtx (5/26/2015)


    Orlando Colamatteo (5/26/2015)


    Thanks for taking the time to write the article. Given the alternatives I strongly prefer employing a SQLCLR for implementing file system access from T-SQL. However, in...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Storing a Binary File in a Database

    fregatepllada (5/26/2015)


    FileTable does not support transactions,

    Sure it does...

    while Filestream does, plus in Filestream you have a choice to hide files from Windows 🙂

    You can hide the files in Windows...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 15 posts - 661 through 675 (of 7,164 total)