New Website created  

I just created a new website to submit questions and get answers.

Try it out at http://questions.civicvoice.com/

I am still working on it, but it looks like it could be fun.
[ add comment ] permalink related link ( 3 / 31 )
On to a new adventure - Teaching SQL Server 

I have just finished all of the paperwork. For spring quarter 2009, I will be teaching a SQL Server DBA class at Western Washington University.

The class is for the SQL Server 2005 Specialist Certificate program at WWU. It is part of the Extended Education program.



[ add comment ] permalink related link ( 3 / 32 )
Job Update 

I work at Emergency Reporting, a fire software company in Bellingham WA.

I work with a great group of people providing fire software that supports fire rescue, EMS agencies and other agencies world-wide.
[ add comment ] permalink related link ( 2.9 / 55 )
For Best Performance Avoid SELECT * Select Statements and never use COUNT(*) 

This tip applies to both Microsoft SQL Server and to Oracle, and probably several other databases.

When you use the asterisk (aka star) in a select statement it requires all columns of data from the result set to be accessed.

Why not SELECT *?

More ...


[ add comment ] permalink related link ( 2.9 / 66 )

Next