Tagged Questions
1
vote
2answers
102 views
SQL 2008 RTM Temp Tables
Today I implemented a monitoring solution on our SQL server using Cacti and the first thing i noticed is the growth in the number of temporary tables, in just 3 hours on our test system we had an ...
6
votes
3answers
619 views
Why is @temp table performance some times worse than #temp table performance?
I was recently working in a very slow stored procedure (took 5 minutes to run). I made a very small tweak from doing this:
declare @tempTable table
(
...
)
insert into @tempTable
select .....
to
...
0
votes
1answer
293 views
Performance problem caused by joining with the result of a scalar function?
In the following example the performance of the first version using only one SQL query is very bad. The problem is the last join.
When I store the result of the left side into a temporary table and ...
