Forum Replies Created

Viewing 15 posts - 211 through 225 (of 938 total)

  • RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

    neufeldb4 (4/13/2009)

    Allow me to make some observations.

    ...If you are going to use an example, and you wish to have credibility, make your example a good one...

    To anyone who frequents SSC...

    April 16, 2009 at 11:26 am

    #979077

  • RE: T-Sql rant

    Jeff Moden (4/6/2009)

    Mike C (4/5/2009)

    Oracle is good about implementing new features and functionality really quickly... sometimes they even get their features out to market before the ISO standards updates...

    April 6, 2009 at 9:22 am

    #972626

  • RE: T-Sql rant

    steve dassin (4/6/2009)

    Sergiy (4/6/2009)

    steve dassin (4/5/2009)

    getting sql folks to get their head out of what is essentially a 'constant' (an sql table) and into something that is variable.

    Such a...

    April 6, 2009 at 9:09 am

    #972606

  • RE: T-Sql rant

    steve dassin (4/5/2009)

    CREATE TABLE T (A INT,B VARCHAR(25))

    SELECT A,B FROM T

    CREATE VIEW T1 SELECT A,B FROM T

    SELECT A,B INTO T1

    FROM T1

    CREATE PROCEDURE T3

    SELECT A,B FROM T

    CREATE FUNCTION T4(A...

    April 6, 2009 at 12:37 am

    #972303

  • RE: T-Sql rant

    Bruce W Cassidy (4/5/2009)

    Mike C (4/5/2009)

    Oracle is good about implementing new features and functionality really quickly... sometimes they even get their features out to market before the ISO standards...

    April 6, 2009 at 12:30 am

    #972300

  • RE: T-Sql rant

    Bruce W Cassidy (4/5/2009)

    Mike C (4/5/2009)

    Forget the Oracle version of this site -- I can think of dozens of people who could use this type of mythbusting information that visit...

    April 5, 2009 at 10:38 pm

    #972274

  • RE: T-Sql rant

    steve dassin (4/5/2009)

    My apologies. I certainly didn't mean to imply curlies were the only way to specify tables and table expressions. Here are some simple examples of Curly and parenthesis...

    April 5, 2009 at 10:08 pm

    #972271

  • RE: T-Sql rant

    Bruce W Cassidy (4/5/2009)

    [font="Verdana"]To be frank, in my experience the issues with cursor-based code in Oracle have been concealed by the huge overkill of hardware assigned to Oracle databases. ...

    April 5, 2009 at 10:06 pm

    #972269

  • RE: T-Sql rant

    I've heard it from people at various other software companies as well. It seems to be a very common misconception out there. Like I said, I haven't done...

    April 5, 2009 at 9:30 pm

    #972260

  • RE: T-Sql rant

    Bruce W Cassidy (4/5/2009)

    [font="Verdana"]It puzzles me as well, and I've commented earlier on that. "row-by-row" is just as agonising in Oracle as it is in SQL Server.

    About the only...

    April 5, 2009 at 9:02 pm

    #972255

  • RE: T-Sql rant

    steve dassin (4/4/2009)

    Mike C (4/4/2009)

    Jeff Moden (4/4/2009)

    steve dassin (4/4/2009)

    C'mon do you really have something against parentheses?

    Actually, yeah. 😉

    Personally I hate those curly braces. Growl.

    C'mon you got something against the three...

    April 5, 2009 at 11:47 am

    #972198

  • RE: T-Sql rant

    Jeff Moden (4/4/2009)

    steve dassin (4/4/2009)

    C'mon do you really have something against parentheses?

    Actually, yeah. 😉

    Personally I hate those curly braces. Growl.

    April 4, 2009 at 9:37 pm

    #972127

  • RE: T-Sql rant

    foxjazz (4/3/2009)

    Jeff Moden (4/3/2009)

    foxjazz (4/3/2009)

    But who am I to say anything about the limitations of t-sql?

    When it comes to data manipulation, I've not found any limitations yet.

    Jeff, ummm what do...

    April 3, 2009 at 7:53 pm

    #971935

  • RE: T-Sql rant

    Merry Krissmess (4/3/2009)

    OMG, who uses cursors with T-SQL? SQL Server is rowbased already.

    You might be surprised how many people manually override the SQL Server optimizer through judicious use of cursors....

    April 3, 2009 at 7:44 pm

    #971934

  • RE: T-Sql rant

    foxjazz (3/13/2009)

    Why couldn't they write t-sql more like C# or have a flavored compiler for t-sql so that we could work it like c# or vb depending on how you...

    April 3, 2009 at 1:05 pm

    #971801

Viewing 15 posts - 211 through 225 (of 938 total)