SQL
There are 2 entries for the tag
SQL
Last week I learned all I ever wanted to know about SQL indexes and then some, as a result of a severe performance issue in our lab system. When I say severe, I mean people, literally, could not work.
Now conceptually I understood indexes and the need for them, but having never really been accountable for the database on a nontrivial level I wasn't really up to speed. (ha. get it?) Now I am.
The primary purpose of indexes from our (the application developer) point of view is speed speed speed. A well indexed database stands up to demand much better than...
Continuing my earlier post about Webforms Directives, here's another thing I always forget when I don't use it: Connection Strings. Thanks to Mike Schinkel for blogging this (and for the free XDN membership!).
It seems like every job, every project, I only ever connect to one type of database. So after connecting to Oracle for a year, I forget how to connect to SQL. And after connecting to SQL in .net for so long, when I need to do a quick hack to an existing Classic ASP page, I forget how to do it in classic ADO....