:(, I guess it's better than a participation ribbon

I would read about spools, but also perhaps pose the question to Itzik Ben-Gan. He may know.

For most of us, I'm not sure it matters how this is implemented. I'd...

Good luck everyone and congrats.

I guess I'll go look for a 12th place trophy.

Agree. There are nuances....

I think so. Says...

The only way I know to do this is with a trigger. When there's an update, check to see if there are NULL values and 1s.

CREATE TABLE MyTable2

(id INT IDENTITY(1,1)

,...

david.irvine 7489 (12/18/2015)

---

My suspicions are raised as soon as I hear 'USB found on the street'. How likely is that? A few years ago there was a rash...

Ed Wagner (12/17/2015)

---

I was shopping at Wal Mart a few months back. The machine was messing up - 3 customers in a row. While I was in line,...

Xavon (12/18/2015)

---

Trying to figure out what the question had to do with a computed column had me stymied for a few minutes. I kept going back over it, trying...

I often remember this quote from you. It's a good one.

Aaron N. Cutshall (12/18/2015)

---

I saw a quote from Richard Branson the other day on LinkedIn that summarizes my feelings: "Clients do not come first. Employees come first. If...

samot-dwarf (12/18/2015)

---

Regarding extra money vs. free time for extra hours:

I think it depends on many factors. I by myself have to work not many extra hours. On the other hand,...

Sean Lange (12/18/2015)

---

Back from Disney and bringing you a song in the holiday spirit...

C’mon, sing it with me! Oooooooooohhhhhhhh……

He's making a database

He's sorting it twice

SELECT * from contacts...

Tempdb grows to the size needed based on your workload. However the space is re-used in tempdb. If it continues to grow, your workload is too large for your tempdb...

You need to check logs for issues, mainly that you don't have 823/824/825 errors or high severity errors.

IF the database seems to be going slower, likely you have indexing issues...