Click here to Skip to main content
15,846,899 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL behind the scenes Pin
jschell17-Jan-24 5:29
jschell17-Jan-24 5:29 
AnswerRe: SQL behind the scenes Pin
RedDk17-Jan-24 9:30
RedDk17-Jan-24 9:30 
AnswerRe: SQL behind the scenes Pin
Eddy Vluggen18-Jan-24 8:33
professionalEddy Vluggen18-Jan-24 8:33 
GeneralRe: SQL behind the scenes Pin
jschell19-Jan-24 5:52
jschell19-Jan-24 5:52 
QuestionRe: SQL behind the scenes Pin
Eddy Vluggen10-Feb-24 11:08
professionalEddy Vluggen10-Feb-24 11:08 
QuestionSql Server Database goes into Recovery mode Pin
Nilesh M. Prajapati17-Nov-23 18:59
Nilesh M. Prajapati17-Nov-23 18:59 
AnswerRe: Sql Server Database goes into Recovery mode Pin
Andre Oosthuizen18-Nov-23 8:35
mveAndre Oosthuizen18-Nov-23 8:35 
AnswerRe: Sql Server Database goes into Recovery mode Pin
Mycroft Holmes18-Nov-23 12:38
professionalMycroft Holmes18-Nov-23 12:38 
This design sound like a disaster waiting to happen - oh wait it has happened.
What possible reason would you create a new database for every months data?
I'd wager that the 50 column table is not normalised, leading to a myriad of problems down the track.

As to why the database falls into recovery mode, the Great Ghu only knows but given the above issues it is the least of your problems.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

AnswerRe: Sql Server Database goes into Recovery mode Pin
CHill6020-Nov-23 5:10
mveCHill6020-Nov-23 5:10 
AnswerRe: Sql Server Database goes into Recovery mode Pin
jschell20-Nov-23 8:48
jschell20-Nov-23 8:48 
QuestionSQLite Thread Safety Pin
Richard Andrew x6410-Nov-23 13:23
professionalRichard Andrew x6410-Nov-23 13:23 
AnswerRe: SQLite Thread Safety Pin
Gerry Schmitz10-Nov-23 15:04
mveGerry Schmitz10-Nov-23 15:04 
GeneralRe: SQLite Thread Safety Pin
Richard Andrew x6410-Nov-23 16:33
professionalRichard Andrew x6410-Nov-23 16:33 
GeneralRe: SQLite Thread Safety Pin
Gerry Schmitz13-Nov-23 12:14
mveGerry Schmitz13-Nov-23 12:14 
AnswerRe: SQLite Thread Safety Pin
Jörgen Andersson12-Nov-23 22:16
professionalJörgen Andersson12-Nov-23 22:16 
QuestionSQLite syntax error that I can't figure out - SOLVED Pin
Richard Andrew x644-Nov-23 15:09
professionalRichard Andrew x644-Nov-23 15:09 
AnswerRe: SQLite syntax error that I can't figure out Pin
k50544-Nov-23 18:22
mvek50544-Nov-23 18:22 
GeneralRe: SQLite syntax error that I can't figure out Pin
Richard Andrew x645-Nov-23 2:57
professionalRichard Andrew x645-Nov-23 2:57 
Questionplease Pin
daw htikehtike21-Oct-23 20:17
daw htikehtike21-Oct-23 20:17 
AnswerRe: please Pin
Richard MacCutchan21-Oct-23 22:14
mveRichard MacCutchan21-Oct-23 22:14 
AnswerRe: please Pin
jschell23-Oct-23 6:25
jschell23-Oct-23 6:25 
AnswerRe: please Pin
Gerry Schmitz24-Oct-23 8:15
mveGerry Schmitz24-Oct-23 8:15 
AnswerRe: please Pin
CHill6030-Oct-23 0:44
mveCHill6030-Oct-23 0:44 
QuestionGetting Last Record and First Record from a Record Set (SQL server DB) Pin
Member 1184335621-Sep-23 9:07
Member 1184335621-Sep-23 9:07 
AnswerRe: Getting Last Record and First Record from a Record Set (SQL server DB) Pin
Richard Andrew x6421-Sep-23 9:58
professionalRichard Andrew x6421-Sep-23 9:58 

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.