Click here to Skip to main content
15,354,313 members
Home / Discussions / Database
   

Database

 
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
MemberMeysam Toluie17-Feb-22 4:44 
QuestionWorks in MYSQL 5.7, Syntax Error in MYSQL 8.0 Pin
Douglas Kirk 202216-Feb-22 2:36
MemberDouglas Kirk 202216-Feb-22 2:36 
AnswerRe: Works in MYSQL 5.7, Syntax Error in MYSQL 8.0 Pin
jschell17-Feb-22 11:37
Memberjschell17-Feb-22 11:37 
GeneralRe: Works in MYSQL 5.7, Syntax Error in MYSQL 8.0 Pin
Douglas Kirk 202217-Feb-22 15:03
MemberDouglas 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
MemberMeysam Toluie30-Jan-22 19:56 
AnswerRe: SQL Server Activity Monitor Pin
Meysam Toluie30-Jan-22 22:04
MemberMeysam Toluie30-Jan-22 22:04 
After some extra research I found a complete list of state from different sources:

Running - The session is running one or more batches. When Multiple Active Result Sets (MARS) is enabled, a session can run multiple batches. For more information, see Using Multiple Active Result Sets (MARS).
Background - The session is running a background task, such as deadlock detection.
Rollback - The session has a transaction rollback in the process.
Pending - The session is waiting for a worker thread to become available.
Runnable - The session's task is in the runnable queue of a scheduler while waiting to get a time quantum.
Spinloop - The session's task is waiting for a spinlock to become free.
Suspended - The session is waiting for an event, such as I/O, to complete.
Sleeping - A session in the sleeping state means a client connection without an active query.
Dormant - SQL Server is resetting the session. Same as Sleeping, except Dormant also indicates that the SPID has been reset after completing an RPC event. (Replication SPIDs show "DORMANT" when waiting.)

For more information about other columns see:

SQL Server Activity Monitor

I hope it helps others.
SignatureNotFoundException

QuestionGet all tables under a database in Postgre Pin
_Flaviu12-Jan-22 23:57
Member_Flaviu12-Jan-22 23:57 
AnswerRe: Get all tables under a database in Postgre Pin
Victor Nijegorodov13-Jan-22 6:05
MemberVictor Nijegorodov13-Jan-22 6:05 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu13-Jan-22 6:45
Member_Flaviu13-Jan-22 6:45 
GeneralRe: Get all tables under a database in Postgre Pin
Victor Nijegorodov13-Jan-22 6:57
MemberVictor Nijegorodov13-Jan-22 6:57 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu13-Jan-22 21:24
Member_Flaviu13-Jan-22 21:24 
GeneralRe: Get all tables under a database in Postgre Pin
Victor Nijegorodov13-Jan-22 21:28
MemberVictor Nijegorodov13-Jan-22 21:28 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu14-Jan-22 0:01
Member_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
Member_Flaviu14-Jan-22 1:47 
GeneralRe: Get all tables under a database in Postgre Pin
Victor Nijegorodov14-Jan-22 2:05
MemberVictor Nijegorodov14-Jan-22 2:05 
AnswerRe: Get all tables under a database in Postgre Pin
Richard MacCutchan13-Jan-22 23:39
mveRichard MacCutchan13-Jan-22 23:39 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu14-Jan-22 0:06
Member_Flaviu14-Jan-22 0:06 
GeneralRe: Get all tables under a database in Postgre Pin
Richard MacCutchan14-Jan-22 0:13
mveRichard MacCutchan14-Jan-22 0:13 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu14-Jan-22 3:32
Member_Flaviu14-Jan-22 3:32 
QuestionList all tables from a specific database Pin
_Flaviu12-Jan-22 0:41
Member_Flaviu12-Jan-22 0:41 
AnswerRe: List all tables from a specific database Pin
Peter_in_278012-Jan-22 1:18
professionalPeter_in_278012-Jan-22 1:18 
GeneralRe: List all tables from a specific database Pin
_Flaviu12-Jan-22 1:35
Member_Flaviu12-Jan-22 1:35 

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.