Forum Replies Created

Viewing 15 posts - 391 through 405 (of 673 total)

  • RE: Logged Operations

    Stefan Krzywicki (4/7/2011)


    Please forgive my misstatement and allow me to rephrase

    As you're questioning the statements in the QOTD and others have posted links to articles supporting the conclusion you should...

  • RE: Logged Operations

    Stefan Krzywicki (4/7/2011)


    Clarification in this kind of a discussion happens with evidence, others have posted links to articles. As you're questioning the statements in the article, you should come...

  • RE: Logged Operations

    Hugo Kornelis (4/7/2011)


    I don't have the time to really dive into this at the moment, and I'm also sitting at a computer that is running SQL Server 2005 only so...

  • RE: Logged Operations

    GSquared (4/7/2011)


    Diagram it out on a piece of paper. Just a simple flow-chart. You'll quickly see...

    Wish Flow charts where better here.

    Temp Tables are logged --> MARS support...

  • RE: Logged Operations

    CirquedeSQLeil (4/7/2011)


    I'll put it out there that I missed it because I went with the none option (meaning all are logged based on question phrasing). I knew table variables...

  • RE: Logged Operations

    WayneS (4/7/2011)


    I did post a link to a blog by the Microsoft SQL Server Storage Engine team in which they state that the version store is not logged. And as...

  • RE: Logged Operations

    I want to make sure everyone understands how important it is to know that

    Version store operations, and version store data are completely differant things.

    The version store supports all MARS and...

  • RE: Logged Operations

    Ignacio A. Salom Rangel (4/7/2011)


    SanDroid check this link http://technet.microsoft.com/en-us/magazine/gg552991.aspx

    Ignacio,

    Nice link. It helps prove my point.

    "The only truly non-logged operations in SQL Server are those affecting the version store in...

  • RE: Logged Operations

    Wayne,

    From what I can find to read about the version store, only logged and transactional operation Data is ever in it.

    So I wonder why you think that data affecting the...

  • RE: Logged Operations

    This post was edited by the original Author becuase it's original content is no longer valid.

    :Whistling:

  • RE: Dating for DBAs

    paul.knibbs (4/6/2011)


    Pity you can't split the results by nationality--I wonder how many British or European DBAs would get this one wrong? 🙂

    I would bet it is a greater percentage than...

  • RE: Dating for DBAs

    UMG Developer (4/5/2011)


    CirquedeSQLeil (4/5/2011)


    UMG Developer (4/5/2011)


    How many people actually use the ODBC date literals?

    I think very few in comparison.

    Yeah, I think the number of people answering correctly shows that. (Currently...

  • RE: Contained database users

    Nice question.

    I had heard about this feature request for SQL Server Logins and DB Users being seperated back when 2005 was a Beta.

    I wonder if there is...

  • RE: Relational Theory

    ronmoses (4/1/2011)


    I may not have learned anything directly from the question; but on the plus side, in researching the question I did learn all about sexy prime triplets.

    >>>No, I'm not...

  • RE: Open Source SQL Server

    Koen Verbeeck (4/1/2011)


    No download link? 😛

    That's the beauty of noSQL.

    You don't have to download or install anything to use the features and services it provides.

    :smooth:

Viewing 15 posts - 391 through 405 (of 673 total)