Forum Replies Created

Viewing 15 posts - 31 through 45 (of 88 total)

  • RE: Extended Properties Introduction

    dwain.c (9/27/2013)


    Maddave (9/27/2013)


    dwain.c (9/26/2013)


    I love extended properties. Very comprehensive introductory article!

    The only think I find annoying about them (unless I missed something) is that you can't update them. ...

  • RE: temp table vs permanent table performance

    It depends.

    If the structure is stable and the same at every import I prefer to use a permanent temp table. That is define the permanent table with a schema of...

  • RE: Sales puzzle

    MikeSpike (8/15/2013)


    But why is the result (0, 1) eliminated?

    Does the engine first pick cp.pkey=0 from row 1 and 2 then looks at row 3-4 to check if up.pkey matches 1...

  • RE: A Release from Data

    On a totally different topic I really enjoyed SQL in the City London 2013 and just for thoughts you can really make money with manure as I told Steve (

  • RE: Losing Data

    You have no backup until you have proven that the restore works. 😎

  • RE: Fear Fear

    Fear of change?

    The only constant in life is change. Prepare for it, deal with it, learn from mistakes (if you make any).

    Not applying service patches only gets you along so...

  • RE: The Elusive Conditional WHERE Clause

    Carlo Romagnano (4/18/2013)


    Knut Boehnert (4/18/2013)


    Carlo Romagnano (4/18/2013)


    Old stuff!

    Dynamic sql will run better.

    Sorry, all you are saying is that a red sky is always better than a green sky. But not...

  • RE: The Elusive Conditional WHERE Clause

    Carlo Romagnano (4/18/2013)


    Old stuff!

    Dynamic sql will run better.

    Sorry, all you are saying is that a red sky is always better than a green sky. But not why.

    Everyone knows that a...

  • RE: The Elusive Conditional WHERE Clause

    John Hick-456673 (4/17/2013)


    Comments posted to this topic are about the item <A HREF="/articles/T-SQL/97908/">The Elusive Conditional WHERE Clause</A>

    As long as there is always the same column used then it is fine...

  • RE: The Growth of Storage

    My guess is currently 20 years.

    Unless there is a full breakthrough on optical / biological storage mechanisms that just are started in research.

    That technology has the potential to reset Moore's...

  • RE: A simple T-SQL statement to create a list of lookup values

    Jason-299789 (3/21/2011)


    Cursors in MS T-SQL should be avoided unless absolutely necessary as they are extremely slow and inefficent.

    Using one of the methods mentioned in previous posts is a better and...

  • RE: Fix v. Create

    For the last five years it was more like 95/5 maintenance to new development due me supporting a well established system.

    However this has changed now that we moved to...

  • RE: Defrag All Indexes On a Database

    hakim.ali (5/25/2012)


    Yes, it looks like the website replaces spaces with some other character that is not ASCII 32. You don't even have to go via Notepad, just in SSMS highlight...

  • RE: Use Tools

    Personally I think that automation is good and strive to do get it done automated. Job fails? Put another job in that recovers it and puts it "straight". That and...

  • RE: Data Growth

    Data requirements have increased but apart from storage what cost is there to IT? It is not necessarily IT that provides the front end development for the business. For me...

Viewing 15 posts - 31 through 45 (of 88 total)