The terminology tag has no wiki summary.
21
votes
7answers
1k views
What is the difference between a “record” and a “row” in SQL Server?
There was a rather innocuous question about adding dates and times in SQL Server that set off a rather fascinating taxonomic debate.
So how do we differentiate between these related terms and how we ...
2
votes
0answers
42 views
What is Transaction Path Analysis?
I came across the term Transaction Path Analysis which I am not familiar with. A Google search resulted in only a few results, most of which seem to assume everyone knows what it means. From these my ...
36
votes
14answers
1k views
Commonly Used Acronyms by Database Administrators
What are the most commonly used acronyms among database administrators and what are their correlated meanings?
0
votes
0answers
16 views
What's the proper term for the diverse systems to which a DW connects?
The data warehouse I've built gets data from transactional databases, web services, flat files, and a few other bits and pieces. It also writes back to some of these, and to analysis tools. I'm ...
1
vote
1answer
58 views
Is there a term for a table that has an “effective date” column?
I work with a system which uses a lot of tables whose primary keys include
a foreign key to another table and
a column indicating the date that record became/becomes "active".
Example tables:
...
4
votes
3answers
578 views
What do you call something that's not the primary key?
I've been working with a group who have built a system where they've coined a few new terms in the process, and I wanted to know if there's something more standardized they should be calling it.
...
2
votes
1answer
444 views
What are SQL Server Securables?
I migrated two applications to the new server. One of the them works without any issues but the other ran into back end sql permission problems like
The EXECUTE permission was denied on the ...
9
votes
3answers
3k views
What does horizontal scaling mean?
In database context, I have come across horizontal scalability as one of the advantages of the NOSQL databases. What does the term mean?
http://en.wikipedia.org/wiki/CouchDB
...
2
votes
1answer
152 views
What is a source table, and a target table?
I've seen alot of talk about source tables, and target tables on the internet, but no definitions of what these things are...from what I can infer it seems to mean something about copying data from an ...
10
votes
4answers
3k views
In SQL, is it composite or compound keys?
About SQL (Computing/Databases):
When we have two or more fields in a table that, together, identify its records uniquely, what's the proper way of calling them? Composite or compound keys?
I've ...
4
votes
1answer
530 views
What is Sql Server Clustered Index in Oracle terminology
A clustered index in sql server like a dictionary or telephone directory. A,B,C,D it goes on.
If you look up with a name Ozgur you start O then z etc.
I would like a simple explaination for this ...
8
votes
2answers
2k views
What is a heterogeneous query?
I got the following error message regarding a SQL query I'm running in a program. SQL Server 2005 T-SQL.
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the ...
3
votes
1answer
267 views
What scope(s) is “hasMany” a part of?
I realize, when talking about structures, obviously if you say "post hasMany comments" there are many records about comments relating to each post.
What I don't understand is what context these sort ...
6
votes
4answers
338 views
Is a Junction Table the same as a Weak Entity?
Is a Junction-Table basically just the table that sits between two entities that have a M-M relationship?
