Andy DBA (6/1/2015)

---

When you say "Just because you can, doesn't mean you should" are you implying that SQL Developers initially think in terms of loops and then arbitrarily decide to...

Andy DBA (6/1/2015)

---

Thank you for injecting some humor into my Monday morning. "sql God"? "SQL-Peackocks[i]sic[/i]"? Really? Because I'm more concerned about database performance than I am about the...

There are other cases for cursors as well. First, let's get real here and everybody admit that we're not all working on high-speed trading systems where every nanoseconds counts....

Very well presented and well designed tutorial. The color-coding and the comparative association to the typical Excel user's way of thinking was a perfect way to explain these concepts.

--Jim

For those using 'Legacy' systems--back in the day of VBA and DAO--one could just use a DAO recordset based on a pass-thru query calling the SP, then use the .NextRecordset...

I agree the Konesans may be easier to implement, but I just finished a rebuild of a set of ETL tasks in which I gutted Konesans and went to WMI....

Pardon me for jumping on a dormant thread, I came across this while researching naming conventions. Regarding the prefix "sp" (with or without the underscore), doesn't the sp stand...

Festerson,

Thanks, that was definitely enlightening. I read through the bol stuff, and realized I had mis-used a term in my question.

What I was wanting to know was really:...

Hi all,

I have a related question that I think was somehow answered in the above posts but I just wanted clarification for academic purposes:

Suppose I change a field of data...

A couple of comments:

1. I appreciate the offer of these utilities and the benefit of the work put into this.

2. However, I get the "Subquery returned more than...

Hello,

We just experienced a similar issue--severe hits every couple of minutes and found the culprit.

It was an HP server, and the culprit was HP's SNMP monitoring agent. Every...

Great stuff. I had to change collation a while back because even though all production db's were in the out-of-box default collation (we had inherited a newer more powerful...

I'll just weigh in...that's a little much don't you think?

Putting a dummy column in EVERY table to prevent Select *? As others have alluded--you've got bigger problems if...

Hi,

Great article. On the same general topic but stepping back to the part about getting the AD data into tables:

It's 2011. Why the heck doesn't Microsoft store AD...

While I agree in general principle with the gist of the article, I don't think everyone needs to run into work this weekend and take their servers down and rebuild...