what if the indices were on seperate storage devices from the main data, and the queries could be answered solely by the index itself (i.e. covering indexes), and in a...

and just as important....train the callers to understand that at 3am, that on-call person is NOT as alert as they are. A good operational practice would be to issue...

...the stored procedure school being considered dinosaurs apparently

please shoot these uneducated hunters, or your organisation will encounter the ice-age.

I can't say as I'm not on 2005. But some testing/Profiling would clear that up.

set rowcount 2000

would be far more effective than TOP 2000 in limiting returned data....as TOP implies sorting, which would be an extra processing step.

@30K per hour, 1m will take 33hours...

oh sh*t. dynamic sql. I hope your securtity model is robust.

freeproccache...you lose the benefit of cache everytime this is run.

no tables qualified by dbo. you're inviting a system-overhead...

I'd have 3 issues with the one database strategy....

if one database is out of service, all clients are off the air. not good news for your customer support people,...

Get the phone number of the Managing Director (or the Network Admin) person, and when you need to stop/start services at 2am, just direct the support call to that number....

And always don't be afraid to ask for help....or for a peer review of sample/problem code, once you've made a decent effort first at solving the problem yourself.

key topics.....

backups

security

code performance

accuracy/reliability...

Might be worth having a look at the solution used over at SQLTeam.com

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=22270

question is a bit vague. do you want to run a script from a sysbase server against a windows server or against some data on the original sybase server,...

And in my case my userbase are meant to be somewhat educated, in that they are all internal to my organisation and they should be very familiar with payment requirements...

From 10years of e-commerce experience I'd have a failure rate of approx 1-in-7 with people filling in forms wrongly, but with better input form design you can vastly improve this.

You...

You need to look for things like scans...both table and index scans. These are in the main bad news. Hopefully you are also not using CURSORS!!

Best would be...

Excellent....there is hope at end of the journey!

Enjoy the change.:)