The data generation tool in visual studio for database professionals works really well.

You get a good variety of ways to generate data, including using an existing database as a source.

You'll find the Maintenance Cleanup Task is a standard task in the Business Intelligence Studio (where you write SSIS packages).

I haven't used the wizard myself, but you could manually add...

In SQL2005:

SELECT SCHEMA_NAME(OBJECTPROPERTYEX(OBJECT_ID('yourTablesName'),N'SchemaId'))

If you want to suggest changes to Reporting Services, jump on Microsoft Connect, where you can give feedback and vote on changes.

https://connect.microsoft.com/feedback/default.aspx?SiteID=68

From a quick search there is only...

Yes you can split ranges in partition functions.

Use the command ALTER PARTITION SCHEME .. NEXT USED newFileGroup to specify the filegroup you want the new partition to use.

Then use: ALTER...

Are you displaying the output of your query in "Text Mode" in SSMS?

Grid mode (the default) could remove the crlf's for display reasons

If you are working with that much data, you might find that Nsort works faster

http://www.ordinal.com/ssis.html

Are you looking to just move the logs or for transaction log shipping?

Datawarehousing is just a little more specialised and a lot less understood.

If you are having troubles getting questions answered here, i'd suggest the microsoft forums, or trying some other sites....

Another method is

USE master

go

DECLARE @spid int

SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id()

WHILE @spid IS NOT NULL

BEGIN

EXECUTE ('KILL ' + @spid)

...

Read the resources on scalability with very large databases. There's lots of details and benchmarks on optimal configurations disk subsystems.

http://www.microsoft.com/sql/prodinfo/previousversions/scalability.mspx

I'd say Marc is on the right track. I've upgraded a number of servers, and I use the following steps:

backup databases + os / etc (to separate network location, and...

Sound similar to something I wanted to do a long time ago. I quickly knocked up an example today, so here's an article I wrote for you:

SSIS Lookup with...

Japanese is unicode as well, so its best stored in nvarchar/nchar/ntext fields.

I would store a product description in multiple rows. If you created a table just for descriptions, you could store...

If you want get just the date from GetDate() without the time, use CONVERT and the 112 format.

eg:

-- Get current date (without time) as string:

SELECT CONVERT( CHAR(8), GetDate(), 112)

--...