Click here to Skip to main content
15,121,818 members
Home / Discussions / Database
   

Database

 
QuestionSQL Server: Retry update if fail Pin
Mou_kol8-Jan-21 5:22
MemberMou_kol8-Jan-21 5:22 
AnswerRe: SQL Server: Retry update if fail Pin
Richard Deeming8-Jan-21 5:49
mveRichard Deeming8-Jan-21 5:49 
QuestionSQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Mou_kol8-Jan-21 5:19
MemberMou_kol8-Jan-21 5:19 
AnswerRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Richard Deeming8-Jan-21 5:51
mveRichard Deeming8-Jan-21 5:51 
GeneralRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Mou_kol8-Jan-21 6:01
MemberMou_kol8-Jan-21 6:01 
GeneralRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Eddy Vluggen26-Jan-21 13:31
professionalEddy Vluggen26-Jan-21 13:31 
QuestionStoring Entity states in DB Pin
kabuto1787-Dec-20 17:31
Memberkabuto1787-Dec-20 17:31 
AnswerRe: Storing Entity states in DB Pin
Richard Deeming7-Dec-20 23:36
mveRichard Deeming7-Dec-20 23:36 
You're describing the "one true lookup table" anti-pattern. It's a bad idea.

Best practices for using Simple Lookup Tables[^]
Look-up Tables in SQL - Simple Talk[^]



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: Storing Entity states in DB Pin
Mycroft Holmes8-Dec-20 11:56
professionalMycroft Holmes8-Dec-20 11:56 
GeneralRe: Storing Entity states in DB Pin
kabuto1789-Dec-20 14:35
Memberkabuto1789-Dec-20 14:35 
QuestionResetting Value of Each User At Once (PHP MYSQLI) Pin
nateola444-Dec-20 23:14
Membernateola444-Dec-20 23:14 
QuestionRe: Resetting Value of Each User At Once (PHP MYSQLI) Pin
Richard MacCutchan5-Dec-20 0:05
mveRichard MacCutchan5-Dec-20 0:05 
QuestionThe Best Free Database for real-time data storing and querying Pin
Member 1332584625-Oct-20 21:04
MemberMember 1332584625-Oct-20 21:04 
AnswerRe: The Best Free Database for real-time data storing and querying Pin
Victor Nijegorodov25-Oct-20 22:39
MemberVictor Nijegorodov25-Oct-20 22:39 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Member 1332584627-Oct-20 23:17
MemberMember 1332584627-Oct-20 23:17 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Richard MacCutchan28-Oct-20 0:09
mveRichard MacCutchan28-Oct-20 0:09 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Member 1332584628-Oct-20 1:26
MemberMember 1332584628-Oct-20 1:26 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Jörgen Andersson28-Oct-20 3:15
professionalJörgen Andersson28-Oct-20 3:15 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Member 1332584629-Oct-20 19:47
MemberMember 1332584629-Oct-20 19:47 
AnswerRe: The Best Free Database for real-time data storing and querying Pin
Mycroft Holmes28-Oct-20 13:07
professionalMycroft Holmes28-Oct-20 13:07 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Member 1332584629-Oct-20 19:56
MemberMember 1332584629-Oct-20 19:56 
AnswerRe: The Best Free Database for real-time data storing and querying Pin
Gerry Schmitz30-Oct-20 9:40
mveGerry Schmitz30-Oct-20 9:40 
AnswerRe: The Best Free Database for real-time data storing and querying Pin
Eddy Vluggen26-Jan-21 13:36
professionalEddy Vluggen26-Jan-21 13:36 
QuestionDatabase ADO exception on adding new record Pin
Peter Mortier16-Oct-20 5:21
MemberPeter Mortier16-Oct-20 5:21 
GeneralRe: Database ADO exception on adding new record Pin
Richard MacCutchan16-Oct-20 5:53
mveRichard MacCutchan16-Oct-20 5:53 

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.