David Moutray (12/22/2011)

---

Very cool query, Mr. Russell. I did not know you could do that. The only problem in applying it to this particular problem is that the...

This query will summarize what...

In addition to making the code less structured and less readable, another problem (at least for those who choose to use it) with T-SQL's implementation of GOTO is that it's...

Elliott Whitlow (12/21/2011)

---

Jeff Moden (12/20/2011)

---

Absolutely wonderful article, Steve.

Concerning the question in the article...

If you had more pride in your employer, wouldn't you be a little more careful in caring for...

I believe all organizations should get to know the people who handle their sensitive data and make sure they are happy. If they are not worth paying well or knowing,...

It seems in my previous example, I misplaced the option (hash group). Below are two versions of...

sqldba_newbie (12/15/2011)

---

Eric M Russell (12/15/2011)

---

sqldba_newbie (12/14/2011)

---

sqldba_newbie (12/14/2011)

---

Eric M Russell (12/14/2011)

---

sqldba_newbie (12/12/2011)

---

I see huge performance difference on joining a #temp_table instead of @table_variable. Query runs way faster when i join on...

sqldba_newbie (12/14/2011)

---

sqldba_newbie (12/14/2011)

---

Eric M Russell (12/14/2011)

---

sqldba_newbie (12/12/2011)

---

I see huge performance difference on joining a #temp_table instead of @table_variable. Query runs way faster when i join on a #temp_table. Any idea...

sqldba_newbie (12/12/2011)

---

I see huge performance difference on joining a #temp_table instead of @table_variable. Query runs way faster when i join on a #temp_table. Any idea what could make it so...

As a datamart developer and data anayst, I often times work directly with end users, who are managers and department heads. Therefore, if I think of a bright idea, I'll...

I think more explanation is needed about what your script is demonstrating. Is your specific intent to demonstrate how to select from a "remote" stored procedure?

When I want to...

FDE isn't needed or required on the server, but definately for laptops belonging to corporate IT people. It's inevitable that sensitive information will end up in local email storage, Excel...

Times New Roman was commissioned by...

I'm a DBA on some development and QA servers but...

When you reference a table variable in a stored procedure, SQL Server operates on the assumption that it will contain at most a small number of rows, and will generally...