Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««3,9253,9263,9273,9283,929»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Friday, March 29, 2013 1:34 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:12 AM
Points: 13,283, Visits: 10,157
WayneS (3/29/2013)
Koen Verbeeck (3/28/2013)
Totally unrelated - as usual in this topic - I got the MCSE Business Intelligence certificate today.
Because someone has to answer all those BI questions on this forum


AWESOME!

Congrats. Keep the answers flowing.


Thanks. You too Dwain, and all the others.

I'll keep the answers ELT'ing (notice the small yet crucial difference)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1437071
Posted Friday, March 29, 2013 3:27 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 7:29 PM
Points: 8,562, Visits: 9,063
Koen Verbeeck (3/29/2013)
WayneS (3/29/2013)
Koen Verbeeck (3/28/2013)
Totally unrelated - as usual in this topic - I got the MCSE Business Intelligence certificate today.
Because someone has to answer all those BI questions on this forum


AWESOME!

Congrats. Keep the answers flowing.


Thanks. You too Dwain, and all the others.

I'll keep the answers ELT'ing (notice the small yet crucial difference)

I noticed two differences.
First the differince between ETLing and ELTing - I have a reasonable understanding of what that is (although I haven't any real experience). Then the second difference: that "'". I haven't a clue what ELT'ing means. Unless it's just a weird spelling of ELTing - with the ' indicating missing "ransform", but then why wouldn't it be "E'L'T'ing"? .

BTW, that BI MCSE really is awesome. Or rather more than awesome.

edit: fix mess


Tom
Post #1437107
Posted Friday, March 29, 2013 3:34 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:41 PM
Points: 23,033, Visits: 31,555
L' Eomot Inversé (3/29/2013)
Koen Verbeeck (3/29/2013)
WayneS (3/29/2013)
Koen Verbeeck (3/28/2013)
Totally unrelated - as usual in this topic - I got the MCSE Business Intelligence certificate today.
Because someone has to answer all those BI questions on this forum


AWESOME!

Congrats. Keep the answers flowing.


Thanks. You too Dwain, and all the others.

I'll keep the answers ELT'ing (notice the small yet crucial difference)

I noticed two differences.
First the differince between ETLing and ELTing - I have a reasonable understanding of what that is (although I haven't any real experience). Then the second difference: that "'". I haven't a clue what ELT'ing means. Unless it's just a weird spelling of ELTing - with the ' indicating missing "ransform", but then why wouldn't it be "E'L'T'ing"? .

BTW, that BI MCSE really is awesome. Or rather more than awesome.

edit: fix mess


Yes, I did. You prefer to Extract, Load, then Transform rather than Extract, Transform, and then Load.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1437110
Posted Friday, March 29, 2013 4:07 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:41 PM
Points: 23,033, Visits: 31,555
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 specified period of time? Would any of you even recommend doing such a thing?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1437124
Posted Friday, March 29, 2013 4:29 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:41 PM
Points: 23,033, Visits: 31,555
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???



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1437133
Posted Friday, March 29, 2013 4:42 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 21,230, Visits: 14,940
Lynn Pettis (3/29/2013)
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???


Depends on the scope of the overhead. I posted a response on that thread that can qualify that statement.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1437136
Posted Friday, March 29, 2013 4:49 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:41 PM
Points: 23,033, Visits: 31,555
SQLRNNR (3/29/2013)
Lynn Pettis (3/29/2013)
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???


Depends on the scope of the overhead. I posted a response on that thread that can qualify that statement.


I saw. 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. But then it probably still runs just doesn't have a lot to do since the t-log is empty.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1437138
Posted Friday, March 29, 2013 4:59 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 21,230, Visits: 14,940
Lynn Pettis (3/29/2013)
SQLRNNR (3/29/2013)
Lynn Pettis (3/29/2013)
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???


Depends on the scope of the overhead. I posted a response on that thread that can qualify that statement.


I saw. 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. But then it probably still runs just doesn't have a lot to do since the t-log is empty.


Disagree. Since you can't backup tempdb - you don't have the extra overhead of those tables in a backup.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1437141
Posted Friday, March 29, 2013 5:09 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:46 PM
Points: 42,462, Visits: 35,525
Lynn Pettis (3/29/2013)
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???


Yes.
TempDB does less logging than user databases do. Since TempDB is never recovered, just cleared on startup, modifications to TempDB can log enough for the rollback process whereas user databases have to log enough for rollback and roll forward.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1437143
Posted Friday, March 29, 2013 5:11 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:46 PM
Points: 42,462, Visits: 35,525
Lynn Pettis (3/29/2013)
The only overhead not involved is the recovery process when SQL Server starts up.


Not quite, there is less logging overhead on data modifications. TempDB is optimised for lots of writing. Probably won't be enough to make a major difference in a process, but it is there.

But then it probably still runs just doesn't have a lot to do since the t-log is empty.


It doesn't run, the startup process copies the TempDB structures over from model after that has been recovered



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1437144
« Prev Topic | Next Topic »

Add to briefcase «««3,9253,9263,9273,9283,929»»»

Permissions Expand / Collapse