I know it is recommended for SQL 2005 onward but does it also apply on SQL Server 2000?开发者_运维知识库
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:
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.
We are using SQL Server 2005.Recently SQL server 2005 crashed in our production environment due to large tempdb size.
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
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
I\'m working with Sybase Central using Adaptive Server Anywhere 9 and I want some examples of how to use tempDB.
Is there an expected size of tempDB for a Data Warehouse application. Is 10 gigs excessive? It\'s hit by frequent large queries.
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
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?
加载中,请稍侯......