Forum Replies Created

Viewing 15 posts - 3,931 through 3,945 (of 5,356 total)

  • RE: A Brief History of SQL

    quote:

    Well get to work already, what else have you got to do that is more important

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    September 11, 2003 at 1:49 am

    #473623

  • RE: Performing aggregate calculations on null values

    Stupid, stupid Frank

    Forget my last post.

    AVG already does this for you!

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    September 11, 2003 at 1:42 am

    #473621

  • RE: Do you allow developer to access Production Server

    quote:

    NEVER. Simple as that.

    Agreed with that!

    Would certainly be a great issue at the...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    September 11, 2003 at 1:22 am

    #473617

  • RE: Execution Plans

    quote:

    Ok. Thanks for your help anyway. What I don't understand is why SQL Server should decide to use different execution...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    September 11, 2003 at 12:38 am

    #473614

  • RE: Performing aggregate calculations on null values

    quote:

    The AVG function will ignore NULL values in its calculation and provide a warning that NULL value is eliminated. You could test...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    September 11, 2003 at 12:36 am

    #473612

  • RE: Table Order!

    Hi Matthew ,

    ok, unfortunately the following is not my own!

    Taken from Inside SQL Server 7 (sorry, the one I got at home) Part IV Chapter 14

    'Optimizing Queries'

    ...

    For the most common...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    September 11, 2003 at 12:25 am

    #473609

  • RE: A Brief History of SQL

    Hi cppwiz, hi phillcart,

    are you mind-readers?

    Btw, I think I have read something of a company called Sybase, but I can't really remember right now

    Anyway, something...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    September 11, 2003 at 12:06 am

    #473607

  • RE: Table Order!

    I think I read somewhere in InsideSQL Server a passage where is states, as a rule of thumb you should not Join more than 4 tables. Otherwise you lose performance.

    Will...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    September 10, 2003 at 9:11 am

    #473452

  • RE: Easy way to truncate multiple tables in SS 2000

    Well, after a little bit longer.

    Hm, when the table(s) you want to do this for hardly never change, why not use Allen suggestion, create a stored procedure, and customize in...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    September 10, 2003 at 8:53 am

    #473445

    • Viewing 15 posts - 3,931 through 3,945 (of 5,356 total)