Well, yes.  A unique index is (almost) the same as a primary key.  Take the UNIQUE out of the statement and everything will be good.  You only need the index...

Create a clustered index on table2 on the same columns that will form the clustering key on the main table.  You'll then need to write a query that will not...

Perhaps it's a default language thing.  Suppose you have a line in your query WHERE DateCreated > '01-12-2017', this could be interpreted differently depending on whether a user's...

No, absolutely not.  Normal log backups in normal circumstances; a tail-log backup in extreme circumstances, for example someone has deleted a large table and I need to restore the whole...

DDL = CREATE TABALE statement, including CREATE INDEX statements.  Queries = the full query you're having a problem with.

If you're filtering on auftragdatum, that's likely to be painful,...

I think it depends on the context, not on the method.  If I'm backing up a log of a database with the intention of restoring over that database, I'd call...

When you say 58 million rows have been deleted/rebuilt, what do you mean?  What rows are affected - just those at the end of the table, or rows in random...

I'm confused about whether you're using a linked server or not.  But try something like this.  If you are indeed using a linked server, make sure you understand about linked...

Try this.  If you wanted to go to an indeterminate number of dimensions, you'd need to use dynamic SQL.  I don't know whether, or at what point, performance will become...

Like I said, this is something you need to do yourself.  It's too tiresome to expect someone else to do it for you, not to mention the fact that we...

I can't open your file - just as likely to be due to restrictions this end as to anything wrong with the file itself.  Combing through a deadlock graph isn't...