Forum Replies Created

Viewing 15 posts - 4,741 through 4,755 (of 5,356 total)

  • RE: tempdb log ig growing

    quote:

    2a5xo3z1:

    Not yet... Will get the first issue in august or september. I could not find this article online. Will...

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

    July 8, 2003 at 6:20 am

    #464461

  • RE: Image Insert

    Hi Dale,

    quote:

    My experience is that BLOB will inflate the database excessively if the requirements are heavy. Therefore, I prefer using linking...

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

    July 8, 2003 at 6:16 am

    #464459

  • RE: Object Documentation

    Hi Len,

    quote:

    Any other documentation for maintenance purposes, business rules, etc. ?

    sorry, is your post aimed...

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

    July 8, 2003 at 5:22 am

    #464447

  • RE: Image Insert

    Hi Dale,

    quote:

    You really shouldn't store images and other binary files in the SQL Server tables 'cause it REALLY slows things down.

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

    July 8, 2003 at 5:15 am

    #464445

  • RE: tempdb log ig growing

    Hi,

    case you are a subscriber to SQL Server Mag, there is an article on tempdb in the July edition. Maybe it is also available online?

    Cheers,

    Frank

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

    July 8, 2003 at 4:58 am

    #464444

  • RE: ASP?

    Hi James,

    quote:

    I will add I have tried NetObject Fusion, Dreamweaver, Front Page, Visual Interdev, WebSmith, and a host of others I forget...

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

    July 8, 2003 at 4:54 am

    #464443

  • RE: ADO Code

    Hi Alan,

    quote:

    Haven't seen that code before - thought it was merely a matter of creating a connection object and then opening it....

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

    July 7, 2003 at 7:36 am

    #464299

  • RE: ADO Code

    quote:

    ...unfortunately not the browser merely hangs for a few seconds and then returns a blank page.

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

    July 7, 2003 at 7:20 am

    #464292

  • RE: ADO Code

    Hi Alan,

    quote:

    Unfortunately, it didn't work for me which makes me think that it might be due to the security settings on the...

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

    July 7, 2003 at 7:04 am

    #464286

  • RE: ADO Code

    quote:

    All I was trying to point out is that in the case of the use of 'Server.', if the server has to...

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

    July 7, 2003 at 6:49 am

    #464283

  • RE: ADO Code

    Hi David,

    quote:

    Yes, laziness on my part. If you leave off 'Server.' it is assumed (bad practice ).

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

    July 7, 2003 at 6:32 am

    #464278

  • RE: Find second highest

    Hi Suresh,

    quote:

    It did worked great. Now, I need to know Nth highest salary from the given values. Here, we may have to...

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

    July 7, 2003 at 6:30 am

    #464277

  • RE: ADO Code

    Hi David,

    quote:

    set conn = CreateObject("ADODB.Connection")

    set Com = CreateObject("ADODB.command")

    set Rs = CreateObject("ADODB.recordset")

    I always...

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

    July 7, 2003 at 6:22 am

    #464272

  • RE: SELECT New_Life

    Thanks David and thanks to all who replied yet!

    quote:

    DROP Dirty_Nappy

    GO

    SELECT Clean_Nappy FROM Nappy_Pile WHERE COUNT(Clean_Nappy) > 0

    INSERT...

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

    July 7, 2003 at 6:18 am

    #464270

  • RE: SELECT New_Life

    Hi Noel,

    quote:

    Seems odd to me that you still have some spare time, looking at the number of posts you have

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

    July 7, 2003 at 4:34 am

    #464255

    • Viewing 15 posts - 4,741 through 4,755 (of 5,356 total)