Click here to Skip to main content
14,333,806 members
   

Database

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 3:10
adminChris Maunder16-Jul-09 3:10 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 16:30
adminChris Maunder10-Nov-05 16:30 
QuestionHow do you separate in pages database results? Pin
Joan M6hrs 50mins ago
professionalJoan M6hrs 50mins ago 
QuestionMessage Closed Pin
16-Oct-19 22:05
memberbasimonica16-Oct-19 22:05 
QuestionI have a column and i need to find in which table this column exists throughout whole DB Pin
Anandkumar Prajapati8-Oct-19 19:29
professionalAnandkumar Prajapati8-Oct-19 19:29 
AnswerRe: I have a column and i need to find in which table this column exists throughout whole DB Pin
Victor Nijegorodov8-Oct-19 20:46
memberVictor Nijegorodov8-Oct-19 20:46 
AnswerRe: I have a column and i need to find in which table this column exists throughout whole DB Pin
Jörgen Andersson8-Oct-19 21:11
protectorJörgen Andersson8-Oct-19 21:11 
Questionvb.net connection to a firebird database Pin
Member 767827622-Sep-19 17:15
memberMember 767827622-Sep-19 17:15 
AnswerRe: vb.net connection to a firebird database Pin
Victor Nijegorodov22-Sep-19 20:12
memberVictor Nijegorodov22-Sep-19 20:12 
GeneralRe: vb.net connection to a firebird database Pin
Member 767827623-Sep-19 11:06
memberMember 767827623-Sep-19 11:06 
GeneralRe: vb.net connection to a firebird database Pin
Member 767827623-Sep-19 16:16
memberMember 767827623-Sep-19 16:16 
GeneralMessage Closed Pin
1-Oct-19 15:26
memberhayac h1-Oct-19 15:26 
QuestionMoving from access DB to Oracle to calculate average upon request Pin
Member 1447460719-Sep-19 11:12
memberMember 1447460719-Sep-19 11:12 
AnswerRe: Moving from access DB to Oracle to calculate average upon request Pin
Gerry Schmitz19-Sep-19 12:26
mveGerry Schmitz19-Sep-19 12:26 
QuestionMySQL database Pin
Alboyz17-Sep-19 16:46
memberAlboyz17-Sep-19 16:46 
AnswerRe: MySQL database Pin
#realJSOP18-Sep-19 1:08
mve#realJSOP18-Sep-19 1:08 
GeneralRe: MySQL database Pin
Alboyz18-Sep-19 16:58
memberAlboyz18-Sep-19 16:58 
AnswerRe: MySQL database Pin
Mycroft Holmes18-Sep-19 12:44
memberMycroft Holmes18-Sep-19 12:44 
GeneralRe: MySQL database Pin
Alboyz18-Sep-19 16:58
memberAlboyz18-Sep-19 16:58 
QuestionDatabase suddenly slow Pin
Super Lloyd17-Sep-19 15:39
memberSuper Lloyd17-Sep-19 15:39 
AnswerRe: Database suddenly slow Pin
CHill6018-Sep-19 0:05
protectorCHill6018-Sep-19 0:05 
GeneralRe: Database suddenly slow Pin
Super Lloyd18-Sep-19 20:47
memberSuper Lloyd18-Sep-19 20:47 
AnswerRe: Database suddenly slow Pin
Richard Deeming18-Sep-19 1:01
mveRichard Deeming18-Sep-19 1:01 
Check the execution plan. Check that you have the correct indexes on the tables. Try running Brent Ozar's First Responder Kit[^] on the server to see if there are any obvious errors.

You mention that the size of the data has increased. Does it now exceed the server's available memory? If it keeps having to go back to disk to load the data, then that can dramatically slow things down. Especially if the data isn't on an SSD.



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

GeneralRe: Database suddenly slow Pin
Super Lloyd18-Sep-19 20:47
memberSuper Lloyd18-Sep-19 20:47 
GeneralRe: Database suddenly slow Pin
Mycroft Holmes19-Sep-19 13:14
memberMycroft Holmes19-Sep-19 13:14 

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.