Timeline for Why does my hard-drive fill up when executing a query?
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 19, 2016 at 15:32 | history | edited | marc_s | CC BY-SA 3.0 |
deleted 1 character in body
|
| Jun 17, 2016 at 17:46 | answer | added | paparazzo | timeline score: 1 | |
| Jun 17, 2016 at 16:05 | answer | added | Eric Swiggum | timeline score: 0 | |
| Jun 17, 2016 at 16:03 | history | edited | Martin Smith | CC BY-SA 3.0 |
edited title
|
| Jun 17, 2016 at 15:53 | answer | added | T L | timeline score: 0 | |
| Jun 17, 2016 at 15:52 | comment | added | Kin Shah |
What is the your database recovery model ? Is the query a select only query (you are reading data) or a insert/update/delete (you are modifying the data) query ?
|
|
| Jun 17, 2016 at 15:50 | comment | added | Jonathan Fite | In memory if it can, but typically spills over to TempDB, especially for large/complex queries. If your query updates/inserts/deletes then the log file will also be potential place. You can check this by right clicking on the database in question, then reports, then Standard Reports then Disk Usage. There should be a section (you need to expand it) that has data file growth events. You can use this to confirm which database. | |
| Jun 17, 2016 at 15:44 | history | asked | Adam | CC BY-SA 3.0 |