ALTER COLUMN: https://msdn.microsoft.com/en-us/library/ms190273.aspx

"Modify columns" https://msdn.microsoft.com/en-us/library/ms190259.aspx

implicit conversions https://msdn.microsoft.com/en-us/library/ms187928.aspx

it depends, for some data type changes it has to rewrite the whole table to get all internal stuff in order. ( e.g. from char to varchar, varchar to nvarchar, float to...

This is the sequence I use:

-- 0 = db file info
-- 1 = backup log
-- 2 = Shrink log file
-- 3 = extend...

My guidelines for FK-indexes: Always put an index on the FK columns, unless that hurts the performance of that particular system. ( i.e. your milage may vary ! )

FYI

sp_flush_CT_internal_table_on_demand [ @TableToClean= ] 'TableName'

Thank you for the feedback.

I steped away from tsql scripting for this purpose.

I use a powershell script/module to assemble and restore databases from whatever sqlserver source to a given sql server target.

You can find...

I chocked and was shocked seeing this:

import-module sqlserver

Get-SqlPort -sqlserver myserver\myinstance

result

Get-SqlPort : SQLDMO is not installed.

At line:1 char:1

SQLDMO ????????

Oh, wait, maybe that's the one coming from the "old" SQLPSx installation

Thank you for the feedback.

Glad to read to got it fixed.

first make a tail log backup

then you can use 'restore filegroup ' starting from your latest full backup

then restore diff backup if available

then restore logs as needed ending with...

or even better, submit it as an SSC article !

Marketing only highlights the fancy stuff !

Users want it to work

DBA want...

is your name column Nullable and are there rows where it is null ?

ref: Something About Nothing: NULL By Kathi Kellenberger[/url]

ref: NULL Versus NULL? By Michael Coles[/url]