Not sure what your question actually is, but why don't you use a sequence?

John

Yes, this is wrong, for the following reasons:
(1) It is resource-intensive and thus can cause sever performance problems;
(2) It can expose details that may be confidential;
(3) It's...

Your SQL Server monitor should give plenty of interesting information, such as wait stats, from which you may be able to work out what was causing your query to run...

Those were rhetorical questions, meant to make you think about what you actually require, rather than just answer yes.  Never mind - I'll take you at your word.  The query...

What do you mean by read-only access?  Do you mean members of db_datareader?  How about users with VIEW ANY DEFINITION permission?  What about those who have SELECT permission on some...

"750 Euro" and "150 Euro" are text values, so you can't add them up.  You'll need to separate the numbers from the words before you can do a sum.

https://blogs.msdn.microsoft.com/sqlserverfaq/2009/06/01/size-of-the-transaction-log-increasing-and-cannot-be-truncated-or-shrinked-due-to-snapshot-replication/

John

First, that's going to fail if you insert more than one row at a time.  Second, have you considered a foreign key constraint instead of a trigger?

John

Thom

I think you just use the "SID=" option in your CREATE LOGIN statement.  You get the SID from sys.sql_logins.

John

This doesn't use a correlated subquery, so it should perform better, especially if you have an index on Date1.  Parts of it are shamelessly borrowed from this article.

In your case, I don't imagine there'd be much difference.  If you need to join tables, you need to join tables, whether you do that in a view or in...

Thom

If you're rebuilding the same server on similar hardware but in a different place, then I can't see much harm in that.  But even then you'd want to...