Viewing 15 posts - 8,236 through 8,250 (of 26,490 total)
The only overhead not involved is the recovery process when SQL Server starts up. It doesn't have to run the redo/undo process on tempdb since it is recreated on startup....
March 29, 2013 at 4:51 pm
SQLRNNR (3/29/2013)
Lynn Pettis (3/29/2013)
The advantage to tempdb is that there is less overhead writing data there since SQL "knows" it never has to recover tempdb....
March 29, 2013 at 4:49 pm
SQLRNNR (3/29/2013)
Lynn Pettis (3/29/2013)
ScottPletcher (3/29/2013)
The advantage to tempdb is that there is less overhead writing data there since SQL "knows" it never has to recover tempdb.
Really? Last I heard...
March 29, 2013 at 4:46 pm
And now for something completely different:
The advantage to tempdb is that there is less overhead writing data there since SQL "knows" it never has to recover tempdb.
OMG! Really???
March 29, 2013 at 4:29 pm
ScottPletcher (3/29/2013)
The advantage to tempdb is that there is less overhead writing data there since SQL "knows" it never has to recover tempdb.
Really? Last I heard all updates, deletes,...
March 29, 2013 at 4:16 pm
tercou1 (3/29/2013)
Hi SerajThanks for the quick reply... That worked perfectly... Much appreciated
Thank you
I'm curious, what school do you attend?
March 29, 2013 at 4:09 pm
I have a question, two actually. Does anyone here create permanent tables in tempdb for ETL or ELT processes that needs to keep data for multiple processes for a...
March 29, 2013 at 4:07 pm
Seraj Alam-256815 (3/29/2013)
select Customers.idCustomers , count(*)from Customers
INNER JOIN Meters ON Customers.idCustomers = Meters.Customers_idCustomers
group by Customers.idCustomers having count(*)>1
Or:
select
c.idCustomers
from
dbo.Customers c
cross...
March 29, 2013 at 3:55 pm
david.holley (3/29/2013)
Lynn Pettis (3/29/2013)
March 29, 2013 at 3:46 pm
rajarshi_ghosh_05 (3/29/2013)
Lynn Pettis (3/29/2013)
And if you create a permanent table, it makes sense to create it in the database it is used, not in tempdb.
That's true but there are several...
March 29, 2013 at 3:36 pm
L' Eomot Inversé (3/29/2013)
Koen Verbeeck (3/29/2013)
WayneS (3/29/2013)
Koen Verbeeck (3/28/2013)
Because someone has to answer all...
March 29, 2013 at 3:34 pm
It is possible and it works. I did this at a previous employer where I separated information into two separate tables. The idea was to allow for future...
March 29, 2013 at 3:31 pm
And if you create a permanent table, it makes sense to create it in the database it is used, not in tempdb.
March 29, 2013 at 3:22 pm
I saw something similar also, but I'm not sure it was from this OP. I can't find the post either.
March 29, 2013 at 1:57 pm
Unfortunately, we can't see what you see. You have posted no code (the stored procedure, the CREATE TABLE statements for the table or tables it uses, sample data, expected...
March 29, 2013 at 1:56 pm
Viewing 15 posts - 8,236 through 8,250 (of 26,490 total)