August 26, 2011 at 5:22 am
Christi Wilson (8/25/2011)
Can someone point me to a good article on derived tables vs temp tables in regards to performance?I didn't want to start a whole new thread as this pertains to writing in my blog. I don't want to get into this but part of my illness wiped out a ton of my memory in every aspect of my life. That is about all I want to say about that.
Just remember, two different critters. Comparing apples to hammers.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 26, 2011 at 5:45 am
Grant Fritchey (8/26/2011)
Christi Wilson (8/25/2011)
Can someone point me to a good article on derived tables vs temp tables in regards to performance?I didn't want to start a whole new thread as this pertains to writing in my blog. I don't want to get into this but part of my illness wiped out a ton of my memory in every aspect of my life. That is about all I want to say about that.
Just remember, two different critters. Comparing apples to hammers.
True, Jack, but many people prefer to substitute one for the other in certain situations. For instance, I've found that, depending on the query, sometimes it works better for me to throw my derived table data into a temp table before the main query and just join on the temp. And vice-versa too. Sometimes the derived part of my JOIN works better than throwing the data into a temp table.
But they are two different critters, I will agree.
August 26, 2011 at 2:01 pm
GilaMonster (8/26/2011)
Christi Wilson (8/26/2011)
REPEATABLENot a keyword by itself and not new.
Thanks, I had never heard of it, so it was new to me. I did a search on new t-sql from 2000 to 2005 and somewhere it was in one of the articles. Granted it was around 4am and my eyes were blurry and my head swimming so it probably wasn't a good time to read articles. I went back to see where I had found that term as it came up in between 2 articles that I read here on SSC. I couldn't find it after I read your post, went through my history and for the life of me I cannot find where or why I had listed this. I even looked in BOL and cannot tell if I read it after putting terms I found into BOL to obtain a better understanding of the terms. I must be going crazy!
Thank you for bringing this to my attention, I appreciate any and all comments, even those that make me look like I don't know what I am talking about. 😛
August 26, 2011 at 2:13 pm
Christi Wilson (8/26/2011)
GilaMonster (8/26/2011)
Christi Wilson (8/26/2011)
REPEATABLENot a keyword by itself and not new.
Thanks, I had never heard of it, so it was new to me. I did a search on new t-sql from 2000 to 2005 and somewhere it was in one of the articles. Granted it was around 4am and my eyes were blurry and my head swimming so it probably wasn't a good time to read articles. I went back to see where I had found that term as it came up in between 2 articles that I read here on SSC. I couldn't find it after I read your post, went through my history and for the life of me I cannot find where or why I had listed this. I even looked in BOL and cannot tell if I read it after putting terms I found into BOL to obtain a better understanding of the terms. I must be going crazy!
To satisfy the curiosity...
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
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
August 26, 2011 at 2:18 pm
Thank you GilaMonster, you have saved my sanity 😛
August 26, 2011 at 5:12 pm
GilaMonster (8/26/2011)
Christi Wilson (8/26/2011)
GilaMonster (8/26/2011)
Christi Wilson (8/26/2011)
REPEATABLENot a keyword by itself and not new.
Thanks, I had never heard of it, so it was new to me. I did a search on new t-sql from 2000 to 2005 and somewhere it was in one of the articles. Granted it was around 4am and my eyes were blurry and my head swimming so it probably wasn't a good time to read articles. I went back to see where I had found that term as it came up in between 2 articles that I read here on SSC. I couldn't find it after I read your post, went through my history and for the life of me I cannot find where or why I had listed this. I even looked in BOL and cannot tell if I read it after putting terms I found into BOL to obtain a better understanding of the terms. I must be going crazy!
To satisfy the curiosity...
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
I'm sure that if I type that into an SSMS Query Window it will come out all in blue instead of 2 words blue, r words black, 1 word blue. Is this something weird that SQLSC does with code coloring?
Tom
August 27, 2011 at 3:01 am
Tom.Thomson (8/26/2011)
SET TRANSACTION ISOLATION LEVEL REPEATABLE READI'm sure that if I type that into an SSMS Query Window it will come out all in blue instead of 2 words blue, r words black, 1 word blue. Is this something weird that SQLSC does with code coloring?
Yeah, the syntax highlighting plugin for here is a little wonky sometimes.
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 7 posts - 76 through 81 (of 81 total)
You must be logged in to reply to this topic. Login to reply