April 1, 2010 at 5:59 am
Grant Fritchey (4/1/2010)
I just have to share this one. I just got my idea for my next editorial (which, yes, I know Steve, is WAY overdue).
Editorial on free vs paid advice?
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
April 1, 2010 at 6:05 am
GilaMonster (4/1/2010)
Grant Fritchey (4/1/2010)
I just have to share this one. I just got my idea for my next editorial (which, yes, I know Steve, is WAY overdue).Editorial on free vs paid advice?
Darn, was it that easy to figure out? 😀
"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
April 1, 2010 at 6:25 am
Grant Fritchey (4/1/2010)
GilaMonster (4/1/2010)
Grant Fritchey (4/1/2010)
I just have to share this one. I just got my idea for my next editorial (which, yes, I know Steve, is WAY overdue).Editorial on free vs paid advice?
Darn, was it that easy to figure out? 😀
😀
I still need to finish mine on 'good questions'
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
April 1, 2010 at 6:34 am
Someone just quoted a reference at me on a thread to prove that table variables are faster than real temporary tables. The relevant extract from the 'reference' is:
"Temp tables are stored physically on disk in tempdb, while table variables are stored partially in memory and partially on disk. This difference means a few things for your code. Since table variables are at least partially in memory, they can be faster than temp tables."
Quoted from http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1280004,00.html - I hope that constitutes fair use. The site is member-only, so I had to join to view it (not many people know that my real name is Mr M. Mouse of Disneyland).
Given the recent discussions on certification and so on, it strikes me as apposite that the author of this published article has the following credentials:
MCSE, MCITP: Database Administrator, MCSD, current SQL Server MVP
:blink: :pinch: :doze:
Paul
April 1, 2010 at 6:38 am
Paul White NZ (4/1/2010)
Someone just quoted a reference at me on a thread to prove that table variables are faster than real temporary tables. The relevant extract from the 'reference' is:"Temp tables are stored physically on disk in tempdb, while table variables are stored partially in memory and partially on disk. This difference means a few things for your code. Since table variables are at least partially in memory, they can be faster than temp tables."
Quoted from http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1280004,00.html - I hope that constitutes fair use. The site is member-only, so I had to join to view it (not many people know that my real name is Mr M. Mouse of Disneyland).
Given the recent discussions on certification and so on, it strikes me as apposite that the author of this published article has the following credentials:
MCSE, MCITP: Database Administrator, MCSD, current SQL Server MVP
:blink: :pinch: :doze:
Paul
Interesting. I don't really know him... Not exactly a confidence building statement there.
"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
April 1, 2010 at 6:42 am
Paul White NZ (4/1/2010)
Someone just quoted a reference at me on a thread to prove that table variables are faster than real temporary tables. The relevant extract from the 'reference' is:"Temp tables are stored physically on disk in tempdb, while table variables are stored partially in memory and partially on disk. This difference means a few things for your code. Since table variables are at least partially in memory, they can be faster than temp tables."
Quoted from http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1280004,00.html - I hope that constitutes fair use. The site is member-only, so I had to join to view it (not many people know that my real name is Mr M. Mouse of Disneyland).
Given the recent discussions on certification and so on, it strikes me as apposite that the author of this published article has the following credentials:
MCSE, MCITP: Database Administrator, MCSD, current SQL Server MVP
:blink: :pinch: :doze:
Paul
There's no way I can see to comment on the article. Shame really because that shouldn't be alllowed to stand as written.
"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
April 1, 2010 at 6:50 am
Grant Fritchey (4/1/2010)
There's no way I can see to comment on the article. Shame really because that shouldn't be alllowed to stand as written.
I looked for that too - my frustration at not being able to comment was part of the reason I posted here.
April 1, 2010 at 7:22 am
Grant Fritchey (4/1/2010)
I just have to share this one. I just got my idea for my next editorial (which, yes, I know Steve, is WAY overdue).
The idea is: Stop asking stupid questions? 😛
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 1, 2010 at 7:28 am
Grant Fritchey (4/1/2010)
Paul White NZ (4/1/2010)
Someone just quoted a reference at me on a thread to prove that table variables are faster than real temporary tables. The relevant extract from the 'reference' is:"Temp tables are stored physically on disk in tempdb, while table variables are stored partially in memory and partially on disk. This difference means a few things for your code. Since table variables are at least partially in memory, they can be faster than temp tables."
Quoted from http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1280004,00.html - I hope that constitutes fair use. The site is member-only, so I had to join to view it (not many people know that my real name is Mr M. Mouse of Disneyland).
Given the recent discussions on certification and so on, it strikes me as apposite that the author of this published article has the following credentials:
MCSE, MCITP: Database Administrator, MCSD, current SQL Server MVP
:blink: :pinch: :doze:
Paul
There's no way I can see to comment on the article. Shame really because that shouldn't be alllowed to stand as written.[/quote
Hidden way down at the bottom og the page is a Rate this Article link, but you have to be registered and logged in to rate the article.
I recognize the author's name, but of course, Eric Johnson is a pretty common name.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 1, 2010 at 7:38 am
Jack Corbett (4/1/2010)
Grant Fritchey (4/1/2010)
Paul White NZ (4/1/2010)
Someone just quoted a reference at me on a thread to prove that table variables are faster than real temporary tables. The relevant extract from the 'reference' is:"Temp tables are stored physically on disk in tempdb, while table variables are stored partially in memory and partially on disk. This difference means a few things for your code. Since table variables are at least partially in memory, they can be faster than temp tables."
Quoted from http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1280004,00.html - I hope that constitutes fair use. The site is member-only, so I had to join to view it (not many people know that my real name is Mr M. Mouse of Disneyland).
Given the recent discussions on certification and so on, it strikes me as apposite that the author of this published article has the following credentials:
MCSE, MCITP: Database Administrator, MCSD, current SQL Server MVP
:blink: :pinch: :doze:
Paul
There's no way I can see to comment on the article. Shame really because that shouldn't be alllowed to stand as written.[/quote
Hidden way down at the bottom og the page is a Rate this Article link, but you have to be registered and logged in to rate the article.
I recognize the author's name, but of course, Eric Johnson is a pretty common name.
I saw the article rating thing and took advantage of it. 327 guess what I rated it.
"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
April 1, 2010 at 7:41 am
Grant Fritchey (4/1/2010)
I saw the article rating thing and took advantage of it. 327 guess what I rated it.
The overall average, despite our combined efforts, is still 4.33 out of 5...!
April 1, 2010 at 8:30 am
Grant, you ought to use that for an editorial. It's certainly something worth talking about.
April 1, 2010 at 8:35 am
From the "About The Author" section.
Eric is active in the local SQL Server Community, serving as the president of the Colorado Springs SQL Server Users Group.
Copyright 2007 TechTarget
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1280004,00.html
Hmmm.... who do we know in the neighborhood?
I also noticed that he was linking to an article by Denny Cherry which essentially makes the same incorrect statements about table variables. So it's a classic case of bad information being perpetuated. Hopefully, the discussion of the articles by their paying members clears that up.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 1, 2010 at 8:37 am
I couldn't resist. I just asked Paul Randal, on Twitter, if he wrote DBCC TimeWarp. 😛
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 1, 2010 at 9:03 am
Steve Jones - Editor (4/1/2010)
Grant, you ought to use that for an editorial. It's certainly something worth talking about.
On it. For sure this time.
"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
Viewing 15 posts - 13,696 through 13,710 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply