If there is no index on svc_cat, it's most likely going to a scan, same as #1. Best way to check is to start up QA, toggle Show Execution Plan...

I read that, too, in shagols response and assume it's on the server as well. I was referring to the posts talking about issues with EM generating the access violation....

The only way MS support Lotus for SQL Server is as an SMTP server and I know that blows. I know very few people who use SQL Server with Lotus...

I think the address is sqlwish@microsoft.com for suggestions for improvement. This sounds like a good one. It's one of the features I love about TextPad.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish...

Just a point of clarification since we're talking about both servers and clients. An access violation occurs when a particular application attempts to access a memory location in a way...

If it's not SQL 2K, no bulkadmin role.

If you are SQL 2K, I agree with GAL0303. Only give the permissions sufficient to do the job and no more. Also, make...

The first will result in a clustered index scan (whole table).

The second will depend on if you have a non-clustered index on SVC_CAT. If you don't, you'll go to...

One of the rules of thumb we follow where I work is if there are minor issues, we want a DBA looking at it, we don't SQL Server trying to...

You don't want to put on a WAITFOR or anything of that sort. The issue is the locking and blocking. Find out what's causing them and work to resolve them...

jmadren is right.

INSTEAD OF triggers are brand new to SQL Server 2000. Since SQL Server didn't have Cascading referential integrity and it didn't have triggers which fired before a data...

We've used the tool successfully in disaster recovery. Our file system backups capture everything but the db files (because they are open and in use). We use rebuildm to create...

The SQL Server client tools will. The MDAC components should as well. If you have any concerns about compatibility, you can go here:

http://www.microsoft.com/data/

Windows 2000 shipped with MDAC 2.5. SQL Server...

It is scary, and I'm not exactly sure what Microsoft was thinking since an all caps version of the password is in that hash, which reduces the number of possible...

Run a check for locks periodically and either export it to a output file (the example from the articles I cited uses isql and outputs to a text file... it...

There are several operations which could cause a temporary expansion in the database size. One that comes immediately to mind is the creation of clustered indexes. For it to have...