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

Session ID > 50 is not a good way to determine system processes. Instead use a join to sys.dm_exec_sessions to use is_user_process something like this:

SELECT *

FROM ...

Check the compatibility level of the database you're querying against. If it's an older version, that can prevent Intellisense from working. Other than that, ensure that it's enabled and understand...

You can query sys.dm_exec_requests in combination with sys.dm_exec_sql_text to identify the query and session and then kill it.

I occasionally refer to CUD, Create, Update, Delete, when discussing the parts of ORM tools that I (sometimes) don't have problems with. Nothing in Bingle either. I think you may...

rodjkidd (1/23/2014)

---

He He - I know - can we turn the internet for a...