Click here to Skip to main content
15,510,281 members
Home / Discussions / Database
   

Database

 
AnswerRe: how a data base file works Pin
Eddy Vluggen21-Aug-22 2:30
professionalEddy Vluggen21-Aug-22 2:30 
GeneralRe: how a data base file works Pin
Calin Negru21-Aug-22 3:53
Calin Negru21-Aug-22 3:53 
GeneralRe: how a data base file works Pin
Eddy Vluggen21-Aug-22 5:03
professionalEddy Vluggen21-Aug-22 5:03 
GeneralRe: how a data base file works Pin
Calin Negru21-Aug-22 6:47
Calin Negru21-Aug-22 6:47 
GeneralRe: how a data base file works Pin
Eddy Vluggen21-Aug-22 6:57
professionalEddy Vluggen21-Aug-22 6:57 
GeneralRe: how a data base file works Pin
Calin Negru21-Aug-22 10:20
Calin Negru21-Aug-22 10:20 
GeneralRe: how a data base file works Pin
Eddy Vluggen22-Aug-22 9:04
professionalEddy Vluggen22-Aug-22 9:04 
GeneralRe: how a data base file works Pin
Eddy Vluggen22-Aug-22 9:22
professionalEddy Vluggen22-Aug-22 9:22 
For other readers, especially our younger ones;

Eddy Vluggen wrote:
A single entity; SQL Server allows for multiple files on multiple drives, but still represents your DB as a single file. You do not even have to care on what drive your record gets stored, that's a problem for the database.
Instead of querying the FS and reading files, you suddenly need not care.

All you need to care about is the SQL language to manage your data. That was small revolution!! And yes, it is a Data Abstraction Layer. It abstracts away the storing of data from the OS to a uniform platform that can be queried with the SQL language.
Bastard Programmer from Hell Suspicious | :suss:
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

QuestionOLE DB provider Pin
suren ramakrishnan18-Aug-22 22:16
suren ramakrishnan18-Aug-22 22:16 
AnswerRe: OLE DB provider Pin
Richard MacCutchan18-Aug-22 22:31
mveRichard MacCutchan18-Aug-22 22:31 
AnswerRe: OLE DB provider Pin
RedDk19-Aug-22 14:14
RedDk19-Aug-22 14:14 
QuestionReplacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik7-Aug-22 5:00
Nick Katditsik7-Aug-22 5:00 
AnswerRe: Repacing back-end MS-ACCESS with SQL SERVER Pin
Mycroft Holmes7-Aug-22 13:44
professionalMycroft Holmes7-Aug-22 13:44 
GeneralRe: Repacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik8-Aug-22 6:42
Nick Katditsik8-Aug-22 6:42 
AnswerRe: Repacing back-end MS-ACCESS with SQL SERVER Pin
Richard Deeming7-Aug-22 22:50
mveRichard Deeming7-Aug-22 22:50 
GeneralRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik17-Aug-22 6:07
Nick Katditsik17-Aug-22 6:07 
GeneralRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
Craig Robbins17-Aug-22 7:53
Craig Robbins17-Aug-22 7:53 
AnswerRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
CHill6017-Aug-22 8:00
mveCHill6017-Aug-22 8:00 
GeneralRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik17-Aug-22 20:46
Nick Katditsik17-Aug-22 20:46 
QuestionHow would you... (synchronization between 2 databases) Pin
Joan M6-Aug-22 8:18
professionalJoan M6-Aug-22 8:18 
AnswerRe: How would you... (synchronization between 2 databases) Pin
Gerry Schmitz6-Aug-22 9:06
mveGerry Schmitz6-Aug-22 9:06 
GeneralRe: How would you... (synchronization between 2 databases) Pin
Joan M6-Aug-22 13:08
professionalJoan M6-Aug-22 13:08 
AnswerRe: How would you... (synchronization between 2 databases) Pin
Mycroft Holmes6-Aug-22 13:48
professionalMycroft Holmes6-Aug-22 13:48 
Questionsql query problem Pin
pitwi28-Jul-22 0:06
pitwi28-Jul-22 0:06 
AnswerRe: sql query problem Pin
Richard Deeming28-Jul-22 0:54
mveRichard Deeming28-Jul-22 0:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.