Could you run SQL profiler against your server to see if any SQL command is being executed? If so then you can move on to seeing why it is...

We develop an app (Medical Records / Theatre Costing) that needs to know a LOT of information that's created by the hospital's billing system. We maintain our own database...

I doubt it will ever happen. SQL Server has MANY platform specific features that rely upon things that can be done in Windows and not in other environments. ...

How big is your log file?

Jeff Moden had a wonderful bit of magic with XML formatting commands which don't end up doing XML, etc to make CSV lists in SQL.

This ought to do what you...

And in both environments remember that if you're using SQL authentication for access to the database you may need to use the trusty

sp_change_users_login 'auto_fix', [theLogin]

where [theLogin] is the login/user name...

I have to agree with fuller.artful and Nathan Allan - both have good standards. I too am a sole coder at the moment but it's still very nice to...

Hmm - I missed this thread a couple of weeks ago 🙂 I have to say Jeff that your example is a bit contrived as decimal(4,2) is not the...

You don't want to give false impressions that you "know" all about these things and then annoy your (potentially) new employer when you don't actually know much about them.... ...

Or use Data Transformation Services (might be called Import/Export Data in your start menu) if you want a nice wizard interface to guide you through the process.

It's a pretty open-ended question. I assume that the databases have nothing in common.

Firstly, can your web site code point to a different database without much effort?

They're in different...

Perhaps it's a bit obvious, but could you contact your application vendor about this? Are they doing some bulk data import overnight and are "helpfully" changing the database to...

I second Andras - I'm wary of software that absolutely requires the columns be in exact order due to their use of select * in queries and then accessing the...

I was going to suggest that it was just bad luck / coincidence that more RAM slowed things down 🙂 If you weren't lucky enough to see it was...

What you were thinking of was a global temp table - these take the form ##myTable. There are two hashes rather than just one. Temp tables prefixed with...