rdbms-agnostic

相关标签：javascript jquery android 多少钱 iPhone

What Applications Don't Need ACID?

Sorry for the ignorant question, but what kind of applications wouldn\'t require an ACID compliant database server?I have a SQL Server background where 开发者_如何转开发ACID has always \"been there\",[详细]

2023-02-28 09:34 分类：问答
Can an autoincrement ID ever change from the mid-transaction value upon commit?

The possibility of this happening seems extremely unlikely to me because of the problems it could cause, but I figured I\'d ask the question anyway...[详细]

2023-02-04 18:50 分类：问答
How to prevent deep recursive queries with entities consisting of entities of the same type? [Cool example inside]

No worries! It looks more complex than it actually is! Just get down to the drinks! TLDR-version: How to efficiently query and update entities having relationships to other entities?[详细]

2023-01-11 23:16 分类：问答
What performance gains can I expect from database paging?

Say I have a table X with 100 records in it and that running a select * from X takes 100 seconds. How long should I expect the query select top 10 * from X to ta开发者_运维百科ke?[详细]

2023-01-03 13:45 分类：问答
Do database engines other than SQL Server behave this way?

I have a stored procedure that goes something like this (pseudo code) storedprocedure param1, param2, param3, param4[详细]

2023-01-01 22:00 分类：问答
Database Optimization techniques for amateurs

Can we get a list of basic optimization techniques going (anything from modeling to querying, creating indexes, views to query optimization). It would be nice to have a list of these, one technique pe[详细]

2022-12-27 22:28 分类：问答
SQL join problem

I want to retrieve all records from one table when there are no matches in the second table. So 开发者_如何转开发it is kind of the opposite of an inner join.You need a LEFT JOIN WHERE IS NULL query ([详细]

2022-12-22 10:23 分类：问答
Why historically do people use 255 not 256 for database field magnitudes?

You often see database fields set to have a magnitude of 255 characters, what is the traditional / historic reason why? I assume it\'s something to do with paging / memory limits, and performance but[详细]

2022-12-21 03:25 分类：问答
SQL design for survey with answers of different data types

I am working on an online survey. Most questions have a scale of 1-5 for an answer. If we need to add a question to the survey, I use a simple web form, which does an INSERT into the appropriate table[详细]

2022-12-11 18:25 分类：问答
Do you use the OUTER keyword when writing left/right JOINs in SQL?

I often see people who write SQL like this: SELECT * from TableA LEFT OUTER JOIN TableB ON (ID1=I2) I myself write simply:[详细]

2022-12-11 07:52 分类：问答