We have an archaic, legacy app that is retrieving every record from 1 SQL table, but is retrieving the data one record at a time.  ... i.e. SELECT *...

OR, you can restore the database to a new name (eg: if your database was called SYDSALES, restore a read-only copy as SYDSALES_RESTORE). Then all you've got to do is...

If the databases are on the same server, I would just use a insert like Allen Cui mentioned above.

If the databases are on different servers, but in the same...

Using Query Analyzer:

select name,dbid from master.dbo.sysdatabases

will list the name and database id (dbid) for all the databases on your server. Then using the dbid you can drop the database from the...

AJ Ahrens,

I'm not saying anyone's suggestion is wrong, infact some of them are quite inventive, just that they are not the simplest answers.

T-SQL is a simple language, and the...

Wow! What is it with you guys and wanting to do it the hard way?!

create proc spListEmployees (@Active smallint = 0)
as
Declare @NoOfEmployee  integer
if @Active = 1
   select @NoOfEmployee...

Jacob

If you alread have a license, the most important thing for SQL Server is RAM. Buy as much as you can (up to 2GB), but you should get at least 1GB....

Jose

There are major differences between Oracle and SQL Server. I don't know if it's a maturity thing as such, just the way Microsoft does things. Oracle seems (to me, personal...

Yikes! Data like that can be pre-processed with PERL really easily. Then use BULK IMPORT / BCP to get it into sql server.

Personally though, I'd ask for a better separated...

Hey Jose

SQL Server does not have an equivelent to TRANSLATE.. my only peeve with SQL Server. Oracle's Translate is also super useful for datetime to string conversion. DO YOU HEAR...

Idealy your application should be using Integrated Security; SQL Server should be using Windows Authentication; Permissions should be granted to a Windows Group; and then you'd be able to track...

You might also want to rethink on why you need to partition the table.

Oracle supports partitioning, so you can chuck the different partitions into different physical files, to distribute the...

CSV is a type of "text" file, NULL is a "binary" value.

If you need to keep the NULLs, export/import with a binary data destination, like an Access Database.

If each of the tables data is in separate files, your task becomes a 1000 times easier.

With a flat file, you can import using the BULK INSERT command or BCP....

First thing I would check would be that your servers, and your local client have all been service packed to the same version... or better still, download and apply the...