SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2008

What’s in a Name?

Why do folks continue to use outdated and unnecessary naming conventions? Specifically, the ridiculous ‘tbl’ prefix on tables, and the equally meaningless ‘usp’ for stored procedures. I think that it is because that is what they see illustrated in books, magazines, white papers and on-line 'example'… Read more

0 comments, 1,198 reads

Posted in SQLSequel on 23 October 2008

When Do You Know That You Know

Why, when you can help others, that's when! 

In my role as a senior Moderator with the MSDN SQL Forums, I am often asked "How do I become a Moderator on the Forums?"

I am quite appreciative and heartened when folks indicate, and then demonstrate, their interest in helping others. Volunteering to assist… Read more

0 comments, 422 reads

Posted in SQLSequel on 17 October 2008

Through the Looking Glass: Elegant -or Not?

SQL Server as an EAV Database -Good Idea? 

It seems like I am getting more and more inquires from potential clients asking for help solving performance related issues with what, after some investigation, is using SQL Server as an EAV database.

First, for those unfamiliar with the concept, an… Read more

0 comments, 327 reads

Posted in SQLSequel on 3 October 2008