Forum Replies Created

Viewing 15 posts - 1,516 through 1,530 (of 3,348 total)

  • RE: TABLESAMPLE output

    Good question, and good explanation. Thanks, Anoo! 😉

    April 3, 2014 at 2:01 pm

    #1703081

  • RE: A Questionable Trigger

    Andy Warren (4/2/2014)

    I appreciate the comments, good and bad, and any ideas you have for making it better without making it easier!

    If the intention of the question is to educate...

    April 2, 2014 at 2:32 pm

    #1702634

  • RE: A Questionable Trigger

    I like the recent series of questions with some backstory. Not the strongest stories, but enough to add a nice touch to the QotD.

    I do not, however, like this question....

    April 2, 2014 at 2:18 pm

    #1702631

  • RE: Default schema

    I have to agree with the others.

    I knew I had to make an assumption about being in the sysadmin role or not. I normally try to avoid assumptions - but...

    March 31, 2014 at 9:24 am

    #1701642

  • RE: Can't See The Forest For the Logins

    My view (yours may vary) is to always use master as the default and always make developers specify the database in their connection strings.

    Yes, my view varies.

    I prefer to set...

    March 31, 2014 at 9:06 am

    #1701631

  • RE: Alas Poor Snapshot, I Knew Him Well

    Eric M Russell (3/31/2014)

    The problem with restoring from a snapshot or transaction log backup is that you may end up "throwing out the baby with the bath water", meaning that...

    March 31, 2014 at 8:35 am

    #1701609

  • RE: What is (Null='Hello') in Sql Server

    jaimepc199 (3/30/2014)

    the reason is just because in our class of algorithm or program I, our teacher said that something if is not true, then is false (obvius), but when we...

    March 30, 2014 at 8:20 pm

    #1701456

  • RE: What is (Null='Hello') in Sql Server

    HeliMan (3/28/2014)

    Why would I (or you, or anyone) actually APPRECIATE, much less graciously accept the programmatic question "Does x = null?" being answered with 'UNKNOWN' (e.g. "I'm sorry, Dave. ...

    March 30, 2014 at 6:07 pm

    #1701452

  • RE: What is (Null='Hello') in Sql Server

    HeliMan (3/27/2014)

    I appreciate the replies. I understand the explanation. What I do not understand is why and/or how it would be useful to have the result of comparing...

    March 30, 2014 at 5:56 pm

    #1701451

  • RE: Indexes

    Carlo Romagnano (3/21/2014)

    Remember that "Filtered indexes" are used only if the WHERE clause matches or is compatible with the filter.

    View http://www.sqlservercentral.com/questions/T-SQL/105826/

    And even then, they are often not used at all.

    I...

    March 30, 2014 at 5:32 pm

    #1701448

  • RE: Indexes

    I'm sorry, but I do not understand where all the praise is coming from. The answers are simply incorrect. And the explanation merely repeats the answers that the author thinks...

    March 30, 2014 at 5:21 pm

    #1701446

  • RE: Alas Poor Snapshot, I Knew Him Well

    I agree with others, excellent question and funny to boot.

    I did not get to eat lunch, but that's because it's 1 am here. But I did not have to leave...

    March 30, 2014 at 5:02 pm

    #1701445

  • RE: In-Memory OLTP - SQL Server 2014

    TomThomson (3/14/2014)

    Hugo Kornelis (3/14/2014)

    That page describes the feature "delayed durability", which is added as a new, optional feature in SQL Server 2014.

    This feature is not specifically tied in to in-memory...

    March 14, 2014 at 2:38 pm

    #1697321

  • RE: In-Memory OLTP - SQL Server 2014

    TomThomson (3/14/2014)

    Hugo Kornelis (3/11/2014)

    TomThomson (3/11/2014)

    It counts as "SCHEMA_AND_DATA" durability but doesn't actually guarantee data durability (it violates the write log first rule of the standard durable transaction model)

    Huh? That's the...

    March 14, 2014 at 2:08 pm

    #1697304

  • RE: In-Memory OLTP - SQL Server 2014

    TomThomson (3/11/2014)

    It counts as "SCHEMA_AND_DATA" durability but doesn't actually guarantee data durability (it violates the write log first rule of the standard durable transaction model)

    Huh? That's the first time I...

    March 11, 2014 at 1:07 pm

    #1696125

Viewing 15 posts - 1,516 through 1,530 (of 3,348 total)