Questions tagged [tempdb]
138 questions
0
votes
1 answer
Tempdb Full When Querying Distinct Count Of All Tables
ORIGINAL PROBLEM
I have created a custom script to retrieve data from a remote SQL server into our local copy in our office. I had some issues with the script where selected tables had some data inserted twice, thus creating duplicates. I know that…
Quarcheek
- 73
- 9
0
votes
1 answer
SQL Server : TempDB high number of writes
We use a SQL Server 2008 Web Edition on a Windows 2012 R2 server (32 GB RAM) to store data for an ASP.NET based web application. There are several dabases with news tables and different views which we query regularly (SqlDataReader, Linq-to-SQL)…
ALAdin
- 103
- 1
- 9
0
votes
0 answers
Should I monitor the SQL Server tempdb for user activity?
I am currently auditing all databases on SQL Server 2008 R2 for specific events. I get alot of events generated for tempdb.
Do I need to monitor tempdb or is it alright to exclude the tempdb?
Thanks for your help.
Potta Pitot
- 175
- 1
- 5
- 15
0
votes
2 answers
sql server free tempdb
We are running an import stored procedure in SQL Server 2008R2-SP1 that loads thousand of rows into several tables at a time. We are having problems with tempDB and transaction log size.
Something like this:
CREATE PROCEDURE…
GBrian
- 1,031
- 11
- 28
0
votes
0 answers
tsql query with defensive measure to prevent filling up tempdb
I recently wrote a query that, rather surprisingly, filled our tempdb. I was simply doing a string comparision on several thousand records, and I imagine because the strings where so long that the transactional data in the tempdb filled.
I would…
mgmedick
- 686
- 7
- 23
0
votes
1 answer
Why does LinqPad say a database it presents me with is an invalid object name?
Trying to detective out what is in a certain file ("HHS_WCE4.ARMV4.CAB"), I searched my hard drive for any references to that. One of the results Fileseek* was in C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Template…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
0
votes
1 answer
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.
How can I insert some records in to a temporary table?
I tried:
select * into TempDB.dba.#testing from testTable
But I got the following…
Sjemmie
- 1,249
- 8
- 26
- 31
0
votes
1 answer
Optimization problems with View using Clustered Index Insert on tempdb on SQL Server 2008
I am creating a Java function that needs to use a SQL query with a lot of joins before doing a full scan of its result. Instead of hard-coding a lot of joins I decided to create a view with this complex query. Then the Java function just uses the…
wfaria
- 31
- 7
0
votes
1 answer
BRKR TASK has 10GB in tempdb
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)
Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)
Millions of service broker conversations were not cleaned up properly and ended up using over 10GB in tempdb…
user3022874
- 1
- 2
0
votes
1 answer
why tempdb is throwing an error but still database having around of 5gb space
when we are working on the application, suddenly we got the error as pasted in above screen shot, we cannot able to perform any thing, but if i look into the database still the having 5 gb more space available, what could be the reason? kindly…
user1494292
- 399
- 1
- 5
- 14
0
votes
1 answer
SQL Server Tempdb goes over to 200GB
SQL Syntax as below
DELETE V From Table1 V
INNER JOIN Table2 AS A ON A.Col1 = V.Col1 AND A.Col2 = V.Col2
AND A.Col3 = V.Col3 And A.Col4 = V.Col4
AND A.Col5 = V.Col5 AND A.Col6 = V.Col6
Info for Table1:
Rows:…
Jigar
- 13
- 2
0
votes
3 answers
improve sql delete performance and reduce log file and tempDB size?
I have a huge database, it process the email traffic everyday. In the system, it needs delete some old emails everyday:
Delete from EmailList(nolock)
WHERE EmailId IN (
SELECT EmailId
FROM Emails
WHERE EmailDate < DATEADD([days],…
urlreader
- 6,319
- 7
- 57
- 91
0
votes
2 answers
What happens to data when running a query against a federated SQL Server?
SQL Azure give you an option to setup federated SQL servers - e.g. essentially partition your data across multiple servers by some key. However, when you run select * from order, it puts all the data back together for you and the entire process is…
AngryHacker
- 59,598
- 102
- 325
- 594
-1
votes
1 answer
SQL Server Masking not working - Does work on Temp DB
When I run the below code on a Temp database it does work, but not when I run it on a normal table. Very weird and not sure what I am missing.
CREATE TABLE #Test (Username VARCHAR(20))
insert into #Test (Username)
values ( 'Graham' ),( 'Bill'),(…
Etienne
- 7,141
- 42
- 108
- 160
-1
votes
2 answers
temp DB advice - Using Temporary tables
I am working a report, where in the result is combination of multiple #temp tables. Structure is as below
Stored procedure 1 which has a temp table which gives a 0.5 million rows
Stored procedure 2 which has a temp table which give 0.1 million…
Thomas_ITsavvy
- 9
- 2