Rob Fisk (10/2/2009)

---

peter-757102 (10/2/2009)

---

Jeff Moden (10/2/2009)

---

peter-757102 (10/2/2009)

---

Jeff Moden (10/2/2009)

---

That's why I shifted to All_Columns for future code. Rumor has it that syscolumns is going away and Master.sys.All_Columns always has...

Jeff Moden (10/2/2009)

---

peter-757102 (10/2/2009)

---

Jeff Moden (10/2/2009)

---

That's why I shifted to All_Columns for future code. Rumor has it that syscolumns is going away and Master.sys.All_Columns always has at least 4k...

Jeff Moden (10/2/2009)

---

That's why I shifted to All_Columns for future code. Rumor has it that syscolumns is going away and Master.sys.All_Columns always has at least 4k rows on a...

Nice find...I never understood how exactly the illusion worked or how old it is. Too bad it doesn't tell as much about preference and...

I tend to disagree with a lot of things in this topic, for example.

Tim Mitchell (9/23/2009)

---

When dealing with nontechnical people, the highly logical left-brain IT staff may misinterpret the lack...

James Stover (9/23/2009)

---

Having said that, I'm an IT guy in my late...older than 30 ok...and like the Old Guard I lament the lack of basic IT skills. I just have...

As I see it, the more one is shielded from the internals of something complex, the less (or at least slower) you pick up deep knowledge by working with it....

Jeff Moden (9/22/2009)

---

peter-757102 (9/22/2009)

---

We really need a mode of SQL server where al output order is randomized if no ordering is in effect (explicit or otherwise). This would take away...

We really need a mode of SQL server where al output order is randomized if no ordering is in effect (explicit or otherwise). This would take away the guessing out...

I wonder why a SQL magazine published code that used a multiline table valued function given their reputation for scaling bad. It will not help to educate readers on how...

Here is an exampe of generating a range of numbers form an existing tally table or function with numbers starting at 1.

-- Get a range of numbers based on a...

I quickly read the article and ran no tests myself, but if all this code is only used to quickly fill a table with numbers then I am perplexed about...

Stephanie J Brown (9/18/2009)

---

Nice article on the impact Agile can have on DBA's, David.

Full disclosure: Agile Scrum Master here!

Agile can work well in a lot of situations, but you...

I have my concerns about agile development and I suspect that it is like all other methodologies prone to being applied wrong due to it being used for its buzz...

Much of the naming problem would be gone if companies recognize the true roles people fill in and make job descriptions accordingly. Right now it is indeed 'someone + database...