One thing to consider if you're going to run SQL Server locally is memory. SQL Server loves memory. Whatever you give it, it will happily use and just...

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...