Forum Replies Created

Viewing 15 posts - 61 through 75 (of 95 total)

  • RE: RAISERROR failed due to invalid parameter substitution(s)

    Somewhere in your code you are using the RAISERROR command and you are not supplying the correct parameters to the error string. 

    RAISERROR ('The level for job_id:%d should be between...

  • RE: Database indexes

    It depends...

    Index defrag and rebuild will have the same result.  Which one is faster depends on how fragmented the index is.

    Reindex rebuilds the entire index from scratch, which can be...

  • RE: T-SQL, View or Stored Procedure

    Just remember that if you are testing two queries to see which one is faster, a good idea is to flush the server's data cache after the first query.  There is...

  • RE: how to check size of database

    That will be the total size of your database, including any empty space.  It is possible for the transaction log or data file to have a lot of empty space...

  • RE: Get Update script

    Create a share on the mdb server for the folder the mdb is in.

    Grant 'Everyone' read access on the folder, or preferably give the login that SQL is using use access...

  • RE: proper SQL Permission required in application programming

    Application role is something different to a SQL Roles.  You can use one of the following in your VB program:

    - Create a single SQL Login and your VB program can...

  • RE: Database indexes

    Useful scripts above!!!

    DBCC INDEXDEFRAG does not lock the indexes, but it does take a lot of CPU and potentially a lot of IO (depending on the side of your indexes)

    DBCC...

  • RE: Database indexes

    I'm am not an expert in this, but I would expect that deleting a lot of data from your tables could cause excessive internal fragmentation, which is when space is available within...

  • RE: Get Update script

    To do this, you need to JOIN Table1 and Table2 like this:

    UPDATE a

    SET a.Status = b.Status

    FROM Table2 a

    JOIN Table1 b

    ON a.[ID] = B.[ID]

    I don't know of a way of joining tables...

  • RE: Search 800.000 records... performance

    3 seconds?  That is slow!  We have several tables over 1 million records, and if we offered 3 seconds to our users, they'd show us the door.  I have just...

  • RE: Return a parameter with Exec

    The problem is that with EXEC or sp_executesql any variables you use in your select are created, used and destroyed in the scope of the EXEC.  Thus, when the EXEC...

  • RE: SQL Admin proviledges vs system admin in the domain

    To use Terminal Services the DBA needs to be a local administrator on the server.  He does not need domain admin rights.

  • RE: Monitoring New Entries on an SQL Server Table

    You could use a trigger on the table.  The trigger will fire whenever an action takes place on the table.  If you really want to, you could see if the...

  • RE: xp_terminate_process not found

    If you need to add a new extended sproc to your server, run sp_addextendedproc in the master database.

    Examples

    This example adds the xp_hello extended stored procedure.

    USE masterEXEC sp_addextendedproc xp_hello, 'xp_hello.dll'
  • RE: sp_procedure_params_rowset

    This is a shot in the dark, but have you checked for locks?  When the report is hanging, execute sp_who2 in query analyser.  See if your process is blocked by...

Viewing 15 posts - 61 through 75 (of 95 total)