Questions tagged [database-agnostic]

Only use this tag when the question does not depend on a particular database management system.

No preference or requirements to answer for a particular database platform. Question may request a generic answer that covers multiple databases.

Per the question on allowing database-agnostic how to questions, a question that can be answered differently depending on the database management system (DBMS) should be asked in separate questions, one for each DBMS. This allows for a single correct answer. Sometimes the person asking may not realize that a question has different answers for different DBMSs. In these cases the question may need to be split or a DBMS-specific tag added and the database-agnostic tag removed.

76 questions
10
votes
2 answers

Which areas of a DBA's knowledge should a developer delve into?

I must admit the question is quite broad, so I'll try narrowing it down a bit. In our company we are 3-4 developers and have some SQL Server based installations running at our customer's sites (database sizes up to 100GB, up to 100 concurrent users,…
MicSim
  • 2,481
  • 1
  • 26
  • 26
4
votes
1 answer

database DDLs and implicit commit

I've been taught that in RDBMS any DDL always causes an implicit commit, ending any active transaction at the time the DDL is issued. Now I found this page on the PostgreSQL wiki that states that PostgreSQL is able to perform DDL statements in a…
watery
  • 386
  • 3
  • 17
2
votes
1 answer

Vertically align sql tool

Is there a tool out there that will take sql and align it vertically? what I have: SELECT first_name AS foo ,last_name AS bar ,ssn AS bas ,address AS chu FROM dbo.contacts; desired results or something similar to the statement…
2
votes
2 answers

Reason for NOT IN behaviour

sql> SELECT * FROM runners; +----+--------------+ | id | name | +----+--------------+ | 1 | John Doe | | 2 | Jane Doe | | 3 | Alice Jones | | 4 | Bobby Louis | | 5 | Lisa Romero | +----+--------------+ sql> SELECT * FROM…
user113659
  • 23
  • 1
  • 3
0
votes
1 answer

how to build statistical database?

According to the book I am reading, a statistical database is a database that permits queries that derive aggregated information but not queries that derive individual information. At current time, is it possible to build a statistical database? And…
Ju Ju
  • 127
  • 1
  • 1
  • 7