Something like this.

use databasename -- this script should run against required database

-- these two should be set as required
declare @shrink_target int = 10000 -- adapt as required...

Its a choice, but paying for SQL Server just to use SSIS is not what I would consider a good choice.
Without even considering some of the free ETL tools...

before you implement this make sure you understand all the implication of using partitioning.

It is not easy to implement, and can lead to performance problems.

the sample...

Tom,

Yes its never clear cut - but on this case we are talking about using a particular piece of software (Sql Server Developer) to access a production server,...

I'm not going to ask if that is the right choice or why you are doing it - others will most likely do it.

Assuming it is indeed...

By defaul AppDynamics will come with all the counters you need for SQL Server so nothing required to add to it.

I use both AppD and SQL Monitor and...

or another alternative to Luis code - wonder which one will run faster

UPDATE Inventory
SET ItemNum = stuff(ItemNum, 1, patindex('%[^0]%', ItemNum) - 1, '')
WHERE ItemNum like '0%'

I would try and do one of those loads onto a varchar(100) and then do a select convert(uniqueidentifier, varcharcolumn) and see if any fails.

If the test above does...

for 2012 - http://download.microsoft.com/download/7/3/C/73CAD4E0-D0B5-4BE5-AB49-D5B886A5AE00/SQL_Server_2012_Licensing_Reference_Guide.pdf

Lowell,

Not according to the license terms - None of the SQL Developer blocks (SSIS, SQL Server itself, SQL Server Agent, SSAS, Report Services) can connect to a production...

one other option which may be viable depending on the number of distinct values of that field and its mapping to the new system.

something around these lines

VS is only 32 bit and so is SSDT (as this is nothing else than extensions to VS).

Normally this is not an issue as most of the common...