Home Forums Older Versions of SQL (v6.5, v6.0, v4.2) Older Versions of SQL (v6.5, v6.0, v4.2) Documentation for SQL Server 6.5 RE: Documentation for SQL Server 6.5

  • March 14, 2012 at 5:20 am

    #1459096

    Ian

    Very kind - but I've managed to resolve the issues for now. It was the tempdb database filling up (pegged at 2*MB*! Not a typo!) I extended logsegment using sp_extendsegment onto a newly-created database device (which is a logical mapping of a .dat file to a database object), made a couple of other configuration changes and the problems are solved.

    I've still got a copy of Que's Computer Glossary (board-bound) on my shelf, explaining such modern concepts as 'parallel ports' and 'World Wide Web'!

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.