It uses the .net framework functionality for scripting that are in the Microsoft.SqlServer.Management.Smo namespace.  I wrote a .net command line utility in C# that lets me access these handy scripting features and use it...

Why not populate a merged temporary table by selecting from the two sources (ie union all). You now have the row count so then dump your header, the temp table and the trailer...

Basically you can use OPENXML to represent the XML data as a relational table. You need to know what flavor of XML you are dealing with though and pass the...

First of all, I would hope never to receive data of this type in a single file like this. The data should be supplied in two files:  One containing ProductID and ProductName,...

You could writ a C# class with method(s) to do what you want then create as CLR assembly and user functions. Then you could manipulate the column data directly with...

A agree with Jeff. Unless it is relatively simple you should design your database objects and define the relations as it conforms to business rules but also considering what type...

The schedule also has an enabled flag. The schedule also may have had an end date.

You'll need to create a .NET assembly that ultimately calls out to the Java routine. There will be a lot of overhead in this so consider how it will be...

Well, I supposed you could...

Okay, then your only other option is to bcp in to a stage table that has ints, then do a final insert into the destination table having the bigints.

sp_rename won't work on computed columns. Probably have to drop and recreate it. The caution/warning messages are normal output of sp_rename.

You don't want to use RAW in this case because it expects the data types to be the same. Use something other than RAW, or use a query out that...

Your query looks all wrong for one thing, you are using group by with no aggregate so I assume you want to SUM(AMOUNT) for different conditions. And you really don;t...

With separate file groups you can specify exactly where tables or partitions will be located.

With SQL Server 2012 Always-On AG you can have active/Readonly-Active cluster without a SAN. You just need two servers set up the same way.