Viewing 15 posts - 61 through 75 (of 95 total)
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...
July 7, 2004 at 8:04 am
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...
July 7, 2004 at 5:47 am
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...
July 7, 2004 at 5:42 am
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...
July 7, 2004 at 4:14 am
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...
July 7, 2004 at 4:09 am
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...
July 7, 2004 at 3:58 am
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...
July 7, 2004 at 3:30 am
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...
July 6, 2004 at 9:22 am
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...
July 6, 2004 at 5:03 am
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...
July 6, 2004 at 4:54 am
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...
July 6, 2004 at 4:08 am
To use Terminal Services the DBA needs to be a local administrator on the server. He does not need domain admin rights.
July 6, 2004 at 3:47 am
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...
July 5, 2004 at 7:34 am
If you need to add a new extended sproc to your server, run sp_addextendedproc in the master database.
This example adds the xp_hello extended stored procedure.
USE masterEXEC sp_addextendedproc xp_hello, 'xp_hello.dll'
July 5, 2004 at 7:27 am
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...
July 5, 2004 at 7:19 am
Viewing 15 posts - 61 through 75 (of 95 total)