Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

What are real performance implications of using text instead of varchar types in MySQL?

sql mysql database varchar

Does SQL have a list type that can be used in a WHERE ... IN clause? [duplicate]

sql tsql

How to do a full outer join without having full outer join available

sql sap-ase full-outer-join

Partitioning Existing Tables

sql sql-server partitioning

What structure to use in database for virtual file system?

sql mysql filesystems

30 million records. Divy them up into 24 hourly-periods. Sum them for one month. Rinse and Repeat

sql sql-server tsql

Table-level diff and sync procedure for T-SQL

Is it possible to create a new T-SQL Operator using CLR Code in SQL Server?

How to select a limited amount of rows for each foreign key?

sql mysql

.NET: Allow NULLS in DB fields?

c# .net sql sql-server-2008 null

Query results taking too long on 200K database, speed up tips?

Bulk Insert multiple records and get identity for all using ADO.NET

How to use SQL - INSERT...ON DUPLICATE KEY UPDATE?

sql mysql

how to query with child relations to same table and order this correctly

sql mysql

SQL query: SUM values up to the current record

sql sql-server sum

Calculate differences between rows while grouping with SQL

sql postgresql grouping

How to define ENUM in SQL Server 2005? [duplicate]

sql generate unique table/view name

sql postgresql

Using Hibernate's Criteria and Projections to Select Multiple Distinct Columns

Best pattern for storing (product) attributes in SQL Server