Personally, I'm one of those who won't "turn out the lights" on my servers. In my mind, having a system available and performant trumps the cost of electricity to...

Nice question, Andy. There was enough there to get me thinking in different directions. I learned something new today because I've never seen that error. Thanks.

I didn't know the results of the last two either (COUNT ALL) because I never use it. I learned something new today - ALL is the default, which does...

BrainDonor (1/18/2016)

---

Oh, it's a 'thing' alright. I'm reserving judgement on what type...

Lawyers

ChrisM@Work (1/18/2016)

---

Jeff Moden (1/18/2016)

---

ChrisM@Work (1/18/2016)

---

With the battles I'm currently facing...

Thanks, Luis and Orlando, for the examples. I used FOR XML and also avoid entities by using TYPE. I also do concatenation into a variable where appropriate and...

I believe it was Wayne Sheffield who said "An ORM is the fastest way to slow down a database."

Then again, it may be done well, with the ORM calling stored...

I'm going to deviate from the calendar discussion for a moment. I've worked with preventive maintenance systems before, so something in your design caught my eye. You have...

Orlando Colamatteo (1/16/2016)

---

Luis Cazares (1/14/2016)

---

SELECT @Notes = @Notes + CONVERT(char(11), DATE, 103) + NOTES + CHAR(10)

FROM tblNOTES

WHERE NOTE_ID...

Once we get the DDL, it could go in a number of directions.

Bread

Welsh Corgi (1/15/2016)

---

Phil Parkin (1/15/2016)

---

Welsh Corgi (1/15/2016)

---

drew.allen (1/14/2016)

---

No, you don't....

I'm curious - Was it the quotes that caused the problem?

Years ago, when I first started writing in .NET, I connected to a local SQL instance. Being completely new...

Did you read what Jeff posted? Using a function on a join predicate is going to result in a scan, which is very inefficient. The function has to...