Thank you for sharing such a great summary on Columnstore!

Would that be fair to say that BOTH data compression and columnstore indexing is most suited for DW scenarious,

or I should...

May be this is a naiive or ignorant question, but

if Columnstore is so good, and Columnstore compression is even a better compression than regular (page or row) Data Compression, then...

Should Columnstore be considered an alternative to compression, since Columnstore is also a compression?

If a comparable/similar performance gain is observed during testing for both Compressed table and same table with...

just changing FN into SP have helped us improve performance of quite a few processes. and some other tweaks in code to accomodate the new SP. =======

Just use built in wizard for EXPORT data (Right click on database in Object Explorer, choose Tasks, Export Data, and select objects that you would like to export).

Or use SSIS...

also if you administering that server and often need to lookup what services are started you can use command line

NET START command.

If you want to see all services related to...

How /where can i obtain DDL for sp_Monitor?

by the way, since we already have touched the subject,

is it a good idea at all to execute anything like this on a remote server as EXEC  (...)  AT <remote...

'AT' is the actual keyword, part of the syntax. You can run it like the above example from an Agent Job, for example..

and also you need to remember to do

The way we do this at one of our servers is this:

exec ('CREATE OR ALTER PROCEDURE ins_tmp_proc AS

BEGIN

INSERT INTO dbo.tmp (job_id, name, ..., server)

SELECT job_id, name, .., ' NAME_OF_MY_REMOTE_SERVER'  from...

ok. fixed by

, object_name (st.objectid, st.dbid)

THANK YOU!

Ok. I see. I need to create loop or cursor or msforeachdb... over 500 databases. yes doable but cumbersome.

Is there any existing example somewhere? I could not find on the Internet. Like a generic sp_obfuscate_varchar_column, something like that? T-SQL based.

So what mechanism of implementing data masking for PHI/PII would you suggest? if not using DDM.

A third-party tool?  (Apex Data Mask?..)

OR A few custom stored procs updating all sensitive columns...

It is with the purpose of letting an offshore team access a Dev server but they must not see PII.