March 29, 2013 at 8:36 am
SQLRNNR (3/29/2013)
jasona.work (3/29/2013)
Steve Jones - SSC Editor (3/28/2013)
jasona.work (3/28/2013)
Anyone thinking of going to see the popcorn movie that is "GIJoe: Retaliation"?I'm debating between waiting until tomorrow, or going to see it tonight on my own, then tomorrow with the wife...
Yes, I'm a nut.
Last weekend, we did "Olympus has fallen" then "The Croods" the next day...
Wife and son saw it last night. My wife doesn't usually love those kinds of movies, but she said it was enjoyable. Not much plot (cartoon like were her words), but great effects and scenes.
I want to go now.
It's a movie, based on a cartoon / comic book made to sell toys, that were based on older toys...
A cartoon in which despite firing hundreds of rounds per-episode at near point-blank range, no one EVER got hit (or at least not seriously)
Sadly, I didn't get to see it last night, but will be going tonight...
Jason
Well, they were lasers. And they did have them set to "slight jolt" 😀
Now I want to drag out some of my old 80's GI Joe Marvel comics and see if:
A) Anybody ever got hit (I think they did)
B) Fatally? (Except the generic COBRA troopies, I think a picture of one of them is in the dictionary under "cannon fodder")
😀
March 29, 2013 at 10:10 am
jasona.work (3/29/2013)
SQLRNNR (3/29/2013)
jasona.work (3/29/2013)
Steve Jones - SSC Editor (3/28/2013)
jasona.work (3/28/2013)
Anyone thinking of going to see the popcorn movie that is "GIJoe: Retaliation"?I'm debating between waiting until tomorrow, or going to see it tonight on my own, then tomorrow with the wife...
Yes, I'm a nut.
Last weekend, we did "Olympus has fallen" then "The Croods" the next day...
Wife and son saw it last night. My wife doesn't usually love those kinds of movies, but she said it was enjoyable. Not much plot (cartoon like were her words), but great effects and scenes.
I want to go now.
It's a movie, based on a cartoon / comic book made to sell toys, that were based on older toys...
A cartoon in which despite firing hundreds of rounds per-episode at near point-blank range, no one EVER got hit (or at least not seriously)
Sadly, I didn't get to see it last night, but will be going tonight...
Jason
Well, they were lasers. And they did have them set to "slight jolt" 😀
Now I want to drag out some of my old 80's GI Joe Marvel comics and see if:
A) Anybody ever got hit (I think they did)
B) Fatally? (Except the generic COBRA troopies, I think a picture of one of them is in the dictionary under "cannon fodder")
😀
You could pull the old cartoons up on netflix :w00t:
Wish the new spinoff would have lasted longer than it did (Renegades)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 29, 2013 at 10:13 am
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.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
March 29, 2013 at 10:17 am
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.
Err - don't you mean "Keep the answers ETLing"?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 29, 2013 at 12:01 pm
jasona.work (3/29/2013)
SQLRNNR (3/29/2013)
jasona.work (3/29/2013)
Steve Jones - SSC Editor (3/28/2013)
jasona.work (3/28/2013)
Anyone thinking of going to see the popcorn movie that is "GIJoe: Retaliation"?I'm debating between waiting until tomorrow, or going to see it tonight on my own, then tomorrow with the wife...
Yes, I'm a nut.
Last weekend, we did "Olympus has fallen" then "The Croods" the next day...
Wife and son saw it last night. My wife doesn't usually love those kinds of movies, but she said it was enjoyable. Not much plot (cartoon like were her words), but great effects and scenes.
I want to go now.
It's a movie, based on a cartoon / comic book made to sell toys, that were based on older toys...
A cartoon in which despite firing hundreds of rounds per-episode at near point-blank range, no one EVER got hit (or at least not seriously)
Sadly, I didn't get to see it last night, but will be going tonight...
Jason
Well, they were lasers. And they did have them set to "slight jolt" 😀
Now I want to drag out some of my old 80's GI Joe Marvel comics and see if:
A) Anybody ever got hit (I think they did)
B) Fatally? (Except the generic COBRA troopies, I think a picture of one of them is in the dictionary under "cannon fodder")
😀
Which reminds me of a joke:
What are the three words you'll never hear an Imperial Stormtrooper say?
"I got one!"
Jason Wolfkill
March 29, 2013 at 1:34 pm
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)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 29, 2013 at 3:27 pm
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"? :w00t: .
BTW, that BI MCSE really is awesome. Or rather more than awesome.
edit: fix mess
Tom
March 29, 2013 at 3:34 pm
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"? :w00t: .
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. 😉
March 29, 2013 at 4:07 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 specified period of time? Would any of you even recommend doing such a thing?
March 29, 2013 at 4:29 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:42 pm
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 29, 2013 at 4:49 pm
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.
March 29, 2013 at 4:59 pm
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 29, 2013 at 5:09 pm
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 29, 2013 at 5:11 pm
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 39,256 through 39,270 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply