tempdb
TempDB one physical datafiles per CPU core in SQL Server 2000
I know it is recommended for SQL 2005 onward but does it also apply on SQL Server 2000?开发者_运维知识库[详细]
2023-03-09 15:25 分类:问答SQL Concatenation filling up tempDB
We are attempting to concatenate possibly thousands of rows of text in SQL with a single query.The query that we currently have looks like this:[详细]
2023-03-05 16:43 分类:问答SQL Server 2008 TempDB on other HD
I would like to make all stuff related to TempDB be stored on a separate HD. I have this new HD with a 500 Gb size as my E:\\ drive.[详细]
2023-03-04 17:54 分类:问答SQL Server 2005 TempDB Size
We are using SQL Server 2005.Recently SQL server 2005 crashed in our production environment due to large tempdb size.[详细]
2023-02-16 07:47 分类:问答SQL 2005 tempdb growth and DTA syntax errors
I arrived at work to today to discover one of our SQL 2005 servers had run out of disk space. On examination the database causing the problem was tempdb. It seems to have grown from around 8mb to 16g[详细]
2023-01-23 18:10 分类:问答Why isn't SQL Server 2008 R2 using all available RAM?
We have an analytics database server running SQL 2008 R2 with 192 GB of physical RAM. However, we\'re noticing that during analytics process, the server only uses around 70 GB, bu开发者_C百科t tempdb[详细]
2023-01-14 12:59 分类:问答How to insert into a temporary table?
I\'m working with Sybase Central using Adaptive Server Anywhere 9 and I want some examples of how to use tempDB.[详细]
2022-12-19 10:30 分类:问答Size of SQL Server tempDB for Data Warehouse
Is there an expected size of tempDB for a Data Warehouse application. Is 10 gigs excessive? It\'s hit by frequent large queries.[详细]
2022-12-19 01:15 分类:问答Large query increases TempDB
I have huge query on my SQL 2005 Server. This have to be run once everyday but when this query runs temp db grows from 2GB to 48GB. What is the best way top optimize or find the reason why tempdb is g[详细]
2022-12-13 16:20 分类:问答Limiting SQL Temp DB Growth
I am facing a serious issue in my production server where the temp DB grow exponantialy. Is there any w开发者_如何学Goay we can recover the tempDB space without restarting the SQL service?[详细]
2022-12-11 17:27 分类:问答