106 automatically created databases....

Wow! :crazy:

Interesting script though, thanks! 🙂

Hi Kim

I implemented this in an environment with similar constraints. I had QA and PROD on the same server, but was logging in with different user names, so I made...

I just checked out the ioDrive Octal.

Allow me be the first to say: OMG, I wantsss it

Hi R.P.

We have a web app as our front end, and start one conversation per user session per queue that we use.

These conversations are kept, and when the back-end app...

Hi Andrew

When you initiate a conversation between two queues, you actually end up with two conversation handles. One used by the sender queue to address the sender, and another used...

We end all of...

We are getting ready to go live with an (expected) large volume public facing site for the very large retail company where I work.

I had to select a queuing technology,...

ben.mcintyre (4/7/2010)

---

While I agree with the sentiment of this article, I think the most important thing is: if you DO change any data, KEEP AN AUDIT TRAIL ! You...

bobmcc-957585 (1/20/2010)

---

This is a sidebar but....

I am struggling with how the CTE is referencing itself from within itself

This works but I need clarification on it. The CTE is referencing...

Hi Jeff

I do not have the code handy at present, and am too sick right now to recreate it 🙂

But in my case I was filtering rows out based on...

I find that an easier way to get the list of columns is to drag them from the object explorer in SSMS. If you expand the table object's columns list,...

That's interesting

I benchmarked EXCEPT vs WHERE NOT IN (SELECT .....), and for my dataset, server, DB version etc. the performance results were equivalent, or biased towards EXCEPT.

Can you give more...

Oh the humanity.... I had a good chuckle at the idea of Cursor Boy and his arch nemesis Loop Man

I have a full head of hair, but it is graying...

Ok, I see what you mean. that is definitely something that you cannot do with a cursor. Not that I have needed to change the cursor contents in 11 years...

Hi John

You could exclude those people from being processed by changing the query that is the source of your cursor, i.e. select all where they are not 5 feet tall.

So...