I agree with erland, do a new schema for devs, that's the easiest way to manage it, when you add new devs you can just add them to the same...

I'm not sure you can get that the way you're asking, but I know that there are DMV's that will give you stats but not the same that you'd get...

I should have prefaced my answer with (If the database is not huge :))

If its not a huge DB then I take a copy/backup and load it into Dev to...

Agree about having the performance stats before doing any change/tuning/indexing/stats revision, etc...

I usually take a production copy of a database where I can benchmark to what an actual user will...

will this forum thread ever get back on topic?

I would love to work from home wherever that may be...hawaii sounds really good though 🙂

Only drawback for myself when working from home is that I ususally end up working...

You are so very right, that's the single biggest issue when coming to SSRS. PERMISSIONS issues...

You could also cast the value as decimal 🙂

can any of the steps in the ssis package be run in ssms? if so you should try doing that to just make sure you know what to expect and...

looks like there is a constraint to not allow duplicates in the table that is referring to fk_mfg_nb in your output in your comment, its a unique index so thus...

You can do either/or, but its best to do it in the query that has the initial list of all the data that you want, best to get the initial...

haha, you are out of control 🙂

A life long dream to reach that status?

if you're going from one environment to another then you should use a configuration file to hold the username/password to the server connection as well as for the ftp username/password,etc......

Use an execute sql task to grab the data the you need (i.e. from 2015 to 2016), then use a data flow task to take that data from that table...