Forum Replies Created

Viewing 15 posts - 3,961 through 3,975 (of 5,356 total)

  • RE: How old are you?

    quote:

    Yeah, buffer overrun or more probably memory leak!

    you should apply the latest service pack from...

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

    September 9, 2003 at 7:16 am

    #473202

  • RE: How old are you?

    quote:

    Stupdi me, figner troublle agin....

    I assume the typos must have something...

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

    September 9, 2003 at 7:01 am

    #473195

  • RE: How old are you?

    quote:

    Naming names eh! That's not fair. I would have responded anyway but out of the office for 43 weeks (as you know)...

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

    September 9, 2003 at 6:44 am

    #473187

  • RE: Month name using query

    quote:

    select datename(month,1)

    there is a little typo is the above

    the second parameter specifies from which date...

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

    September 9, 2003 at 5:46 am

    #473174

  • RE: Table Order!

    Hi wildh,

    quote:

    As a general rule is there any performance gain in the order I list my tables in the FROM clause?

    example table...

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

    September 9, 2003 at 3:33 am

    #473162

  • RE: What did you do before SQL?

    Well, after all, I'm not full time into SQL business. But that's something else!

    I'm looking to fix this.

    I guess, you call this a bum or lazybone. I spent my time...

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

    September 9, 2003 at 12:45 am

    #473152

  • RE: How old are you?

    quote:

    Children do this to us, don't they?

    Yes, pain can be so close to pleasure!

    Frank

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

    September 9, 2003 at 12:25 am

    #473149

  • RE: Data transfer(UNIX)

    In addition to what Allen said, you might want to take a look at http://www.unixodbc.org or http://www.samba.org (which I would consider not that easy to implement)

    Frank

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

    September 8, 2003 at 7:59 am

    #473023

  • RE: Set to NULL

    quote:

    It's not the first time that I read something about allowing columns to take NULL values not begin recommended.

    To my point of...

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

    September 8, 2003 at 6:33 am

    #473011

  • RE: Set to NULL

    Hi satishbt,

    quote:

    And I do agree with Frank, if this field is part of any of Composite PK or PK itself, or FK,...

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

    September 8, 2003 at 6:03 am

    #473000

  • RE: Error - Database may not be activated

    quote:

    Verified that the ID 7 does NOT exist in sysdatabases.

    I have scripts for the sp and the job and have recreated them...

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

    September 8, 2003 at 5:08 am

    #472993

  • RE: Set to NULL

    quote:

    How can I update an "int" field and set it to NULL? What is the correct sql syntax?

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

    September 8, 2003 at 4:47 am

    #472991

  • RE: Which book to buy for 100$

    So far, thanks to anyone who responded!

    You haven't made my decision easier , but now I know more places where to look for books.

    Frank

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

    September 8, 2003 at 4:03 am

    #472984

  • RE: Error - Database may not be activated

    quote:

    As part of a maintenance routine I've scheduled some DBCC commands to run via a stored procedure. Since dropping a database the...

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

    September 8, 2003 at 3:50 am

    #472983

  • RE: How old are you?

    quote:

    (and since pets are being added to the family list, I've also got a dog (a bordie collie)

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

    September 8, 2003 at 1:56 am

    #472972

    • Viewing 15 posts - 3,961 through 3,975 (of 5,356 total)