Found this very useful today , wasn't able to connect remotely to do a data profile and the network speed would have prevented that anyway so this really helped.

Hi - This really helped me field a query from my boss ultra quick - I appreciate your hard work being shared.

Really helpful, thanks.

A good article but much poorer than the first 4 steps.

When you refer to 'non read' activity - you do very little to point out what types of operations in...

I think the line that reads 'scanning the entire table of one million rows' should probably be 'scanning the entire table of twenty thousand odd rows'.

I'm not being pedantic here...

I was doing something similar yesterday, my understanding is this ...

The user 'dba' will need to connected to a SQL login that has the rights to create server logins. I.e....

This is from memory so I might get shot down in flames here. But I think the distributor needs to be at the highest SQL version that you are running...

I think Windows 2008 Small Business Server (SBS) Premium edition ships with SQL 2008 standard - however I can't imagine this being cheaper than buying 2008 Server and SQL Standards...

Download the Redgate Toolbelt trial - the SQLCompare tool should solve your problem.

Really helpful and saved me a heap of time - thanks, much appreciated.

Hi,

couldnt you use the structure :

UPDATE TABLE1

SET VAL1 = ISNULL(@PASSEDINVAL1,VAL1),

VAL2 = ISNULL(@PASSEDINVAL2,VAL2)

WHERE PKEY = @PKEY

I suppose this still leaves the issue of actually wanting to NULL out a value in...

Thank you for posting the article. You've no idea the amount of tears and tantrums you've saved me 🙂

Once you get a good working example SSIS really falls into place...

I'd be fine with it, I'm always interested in products that make my job easier and if it can benefit the DBA community and raise a few bucks for SSC...

Really usefull ! SQLInForm will be especially usefull for me.

Another free tool I find extremely usefull for scripting table data is SQLScripter :

http://www.sqlscripter.com/

Can really save some time and...

I actually swallowed that - doh !