I like msSQLed available free or for $15 to get rid of an annoying pop-up at http://www.mssqled.com/DesktopDefault.aspx.  YOu can also get a free web-based data admin tool from Microsoft...

I did notice that using table variables was slower than using temp tables when there was  relatively large amount of data being insertd into the table variable.  I found that...

I have to agree with Kevin.  Particularly because if xp_sendmail fails your whole transaction will be rolled back.  Put changes in an audit table.  Then you also have the ability...

I'm not sure what changes SP4 made, but just because auto create and auto update stats are on does not mean you have the correct stats as SQL Server just...

I would guess that when SP4 was applied you would need to update the statistics.   Have you checked the query plan?

You definitely wnat a FULL recovery model.  This allows you to do FULL, DIFFERENTIAL, and LOG backups.  For heavily updated databses I do a weekly full backup, Differential backups about...

I don't a need for you to have a separate table for AIlment and Appointment as you already have those 2 keys in the Appointment table.  That would be storing...

Size of the log file definitely affects performance.  The log file should be around 20% of the database size.  A 1GB databse should not have a 14GB transaction log.  Have you...

I think you need to use a command objec tin order to execute a stored procedure in ADODB. Try adding this:

Dim cmd

Set cmd = CreateObject("adodb.command")

cmd.ActiveConnection = cn

    cmd.CommandType = adCmdText

   ...

I downloaded Toad for Sql Server and was not impressed with the interface, but it does have a lot of features.  I also tried msSqled which is excellent.  You can...

If you are using SQL2K I would use an instead of trigger on table A  IT would look something like this:

CREATE TRIGGER

InsteadTrigger on

You cannot use like with an integer value is one problem I see.  You are comparing BLOCK Like @BlkId which is int so that is not going to work.  Then...

based on my experience you are out of luck in SQL 7.  In SQL2K you would probably want to use Inline Functions which return a table based on the select...

MY guess is that the connection string defined for the shared data source is wrapped in double quotes (") when passed to the web service so having the double quote in...

I used Visual Interdev 6 and now use Visual Studio .NET 2003.  I like the environment.