an ex  colleague of mine used to turn up in knee length shorts, Hawaiian shirt, flip flops and a lot of "bling" -

the directors put out an email about dress...

I had to teach a bunch of R developers how to get data from CSV (actually ~ delimeted)  how to use the import/export wizard.. and saving to a SSIS package...

ps - urban dictionary of time vampire

A person who finds creative ways to needlessly waste his/her friends time. Normally done during working hours, and involves elaborate, tedious and often ambiguous...

My project manager  is a "time vampire" - I seem to be doctor who and do tricks with making time go backwards - but I think they call me "Dr...

• This reply was modified 5 years, 11 months ago by MVDBA (Mike Vessey).

SSIS is not as bad as people make out, purely because people don't know how to use it. I think DTS was better (but im an old guy) -

Table triggers will kill your performance and are generally frowned upon. If your database is small and your users are few it won't matter, but this isn't a scalable...

We maintain "TableName_deleted" tables for our data tables, each of which is the same structure as the data table it reflects (except for no key fields), plus one field...

pretty much the first google hit

https://www.mssqltips.com/sqlservertip/2552/creating-an-ssrs-map-report-with-data-pinpoints/

Granted, restoring a backup to a live database after a deploy with issues is risky at best and virtually impossible in most cases. Typically we just move forward because...

SQL uses statistics to check ordinality and cardinality of a table to figure out which index to use or which query plan to use.

if your data changes in volume in...

I think jeff might be onto something - as soon as I started reading his message I had the words "parameter sniffing" popping up

index hints is also a valid tool...

We use synonyms a lot between databases so we can keep the general functionality separate and give us lines of demarcation for all sorts of things including the isolation...

best of luck - if you have the chance, try both methods, ignore us all and go with the one that best suits you

I'm now curious as to the original poster's opinion - thankfully no-one has posted "mirror with snapshot" or "log shipping"

First, if your developers have the ability to delete data from a production database, it's not a production database, it's a development database. There's no excuse for letting developers...