I can relate to much of what you wrote and got a good laugh from the punchline. Thank you for sharing this. 🙂

craig 81366 (6/18/2015)

---

Not really, because you've missed a few steps...

-...

gary.strange-sqlconsumer (6/18/2015)

---

Your example uses AdventureWorks2012, which suggests you're using SQL2012.

Then why aren't you using [sys].[all_sql_modules] or [INFORMATION_SCHEMA].[ROUTINES] ???

Creating a new custom sp_helptext seems a fruitless endeavour. I'm struggling to find...

The fact that Steve has to call for someone/anyone to step forward to share their experience says rather loudly that the technology isn’t widely used. It will be interesting...

If someone suggested this previously, I missed it. But go ahead and spring for the Developer's Edition of SQL Server which has all the functionality of the Enterprise version....

Jason A. Long (5/30/2015)

---

My default answer for that question, for the last few years, has been to start by picking up a copy on "Microsoft SQL Server 2012 T-SQL Fundamentals"...

Just picked up from The Thread that old Joe has been banned from SSC. Have to admit I have mixed feelings about that.

On some level I always...

Thanks Gail. No, I do not want to change/lose any permissions on these.

Had to do a little research to find out what that meant....

I've read positive comments about his personality on the forums as well. I just couldn't treat people like he does and still sleep at night. I was hoping...

Luis Cazares (3/30/2015)

---

I would think of Ozzy Osbourne. They're both precursors on their genres (SQL & heavy metal) and they appear to be more frightening than they really are. They...

Gail

I was referring to sequencing in a FROM clause as opposed to the sequence of transactions. Sorry I misunderstood.

sqlfriends (3/13/2015)

---

I have read some good practice of SQL server database. One of them is about data access.

It is recommended always access tables in the same order in all your...

Very nice editorial. Cool new paradigm!