If you want to partition, consider doing it by client. Try creating individual partitions for the large clients on Client ID and a catch-all for the smaller ones. ...

Use the lookup tables to generate views in the current database that point to tables in the other database.

You only have to regenerate the views when the source datatabase or...

@sql is not available inside exec master.dbo.sp_msforeachdb

You have to include all the code in the stored procedure parameter.

If your IO needs are really high, especially for read IO:

MySpace replaces all server hard disks with flash drives

http://www.computerworld.com/s/article/9139280/MySpace_replaces_all_server_hard_disks_with_flash_drives

MySpace Replaces Storage with Solid-State Drive Technology in 150 Standard Load Servers

http://www.networkcomputing.com/data-center/myspace-finds-novel-use-of-ssd-technology.php

MySpace...

Also, you can simply return the IDENTITY values inserted in the OUTPUT clause of the INSERT statement.

This is probably the best solution, and the only good solution for the case...

Eugene Elutin (6/25/2010)

---

It is known practice to use INT datatype to store dates especially in large datawarehouses... BUT!

Not in the YYYYMMDD format!

As in order to convert it back tp date...

EXEC sp_MSforeachdb 'USE [?]; EXEC sp_spaceused'

SQL Server 2008 (or 2008 R2 ) Enterprise Edition is required to do Transparent Data Encryption.

You can read about it in SQL Server 2008 Books Online.

People need to get past the idea that relational databases are obsolete because they don’t do every possible thing anyone could ever want to do with data.

Doesn’t handle streaming interactive...

Look at using the PIVOT operator in SQL Server Books Online.

I don't think anyone said replace single quotes with double quotes.

You need to replace the single quotes with two single quotes.

Do it this way so that you don't have to worry about that problem:

select datediff(dd,'19700101',getdate())

Much more info about handling datetime in SQL Server here:

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

Homework?

It could be getting done manually, it could be a scheduled job on another SQL Server, a Windows Scheduled Task on another server, or it could be launched by an...

Is there some reason you can't use an editor to replace all single quotes with two single quotes?