Skip to content

Category Archives: Database

RDBMS, ODBMS, and their related technogies.

Dealing with comma delimited data in a database column

13-May-08

For various reasons, developers through the years have decided to store lists of data as comma-separated lists. Most programming languages include a split() function that allows you to break apart a list of data using a specified character. T-SQL does not.
I don't remember where I got this split function from. I know I didn't [...]

Also filed in Tutorials | Tagged , | Comments (2) »

Re-associate SQL users with logins

04-Jun-07

I've been getting our test environment in sync with our production environment the past week. Part of this effort involves moving database from our production environment to our test database server. The easiest way to do this is to put the production server into single-user mode, copy the .MDF and .LDF database files over to [...]

Also filed in Tutorials | | Comments (0) »

Language performance doesn’t matter when a database is involved

17-Apr-07

All of the latest Rails/Twitter performance bruhaha made me think about some advice I got a long time ago and that I dish out whenever someone asks me about some performance concerns they have with their code.
Nothing else matters once you hit the disk. Once you do any kind of activity that involves reading/writing to [...]

Also filed in General, PHP, Rails, Technology | | Comments (2) »

Bad things to hear from your DBA

06-Jul-05

It's not good to hear your DBA 'guru' answer "Good question" when he's been working for 2 months creating insert and update DTS packages for your application and you ask him "How can you tell if you are supposed to insert or update a given record in the source table?".
Especially when NOT being able [...]

Also filed in General | | Comments (0) »