#Fail !!!

You need to keep all  transaction log...

That is SQLServer backup compression server level setting ( or at backup command level ) !!!

Do not...

This indicates a bug in the marvelous software.

did you upgrade your SQLServer to its latest cumulative update? ( please do ! )

• This reply was modified 2 years, 10 months ago by Johan Bijnens.

it is a bad practice, but that doesn't mean it cannot be done.

Did you try "create table tempdb.dbo.tablename ..."

Please provide Indexes  for the tables to support whatever you want to do !!!

What did you try?

Why not just update what needs to be updated and insert what's new ?...

must be a routing issue.

Check the path ( tracert ) which your connection has to follow to be able to connect to your instance.

- router/switches/vlans/Wirewalls/...

• does it also need that...

Double check if the target backup location hasn't been switched to a (windows) compressed volume !

Have a look at : "clustered-and-nonclustered-indexes-described"

and /  or "Effective Clustered Indexes"

There is a nice "Stairway" series about XML

Did you searched SSC for a split string article ?

"Tally OH! An Improved SQL 8K “CSV Splitter” Function"

Execute the sproc in PlanExplorer ( free tool ) to record its full execution plan en explore the marvels of that tool.

DEVOPS is a buzzword !!!!! Can anybody point me  a solid guideline how to manage legacy typed databases in a DEVOPS environment? NO ! ... Multiple projects /...

Check Shutdown

DEVOPS is a buzzword !!!!!

Can anybody point me  a solid guideline how to manage legacy typed databases in a DEVOPS environment? NO !

The only guideline you get is: "start small...