Feeds:
Posts
Comments

Posts Tagged ‘SQL TempDB’

SQL SERVER – Reducing Page Contention on TempDB

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged , on January 26, 2011 | 4 Comments »

I have recently received following email. “We are using TraceFlag 1118 to reduce the tempDB contention on our servers (2000 and 2005). What is your opinion? We have read lots of material, would you please answer me in single line.” Wow, this was very interesting question. What intrigued me was the second last where I [...]

Read Full Post »

SQL SERVER – SQL Challenge – SQL Puzzle – Query Creating Most TempDB IO Usage

Posted in Best Practices, Database, Pinal Dave, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on October 27, 2010 | 13 Comments »

Recently, there have been a lot of interesting concepts in various challenges. My friend Jacob Sebastian is running the SQLQuiz for the entire month, and it has been very popular and going just great. So here I thought I would put something very similar to the quiz bee. The award here is simple, all valid [...]

Read Full Post »

SQL SERVER – How to Drop Temp Table – Check Existence of Temp Table

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged , on May 17, 2009 | 21 Comments »

I have received following questions numerous times: “How to check existence of Temp Table in SQL Server Database?” “How to drop Temp Table from TempDB?” “When I try to drop Temp Table I get following error. Msg 2714, Level 16, State 6, Line 4 There is already an object named ‘#temp’ in the database. How [...]

Read Full Post »

SQL SERVER – Fix : Error : Msg 2714, Level 16, State 6 – There is already an object named ‘#temp’ in the database

Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged on March 29, 2009 | 25 Comments »

Recently, one of my regular blog readers emailed me with a question concerning the following error: Msg 2714, Level 16, State 6, Line 4 There is already an object named ‘#temp’ in the database. This reader has been encountering the above-mentioned error, and he is curious to know the reason behind this. Here’s Rakesh’s email. [...]

Read Full Post »

SQL SERVER – Ideal TempDB FileGrowth Value

Posted in Pinal Dave, SQL, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on May 17, 2008 | 3 Comments »

Just a day ago, while installing SQL Server on our development machine Jr. DBA asked me what should be kept file growth of the TempDB. I really have not thought about this till moment and I looked at MS site. I found following answer and I think it is quite interesting. tempdb file size – [...]

Read Full Post »

Older Posts »