Forum Replies Created

Viewing 15 posts - 1,741 through 1,755 (of 1,999 total)

  • RE: SQL 2005 Performance - Do your apps run faster than in SQL 2000?

    more than likely your performance boost will come if you are running into locking issues where the new snapshot isolation issue may be of assistance.

    also large tables and indexes can...

  • RE: From Access 2003 to SQL Server 2005

    if you're looking for reasons not to use access then i can think of about a million.

    aside from the obvious

    security

    performance

    support requriements (have you seend how many times mdb files...

  • RE: Question of the Day for 21 Dec 2005

    i think we've all got this wrong,

    it's not the query thats missing, but an answer from the list of answers

    the question should read

    Assume that the column and table names...

  • RE: Question of the Day for 21 Dec 2005

    I think it's designed to test ESP and psychic ability!!!!!

  • RE: arrays in store procedures?

    the only way i can see to do this is to load the array into a temp table, cursor or table variable and then loop through table/cursor

  • RE: dbnetlib NETWORK ERROR

    i ahve seen this error and it seems to be specific to windows 2003

    mdac 2.8 - installed by default on windows 2003

    the following 2 articles may be of...

  • RE: Tuning a Database

    I can strongly recommend Ideras SQL diagnostic manager

    at £450 per server it's a bargain. this should then give you a report on the slowest running Queries and procedures...

  • RE: optimizing sql server for concurrent querries

    Microsoft don't state that there is a an upgrade path to std/enterprise edition from personal, however from past experience i can confirm that you can upgrde.

    this should minimise your downtime....

  • RE: SQL JDBC Connectivity Help

    has anyone come up witha fix for this yet ?

    I'm getting a similar error - although this is only happening when not using connection pooling.

    It appears that connections are not...

  • RE: Idera SQL diag Problem

    the response from idera was so slow that i posted it here first, but it appears that contra to their installation requirements and pre-requisits you must have SQL server...

  • RE: URGENT:Indexes removed

    funnily enough thats my script!!!!

    i know you're all jumping to conclusions here...... but i post a lot of scripts!!! and this one has been no-where near that particular customer...

    the issue...

  • RE: URGENT:Indexes removed

    fortunatley as part of all upgrade work we do for that customer we always script out the database design in case we need to make changes

    so i've got a...

  • RE: Question of the Day for 15 Jul 2005

    remi - easy on the happy pills!

  • RE: Question of the Day for 15 Jul 2005

    ERIC - that looks suspiciously like a TI/99-4a on your picture

  • RE: Question of the Day for 15 Jul 2005

    the reason c generates that error si that the final prameter of the last sp_dboption dies not use ' - they may look like ', but it's not.

    you'll see it...

Viewing 15 posts - 1,741 through 1,755 (of 1,999 total)