I'd do it by exporting to three separate files. That'll make the import on the other end easier.

It's probably a floating point issue. It looks like you're using floating point numbers (they have decimal places), instead of integers. Shouldn't affect whole-number calculations, but it may...

Any place where you need to dynamically run against objects in the database or server, or call a stored procedure over and over vs a dataset, when the results aren't...

SQLdba-473999 (2/15/2011)

Are you referring to perfmon? I only see an option for...

Sounds like a good way to end up with a junk database to me.

Is this some sort of ETL method for getting data from files into tables? That's what...

Hash joins are sometimes useful just because they're the fastest option for even relatively small data sets.

Check out http://msdn.microsoft.com/en-us/library/aa178578(v=SQL.80).aspx for more data. It says SQL 2000, but it's applicable...

A couple of uses I've run into that were a bit specialized were breaking up data so that deadlocks would be avoided. A lock on the source table can...

I generally have a server-side trace running that will tell me how many transactions per minute/second/hour/month/whatever, a given database is supporting, and how much CPU, etc., they are using. ...

In SQL 2008, a filtered index on one or another of the values in a bit column, can make a HUGE difference in performance.

In 2005 and earlier, just don't make...

The only way I've ever seen this work is to take the data quality, analyze it, report on it, and make it part of the annual review (salary and raise...

I would do this in two steps:

First, select all the logout times, possibly using a Distinct operator if there is a possibility of a duplicate.

Then, select the Min login that's...

If the column is datetime data type, then the layout "in the table" doesn't matter. It's actually stored as a number, and the way you see it depends on...

Yes, transactions include anything a trigger calls for.

If you want to manage that more precisely, move the code out of the trigger and into a proc. You can then...

You're welcome.

If you really need to do this, then line up the columns that match, in your select statement, and use Null in the ones that don't match.

Select IDColumn, NumericColumn, VarcharColumn,...