Sql

Is there an advantage to varchar(500) over varchar(8000)?

performance-optimization

database-design

Compare dates in T-SQL, ignoring the time part

date-comparisons

sql-performance

Sql Server 2005 - Export table programmatically (run a .sql file to rebuild it)

Sql - Search String Starts With

query-efficiency

full-text-search

Best way to delete millions of rows by ID

database-optimization

performance-tuning

data-management

Display an array in a readable/hierarchical format

data-formatting

How can I reorder rows in SQL database

database-management

data-organization

Postgresql Get a random datetime/timestamp between two datetime/timestamp

Oracle: SQL query to find all the triggers belonging to the tables?

trigger-management

database-administration

How to create a new database with the hstore extension already installed?

prompt-engineering

Pl/sql block problem: No data found error

exception-handling

How do I select a 1 as a bit in a sql-server view?

prompt-engineering

Mysql: ERROR 1215 (HY000): Cannot add foreign key constraint

foreign-key-constraints

database-performance

Postgresql GROUP BY different from MySQL?

mysql-comparison

Entity Framework error: Cannot insert explicit value for identity column in table

entity-framework

database-design

Sql Query If Parameter Is Null Select All

database-performance

sql-optimization

Error message: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

connection-protocol

Column calculated from another column?

Sql Server equivalent to Oracle's NULLS FIRST?

data-manipulation

Does it make sense to use an index that will have a low cardinality?

performance-benefits

database-optimization

explain.codes / Sql