4 Answered Questions
[SOLVED] How to identify which query is filling up the tempdb transaction log?
- 2012-06-25 14:49:54
- prasanth
- 160882 View
- 66 Score
- 4 Answer
- Tags: sql-server sql-server-2008 sql-server-2005 transaction-log tempdb
2 Answered Questions
[SOLVED] How to find the SQL statements that caused tempdb growth?
- 2012-02-25 06:26:25
- u23432534
- 57474 View
- 26 Score
- 2 Answer
- Tags: sql-server sql-server-2008 tempdb
1 Answered Questions
[SOLVED] Find transactions that are filling up the version store
- 2013-03-11 13:43:17
- a_horse_with_no_name
- 8163 View
- 6 Score
- 1 Answer
- Tags: sql-server sql-server-2005 tempdb tempdb-version-store
2 Answered Questions
[SOLVED] Find which session is holding which temporary table
- 2014-03-25 15:35:08
- SQLMIKE
- 22539 View
- 10 Score
- 2 Answer
- Tags: sql-server sql-server-2005 tempdb
1 Answered Questions
[SOLVED] how to find out what process(es) caused the autogrowth of a database or a database file?
- 2016-07-13 11:41:25
- Marcello Miorelli
- 2174 View
- 3 Score
- 1 Answer
- Tags: sql-server sql-server-2014 tempdb process
2 Answered Questions
[SOLVED] Issues with TempDB mdf file ever increasing
- 2014-01-13 19:56:24
- nightmareivy
- 12935 View
- 6 Score
- 2 Answer
- Tags: sql-server sql-server-2005 disk-space tempdb auto-growth
1 Answered Questions
[SOLVED] Tempdb Add files require Restart
- 2018-06-28 16:09:31
- user129291
- 2378 View
- 4 Score
- 1 Answer
- Tags: sql-server sql-server-2012 performance-tuning tempdb
1 Answered Questions
[SOLVED] Why does FREEPROCCACHE let you shrink tempdb?
- 2016-11-07 18:45:26
- James Jenkins
- 2912 View
- 1 Score
- 1 Answer
- Tags: tempdb shrink cache dbcc plan-cache
2 Answered Questions
[SOLVED] Splitting TempDB into multiples files equal to number of CPUs
- 2013-01-23 22:21:47
- Preet Sangha
- 9812 View
- 8 Score
- 2 Answer
- Tags: sql-server sql-server-2008-r2 storage tempdb disk-structures
3 Answered Questions
[SOLVED] Safely moving and creating new tempdb files
- 2012-07-11 18:49:10
- Stuart Blackler
- 24572 View
- 21 Score
- 3 Answer
- Tags: sql-server sql-server-2008-r2 tempdb
3 Answered Questions
[SOLVED] What are the most effective techniques to reduce SQL Server disk space use when updating all rows in a very large table?
- 2014-03-12 17:25:40
- BrianCooksey
- 10295 View
- 6 Score
- 3 Answer
- Tags: sql-server transaction-log tempdb
2 Answered Questions
[SOLVED] Tempdb autogrowth settings
- 2012-07-15 19:38:20
- Stuart Blackler
- 9858 View
- 4 Score
- 2 Answer
- Tags: sql-server tempdb
2 Answered Questions
[SOLVED] TempDB will not shrink. No Open Transactions
- 2014-08-06 16:27:43
- user45117
- 16342 View
- 8 Score
- 2 Answer
- Tags: sql-server-2008 tempdb shrink
1 Answered Questions
[SOLVED] Does RCSI use less or same space than SNAPSHOT? Why?
- 2013-12-13 08:35:34
- Fulproof
- 244 View
- 6 Score
- 1 Answer
- Tags: sql-server transaction tempdb snapshot-isolation tempdb-version-store
1 Answered Questions
[SOLVED] IO request time and less write latency
- 2015-05-07 13:44:46
- Zerotoinfinity
- 994 View
- 6 Score
- 1 Answer
- Tags: sql-server-2012 transaction-log tempdb compression
2 Answered Questions
[SOLVED] SQL Server tempdb on RAM Disk?
- 2017-01-13 03:43:36
- d-_-b
- 7411 View
- 11 Score
- 2 Answer
- Tags: sql-server tempdb
3 Answered Questions
[SOLVED] Sort spills to tempdb due to varchar(max)
- 2019-01-16 14:10:17
- Frederik Vanderhaegen
- 515 View
- 10 Score
- 3 Answer
- Tags: sql-server query-performance tempdb cardinality-estimates
1 Answered Questions
[SOLVED] What frequency of hash/sort spills into tempdb is concerning?
- 2014-06-02 16:19:58
- Matthew Rodatus
- 4511 View
- 10 Score
- 1 Answer
- Tags: sql-server performance tempdb
2 Answered Questions
[SOLVED] what is the best practice for tempdb autogrowth?
- 2018-01-25 14:03:16
- sql_girl
- 5520 View
- 7 Score
- 2 Answer
- Tags: sql-server t-sql disk-space tempdb auto-growth
2 Answered Questions
[SOLVED] Should I check for existence of temp tables in Stored Procedures?
- 2014-08-08 14:34:17
- Akash
- 6512 View
- 7 Score
- 2 Answer
- Tags: sql-server sql-server-2012 sql-server-2014 stored-procedures tempdb
3 Answered Questions
[SOLVED] How might a corrupt partition in TempDB result in DBCC CHECKDB reporting no issue?
- 2013-02-27 17:16:33
- Max Vernon
- 7744 View
- 8 Score
- 3 Answer
- Tags: sql-server sql-server-2012 tempdb dbcc-checkdb
2 Answered Questions
[SOLVED] TempDB Version Store cleanup
- 2013-07-08 17:07:34
- Cougar9000
- 7280 View
- 7 Score
- 2 Answer
- Tags: sql-server sql-server-2005 tempdb tempdb-version-store
3 Answered Questions
[SOLVED] Recommendations for more than one tempdb file
- 2016-12-22 19:34:57
- Rafaells
- 1494 View
- 6 Score
- 3 Answer
- Tags: sql-server sql-server-2012 tempdb
1 Answered Questions
How to find which query is causing tempdb growing?
- 2016-09-12 08:24:25
- Gianmatteo Stucchi
- 3265 View
- 2 Score
- 1 Answer
- Tags: sql-server tempdb
3 Answered Questions
[SOLVED] SQL Server 2008 R2 SP1 - Tempdb "Available free space" showing negative value
- 2013-03-27 17:35:35
- Chinesinho
- 10349 View
- 7 Score
- 3 Answer
- Tags: sql-server sql-server-2008 tempdb
2 Answered Questions
[SOLVED] SQL Server tempdb on SSD showing IO
- 2018-05-03 16:18:20
- G Devine
- 539 View
- 7 Score
- 2 Answer
- Tags: sql-server sql-server-2012 tempdb
3 Answered Questions
[SOLVED] Allocate space for object 'dbo.SORT temporary run storage
- 2017-01-18 14:43:00
- shamim
- 23549 View
- 6 Score
- 3 Answer
- Tags: sql-server sql-server-2008 tempdb dbcc-checkdb
1 Answered Questions
[SOLVED] Splitting SQL Server tempdb to use a second drive when first drive is full
- 2014-05-15 20:02:14
- Alton XL
- 535 View
- 4 Score
- 1 Answer
- Tags: sql-server tempdb
4 Answered Questions
[SOLVED] tempdb in sql server
- 2011-07-05 06:13:24
- Komal
- 4715 View
- 4 Score
- 4 Answer
- Tags: sql-server transaction-log sql-server-2000 tempdb
3 Answered Questions
[SOLVED] if block fails to create temp table in a procedure
- 2013-09-10 22:50:12
- Kermit
- 4123 View
- 3 Score
- 3 Answer
- Tags: sql-server t-sql ddl tempdb temporary-tables