According to https://technet.microsoft.com/en-us/library/gg492084(v=sql.110).aspx

last_access_time is datetime2(4) not null.

First query has an extra ; before ORDER BY, just a comment.

I've read the post and he says: "(I've ignored [alias] and "alias" variations for brevity.)". So even when he's talking about six different ways he was also admitting there are...

Hany Helmy (6/10/2015)

---

Now we all agree that the 1st row will be inserted & there is absolutely nothing in the code will disable the indexes, so the next question is:...

I wanted to have all green checks in my QOTD list and now I've got a red cross!

Louis Hillebrand (6/10/2015)

---

After running the first script the table has 2 indexes, A unique non-clustered on SalesId (PRIMARY KEY) and a clustered on SalesId.

The first insert inserts one row, the...

Microsoft SQL Server 2012 - 11.0.5058.0 (X64)

May 14 2014 18:34:29

Copyright (c) Microsoft Corporation

Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

SQL 2012, I've got Script B and A.

One of the most interesting questions I've seen. Thanks for that!

+1

I was going to write exactly the same 🙂

Toreador (3/5/2015)

---

Even ignoring the typo/mistake, the explanation is totally wrong. It is nothing to do with whether the statements are logged, and it is common incorrect) myth that TRUNCATE TABLE...

I only marked option F). Option D) has a wrong syntax. It should be delete from BBB; delete from AAA;

Jeff Moden (1/19/2015)

---

That's gonna leave...

Yes, test is the best, I agree. The only problem is that I underestimated the size of the table, it has 3 billion rows.

You're right, Koen.