Is there a chance that the database is growing in size automatically? I've seen some processes appear to "hang" while the DB grows in size. Just a stab in...

One option is to use Microsoft Network Load balancing on the front-end to route requests to multiple machines. If one goes down, then requests will be routed to the...

If you MUST use the current method, why not move the ASP call from a trigger to a stored proc. You could insert the row in the stored proc, then...

I think what Yoeri is getting at is the ability from within the procedure, to print out the names and values of each parameter as it was passed to the...

Just another comment about sp_spaceused...Even after an "update statistics" the rowcount can still be reported incorrectly in sp_spaceused. You must run a "DBCC UPDATEUSAGE ... WITH COUNT_ROWS" command to...

Could I get some clarification on why the "Modified" date of the MDF file is not a valid indicator of the last time the database was expanded or shrunk?

Doing the...

This is my understanding of how to use the /3GB and /PAE switches in the boot.ini:

If you have less than/equal to 4GB of RAM and you want SQL to use...

What about looking at the Modified Date on the MFD file?

-Dan

Here is one method using sp_OACreate/DMO. You can set the timeout value to whatever you think fits your network speed, etc. I've ommitted the error handing for simplicity.

-Dan
 

I would have to agree with Antares' last comment, that writing a master/slave style proc with all possible combinations will give you the best performance. This can add up...

Just a few comments...I just recently switched from Sybase to SQL Server and here are a few of the differences that I've noticed. Some of these may be supported...

I just tried on a color printer, and was unable to get the colors to print.

-Dan

In QA you can turn them off in Text-Results mode only from the menu: Tools->Options->Results->Print Column Headers.

If you use the isql command-line utility you can specify the "-h-1" parameter. ...

Also, you could use a scheduled DTS package to accomplish this.

-Dan

You could create a stored proc in SQL Server that uses a linked server to your Oracle server to pull the data across. This proc could be scheduled to run...