I want to create a table in MS SQL Server 2005 to record details of certain system operations. As you can see from the table design below, every column apart from Details is is non nullable.
I\'m trying to optimize my PostgreSQL 8.3 DB tables to the best of my ability, and I\'m unsure if I need to use varchar_pattern_ops for certain columns where I\'m performing a LIKE against the first N
If I have a column in table with field of type VARCHAR(15) and if I try to insert data of length 16, MySQL gives an error stating