Forum Replies Created

Viewing 15 posts - 121 through 135 (of 848 total)

  • RE: Service Principal Names

    Thanks for the question Tom. I've never had to use Kerberos but it is always good to know how to implement different configurations.

  • RE: BCP results

    Koen Verbeeck (7/29/2014)


    Nice question. I didn't know about the different behaviour between versions.

    +1 Good to know.

  • RE: Sub Query

    Hugo Kornelis (7/28/2014)


    LOL!!

    I simply cannot believe the amount of discussion over what can of course only be a simple mistake by the question author.

    The very definition of "correlated" is that...

  • RE: SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)

    Nice simple article. I may have to try this out sometime.

  • RE: Recovery Interval

    I had no idea about this option. Good to know in case we ever need it. Thanks for the question!

  • RE: The first thing to do with a damaged off-line database

    Nice question and very timely for me. We have had a lot of DR discussions lately. 🙂

  • RE: What is the true value?

    I had no clue. Thanks for the introduction to PowerShell! 🙂

  • RE: Connection Colors

    sestell1 (6/24/2014)


    You can save your custom colors with specific connections if you use 'registered' servers in SSMS.

    I like to set all my production server connections to red, to cut down...

  • RE: Fun with OVER

    Nice question. I use the Over() function a lot so I always enjoy these.

  • RE: Byte Me: Insubordinate Clause

    SQLRNNR (6/26/2014)


    Jeff Moden (6/26/2014)


    KWymore (6/25/2014)


    Reminds me of the Oracle error I got the other day -

    SQL Error: ORA-14451: unsupported feature with temporary table

    14451. 00000 - "unsupported feature with...

  • RE: The Great Escape

    Fun question. Thanks Andy! Not sure that I will ever need to use Escape but good to know that it is an option.

  • RE: Byte Me: Insubordinate Clause

    Reminds me of the Oracle error I got the other day -

    SQL Error: ORA-14451: unsupported feature with temporary table

    14451. 00000 - "unsupported feature with temporary table"

    *Cause: ...

  • RE: Effective Max

    Nice question Steve! Had to do some research to get this one. The formula totally makes sense and is easy enough to actually memorize. 🙂

  • RE: CTE DML

    I still don't use CTEs often but that script to delete duplicates has me reconsidering their importance! Very cool. Nice question. Thanks Barry.

  • RE: The Last Line of Defense

    A very timely editorial for me as I just got back from a week of cross-training meetings.

    I used to have that mentality that being a silo of knowledge was...

Viewing 15 posts - 121 through 135 (of 848 total)