Forum Replies Created

Viewing 15 posts - 256 through 270 (of 378 total)

  • RE: Linking to the Previous Row

    Chris Morris-439714 (2/8/2010)


    peter-757102 (1/23/2009)


    I understand your point of view as well as the theory you put forward as to why it might be different in case of my proof. Therefore...

  • RE: The Price of SQL Server

    And what to think if you just want to use the database and the agent and can do without analysis server, Reporting Server and Integration server. There are plenty of...

  • RE: The Price of SQL Server

    I think there should be a tier between standard and enterprise editions. Often you do need some advanced programming features without the need to set up a giant high load...

  • RE: Optimising “Ends With” searches with REVERSE

    Note that indexes can only have a limited width (300 bytes or so , I believe).

    Because of this, it makes sense to do a reverse of only the last N...

  • RE: Is It Worth Upgrading to SQL Server 2008

    SQLMadness (12/18/2009)


    We are currently upgrading from SQL Server 2005 to 2008. One major factor in our decision to upgrade was Filtered Indexes.

    Yup, this is the feature I earely want...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    Joe Celko (11/13/2009)


    I have been on the road speaking at PASS and SQL Connections for two weeks. One of the topics in both places was getting a lot of...

  • RE: Is C# Better?

    Scott Roberts-430649 (11/13/2009)


    peter-757102 (11/13/2009)


    There will be a distinction in software that needs more power and has to go multi-threaded or at least be aware of it and thus require subsequently...

  • RE: Is C# Better?

    Threads like these always get out of hand (look at my previous post), but I like them anyway as it is a nice occasion to voice ones views. For me...

  • RE: Is C# Better?

    Just My 2c (this is a sincere rant, so be ready)

    I have a C/C++ (among many prior languages) background and still see C++ that as the language to beat when...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    Paul, lets not use words such as "cheat" here.

    The sole purpose of the deliberate fragmentation is to make a point about the order in which the updates take place regardless...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    One word Jeff....CLASS

    Thank you for the very clear article and all the testing done to make sure that what you claim is 100% correct. But I wouldn't be me if...

  • RE: A Bad Litmus Test

    Quoting on the site did not seem to work properly for a particular post (quoting the wrong one, then fails on submit)

    So here is my reply on Phil Factor, the...

  • RE: The Dynamic Tally or Numbers Table

    It were alien devices I tell you...all we got now is reverse engineered 😉

  • RE: The Dynamic Tally or Numbers Table

    Jeff Moden (10/2/2009)


    It didn't come out that way, but I was actually agreeing with you. Depending on what the company and resident DBA allow, an inline Tally function would...

  • RE: The Dynamic Tally or Numbers Table

    RBarryYoung (10/2/2009)


    peter-757102 (10/2/2009)


    Jeff Moden (10/2/2009)


    That's why I shifted to All_Columns for future code. Rumor has it that syscolumns is going away and Master.sys.All_Columns always has at least 4k rows...

Viewing 15 posts - 256 through 270 (of 378 total)