Yeah, it's called SQL Server 2014.

But...

Sounds...

Like I said. Opinions differ.

Another consideration is the width of the key. The wider it is, the fewer key values are stored per page, which means possibly deeper B-Trees on the index and more...

I suggest you always set the max memory. You're right. Your server doesn't seem to be under stress and the chances are, it won't be. But, SQL Server will attempt...

ChrisM@Work (1/24/2014)

---

IgorMi, you can use http://extras.sqlservercentral.com/prettifier/prettifier.aspx.

I tend not to. If I'm about to spend a few minutes reading and understanding a chunk of code, reformatting it easily becomes part of...

ChrisM@Work (1/24/2014)

---

Thanks Grant. Me too, there are over 70 reads of the...

Nice job Chris. I'd love to see what the execution plan of the original query looked like.

Getting UNION ALL to work is just a question of, sort of, writing the same query twice:

SELECT a.Column1,

b.Column2

FROM TableA...

Code validation takes place before any of the other optimizer steps, so it has to read correctly as the others have stated. And the order can matter if you have...

Take a look at T-SQLT[/url]. That's a unit test framework for T-SQL. You can also check out SQL Test[/url]. That's a framework that Red Gate wrote around it.

Oh, if they're mapped to a single user, yeah, you're kind of stuck. There's no easy way there. You'd have to modify your structure so that instead of mapping them...

Put an upper limit for SQL Server so that it doesn't take all your memory. SQL Server, out of the box, is configured to take every bit of memory it...

But, SO has a very firm idea in mind, questions and answers, period. Because of this focus, they get a lot of attention, additional links from blogs, etc., which leads...

If the users are coming in under different accounts, isn't the account the differentiator? I realize the roles are the same, but that's a login mapped to a role (hopefully)...