Normalizing a Table with Low Integrity *

Question I've been handed a table with about 18000 rows. Each record describes the location of one customer. The issue is, that when the...

Read More

What's your opinion on using UUIDs as database row identifiers, particularly in web apps? *

Question I've always preferred to use long integers as primary keys in databases, for simplicity and (assumed) speed. But when using a R...

Read More

Issues using MS Access as a front-end to a MySQL database back-end? *

Question Two users wanted to share the same database, originally written in MS Access, without conflicting with one another over a single MD...

Read More

Inheritance in database? *

Question Is there any way to use inheritance in database (Specifically in SQL Server 2005)? Suppose I have few field like CreatedOn , C...

Read More

How do you persist a tree structure to a database table with auto incrementing IDs using an ADO.NET DataSet and a DataAdapter *

Question I have a self-referential Role table that represents a tree structure ID [INT] AUTO INCREMENT Name [VARCHAR] ParentID [INT] ...

Read More

Bigger than a char but smaller than a blob *

Question Char's are great because they are fixed size and thus make for a faster table. They are however limited to 255 characters. I wa...

Read More

Locking a SQL Server Database with PHP *

Question I'm wanting extra security for a particular point in my web app. So I want to lock the database (SQL Server 2005). Any suggesti...

Read More

What point should someone decide to switch Database Systems *

Question When developing whether its Web or Desktop at which point should a developer switch from SQLite, MySQL, MS SQL, etc Answer It dep...

Read More

MOSS SSP problem - Failed database logons from deleted SSP *

Question We've been having some issues with a SharePoint instance in a test environment. Thankfully this is not production ;) The probl...

Read More

SQL Case Statement Syntax? *

Question What is the complete and correct syntax for the SQL Case statement? Answer The complete syntax depends on the database engine y...

Read More

Simple MOLAP solution *

Question To analyze lots of text logs I did some hackery that looks like this Locally import logs into Access Reprocess Cube link t...

Read More

What program can I use to generate diagrams of SQL view/table structure? *

Question I've been tasked with redesigning part of a ms-sql database structure which currently involves a lot of views, some of which co...

Read More

Suggestions for implementing audit tables in SQL Server? *

Question One simple method I've used in the past is basically just creating a second table whose structure mirrors the one I want to aud...

Read More

SQLite vs MySQL *

Question SQLite is a single-file based database and MySQL is a normal database. That's great, but I'm not sure which is faster where...

Read More

How to Test Web Code? *

Question Does anyone have some good hints for writing test code for database-backend development where there is a heavy dependency on state?...

Read More

Is it better to create Model classes or stick with generic database utility class? *

Question We have a simple utility class in-house for our database calls (a light wrapper around ADO.NET), but I am thinking of creating clas...

Read More

Auto Generate Database Diagram MySQL *

Question I'm tired of opening Dia and creating a database diagram at the beginning of every project. Is there a tool out there that will...

Read More

Have you ever encountered a query that SQL Server could not execute because it referenced too many tables? *

Question Have you ever seen any of there error messages? -- SQL Server 2000 Could not allocate ancillary table for view or funct...

Read More

What is the best way to avoid SQL injection attacks? *

Question I've provided a solution for Python... please flesh this out with examples for other languages. Answer Oracle has got an exte...

Read More

What language do you use for PostgreSQL triggers and stored procedures? *

Question PostgreSQL is interesting in that it supports several languages for writing stored procedures. Which one do you use, and why? An...

Read More