Click here to Skip to main content
16,015,900 members
Home / Discussions / Database
   

Database

 
AnswerRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan1-Mar-22 22:45
mveRichard MacCutchan1-Mar-22 22:45 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff2-Mar-22 0:35
chipp_zanuff2-Mar-22 0:35 
GeneralRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan2-Mar-22 0:47
mveRichard MacCutchan2-Mar-22 0:47 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff2-Mar-22 23:37
chipp_zanuff2-Mar-22 23:37 
GeneralRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan2-Mar-22 23:44
mveRichard MacCutchan2-Mar-22 23:44 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff3-Mar-22 0:30
chipp_zanuff3-Mar-22 0:30 
GeneralRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan3-Mar-22 0:46
mveRichard MacCutchan3-Mar-22 0:46 
QuestionDetach database in SQL Server Pin
Meysam Toluie17-Feb-22 4:44
Meysam Toluie17-Feb-22 4:44 
Hello database experts,
In SQL Server is an option to update statistics before detaching a database, both using Transact-SQL and management studio wizard.
The purpose and advantage of updating statistics is clear.

My question is that, why should we update statistics before detaching a database? Is there any performance issue in recovery of database while attaching? or something else?
SignatureNotFoundException

QuestionWorks in MYSQL 5.7, Syntax Error in MYSQL 8.0 Pin
Douglas Kirk 202216-Feb-22 2:36
Douglas Kirk 202216-Feb-22 2:36 
AnswerRe: Works in MYSQL 5.7, Syntax Error in MYSQL 8.0 Pin
jschell17-Feb-22 11:37
jschell17-Feb-22 11:37 
GeneralRe: Works in MYSQL 5.7, Syntax Error in MYSQL 8.0 Pin
Douglas Kirk 202217-Feb-22 15:03
Douglas Kirk 202217-Feb-22 15:03 
SuggestionRe: Works in MYSQL 5.7, Syntax Error in MYSQL 8.0 Pin
Richard Deeming17-Feb-22 21:35
mveRichard Deeming17-Feb-22 21:35 
QuestionSQL Server Activity Monitor Pin
Meysam Toluie30-Jan-22 19:56
Meysam Toluie30-Jan-22 19:56 
AnswerRe: SQL Server Activity Monitor Pin
Meysam Toluie30-Jan-22 22:04
Meysam Toluie30-Jan-22 22:04 
QuestionGet all tables under a database in Postgre Pin
_Flaviu12-Jan-22 23:57
_Flaviu12-Jan-22 23:57 
AnswerRe: Get all tables under a database in Postgre Pin
Victor Nijegorodov13-Jan-22 6:05
Victor Nijegorodov13-Jan-22 6:05 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu13-Jan-22 6:45
_Flaviu13-Jan-22 6:45 
GeneralRe: Get all tables under a database in Postgre Pin
Victor Nijegorodov13-Jan-22 6:57
Victor Nijegorodov13-Jan-22 6:57 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu13-Jan-22 21:24
_Flaviu13-Jan-22 21:24 
GeneralRe: Get all tables under a database in Postgre Pin
Victor Nijegorodov13-Jan-22 21:28
Victor Nijegorodov13-Jan-22 21:28 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu14-Jan-22 0:01
_Flaviu14-Jan-22 0:01 
GeneralRe: Get all tables under a database in Postgre Pin
CHill6014-Jan-22 1:16
mveCHill6014-Jan-22 1:16 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu14-Jan-22 1:47
_Flaviu14-Jan-22 1:47 
GeneralRe: Get all tables under a database in Postgre Pin
Victor Nijegorodov14-Jan-22 2:05
Victor Nijegorodov14-Jan-22 2:05 
GeneralRe: Get all tables under a database in Postgre Pin
Tomas@PawSQL30-Aug-22 1:15
professionalTomas@PawSQL30-Aug-22 1:15 

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.