I was scared for a minute that this was actually valid, and wondered what would happen when the #temp table went away. Glad to see it is unpermitted.

Not the most intuitive location for this information, but the "Install SQL Server 2016 from the Command Prompt" instructions lists the defaults of all the switches, including tempdb initial size/growth.

https://msdn.microsoft.com/en-us/library/ms144259.aspx

I was bit by this developing one time. I was genericizing a stored procedure to work with newer tables as they were created (the procedure was for cleaning up old...

I stared at it for a really long time, went back and forth on where the loop goes to, eventually decided that it wouldn't get set to one each time,...

Sean Lange (8/5/2015)

---

Ed Wagner (8/5/2015)

---

Sean Lange (8/4/2015)

---

Brian.Klinect (8/4/2015)

---

So it seems like we have an option between 'dirty' data (NOLOCK) and incomplete data (READPAST). I never knew about READPAST until...

So it seems like we have an option between 'dirty' data (NOLOCK) and incomplete data (READPAST). I never knew about READPAST until today.

BWFC (8/3/2015)

---

TomThomson (8/3/2015)

---

Anyone who says "this is the most badly put together question I've seen for a long time" has clearly not looked at many Questions of the Day, and...

I didn't even know the questions had titles. I read the question in the newsletter, and then look at the answer options when I pick "Click Here" to answer....

The explanation says why 3 is wrong, but why is 1 better than 2? The only difference I see is 1 has SUM(SUM(TotalDue)), while 2 has SUM(TotalDue) in the...

sucheta.kothare (3/24/2015)

---

Today's question included the statement regarding walking off "without Logging Off" and still the user should not be able to use the set of permissions then how come with...

I learned to today that I can set permissions at the column level. Never even considered trying to do that before.

I really liked the story that went with the...

I actually got .0000 for "SELECT $", so that definitely goes along with the "doesn't store currency type" information.

I too did not pick COUNT because COUNT(<expression>) ignores NULLs. That took some time getting used to.

Is the first link to AllAnalytics right? It doesn't seem to be about a college, but instead about the writer's last day.

Didn't expect to see that at all! 😀

So in this particular query, since we are checking if the id from Stocks is in the same set of id from Stocks,...