Great article. I had a need to execute T-SQL for every database on a server. I did not want to use the MS procedure for the reasons that...

So I've been working on a statement:

There are two problems: First is that not that many folks would understand it and...

Gary Varga (11/20/2014)

---

As a developer who rarely touches production machines (good job too) I never realised or even thought that having a Windows session (I assume that RDP would cause...

At a very large ISV company that I worked for we had a policy that one thing ran on one machine. One box for SQL Server, one for e-mail,...

Ben. Whatever works for you. 😎

Retire? Me? Never! They will find me dead at the keyboard!!

First of September I just got out of six months in a medical facility. It did...

Hey! I'm 61 and nowhere close to done.

This is nice thing to do when you are trying to understand some other persons code. Especially if it already has block...

At one company...

This is a great question. We would put out deployment scripts and it fell to a person that was not a DBA to run them. There was always...

Mr. fisher you are correct. You can't eliminate the WHERE all the time. If I gave that impression then I apologize for a misstatement.

I'm not against any clause...

I added the emphasis. Yes, understanding this execution order is why I have been able to write good performance filtered queries with...

Great article. I'm about to set one of these up myself. I'll hold off and anticipate the next part.

I have some tables that represent "Domain" data. I...

Jeff asks, "What's wrong with RBAR at night?". Even shorter answer is 24 hour processing. What night? My night is one clients early morning.

peter-757102 (12/9/2013)

---

2. per read record you decide which other records you are going to fetch (like a naive join you see beginning programmers often do from within the application layer,...

patrickmcginnis59 10839 (12/9/2013)

---

Now this is interesting, because doing the running totals thing would be awesome in a cursor! Would a cursor based solution beat the triangular join method? Would a...