February 8, 2023 at 6:30 pm
frederico_fonseca wrote:Jeff Moden wrote:Grant Fritchey wrote:Jeff Moden wrote:David Burrows wrote:Jeff Moden wrote:David Burrows wrote:Thatโs why I like you Jeff, youโre such a smart guy ย ๐๐ฅณ
Heh... if I were really smart, I'd just up and retire.ย That would probably kill me though.
Just like me ๐, glad I didnโt. Youโll out live us all ๐ youโre an institution you know ๐
I think most folks would say your confused, David.ย They rather think I should be IN an institution. ๐ ๐ ๐
Second!!
All in favor?
And you know I'm kidding.
Kidding??? Why??? We were going to invite you to join us! ๐ ๐ ๐
by the looks of it WE are ALL in one already (SSC)
I think we could get a group rate at a sanitarium.
Scratch that... They should pay us for the entertainment value! ๐ ๐ D:
--Jeff Moden
Change is inevitable... Change for the better is not.
February 8, 2023 at 6:35 pm
Michael L John wrote:frederico_fonseca wrote:Jeff Moden wrote:Grant Fritchey wrote:Jeff Moden wrote:David Burrows wrote:Jeff Moden wrote:David Burrows wrote:Thatโs why I like you Jeff, youโre such a smart guy ย ๐๐ฅณ
Heh... if I were really smart, I'd just up and retire.ย That would probably kill me though.
Just like me ๐, glad I didnโt. Youโll out live us all ๐ youโre an institution you know ๐
I think most folks would say your confused, David.ย They rather think I should be IN an institution. ๐ ๐ ๐
Second!!
All in favor?
And you know I'm kidding.
Kidding??? Why??? We were going to invite you to join us! ๐ ๐ ๐
by the looks of it WE are ALL in one already (SSC)
I think we could get a group rate at a sanitarium.
Scratch that... They should pay us for the entertainment value! ๐ ๐ D:
Are you saying they can put a fence around us, and charge admission?ย Like DBA Disneyland?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
February 8, 2023 at 6:40 pm
Jeff Moden wrote:Michael L John wrote:frederico_fonseca wrote:Jeff Moden wrote:Grant Fritchey wrote:Jeff Moden wrote:David Burrows wrote:Jeff Moden wrote:David Burrows wrote:Thatโs why I like you Jeff, youโre such a smart guy ย ๐๐ฅณ
Heh... if I were really smart, I'd just up and retire.ย That would probably kill me though.
Just like me ๐, glad I didnโt. Youโll out live us all ๐ youโre an institution you know ๐
I think most folks would say your confused, David.ย They rather think I should be IN an institution. ๐ ๐ ๐
Second!!
All in favor?
And you know I'm kidding.
Kidding??? Why??? We were going to invite you to join us! ๐ ๐ ๐
by the looks of it WE are ALL in one already (SSC)
I think we could get a group rate at a sanitarium.
Scratch that... They should pay us for the entertainment value! ๐ ๐ D:
Are you saying they can put a fence around us, and charge admission?ย Like DBA Disneyland?
Yes... and you must be at least this tall to enter.ย ๐
--Jeff Moden
Change is inevitable... Change for the better is not.
February 8, 2023 at 9:41 pm
Michael L John wrote:Jeff Moden wrote:Michael L John wrote:frederico_fonseca wrote:Jeff Moden wrote:Grant Fritchey wrote:Jeff Moden wrote:David Burrows wrote:Jeff Moden wrote:David Burrows wrote:Thatโs why I like you Jeff, youโre such a smart guy ย ๐๐ฅณ
Heh... if I were really smart, I'd just up and retire.ย That would probably kill me though.
Just like me ๐, glad I didnโt. Youโll out live us all ๐ youโre an institution you know ๐
I think most folks would say your confused, David.ย They rather think I should be IN an institution. ๐ ๐ ๐
Second!!
All in favor?
And you know I'm kidding.
Kidding??? Why??? We were going to invite you to join us! ๐ ๐ ๐
by the looks of it WE are ALL in one already (SSC)
I think we could get a group rate at a sanitarium.
Scratch that... They should pay us for the entertainment value! ๐ ๐ D:
Are you saying they can put a fence around us, and charge admission?ย Like DBA Disneyland?
Yes... and you must be at least this tall to enter.ย ๐
Unless we're already inside, and I think some of us are. Hey, at least we know we're in a box, right? ๐
February 8, 2023 at 10:27 pm
Michael L John wrote:Jeff Moden wrote:Michael L John wrote:frederico_fonseca wrote:Jeff Moden wrote:Grant Fritchey wrote:Jeff Moden wrote:David Burrows wrote:Jeff Moden wrote:David Burrows wrote:Thatโs why I like you Jeff, youโre such a smart guy ย ๐๐ฅณ
Heh... if I were really smart, I'd just up and retire.ย That would probably kill me though.
Just like me ๐, glad I didnโt. Youโll out live us all ๐ youโre an institution you know ๐
I think most folks would say your confused, David.ย They rather think I should be IN an institution. ๐ ๐ ๐
Second!!
All in favor?
And you know I'm kidding.
Kidding??? Why??? We were going to invite you to join us! ๐ ๐ ๐
by the looks of it WE are ALL in one already (SSC)
I think we could get a group rate at a sanitarium.
Scratch that... They should pay us for the entertainment value! ๐ ๐ D:
Are you saying they can put a fence around us, and charge admission?ย Like DBA Disneyland?
Yes... and you must be at least this tall to enter.ย ๐
Well, I guess I'm ruled out.
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
February 8, 2023 at 10:54 pm
Jack Corbett wrote:Not dropping temp tables at the end of stored procedures is one of the pre-requisites to take advantage of the tempdb improvements made to limit metadata contention in tempdb, https://learn.microsoft.com/en-us/archive/blogs/sql_server_team/tempdb-files-and-trace-flags-and-updates-oh-my#metadata-contention.ย I've seen this contention at a couple of clients in the last year and have had to recommend code changes so that they could get those benefits.
Oops, this wasย reply to Lynn's comment about dropping/not dropping temp tables at the end of stored procedures and it has been so long since I've posted I forgot that you have to do Quote not Reply to include the post you are replying in your post.
Thanks, but the article I read was a blog post that I still can't find.
February 8, 2023 at 11:05 pm
Jack Corbett wrote:Jack Corbett wrote:Not dropping temp tables at the end of stored procedures is one of the pre-requisites to take advantage of the tempdb improvements made to limit metadata contention in tempdb, https://learn.microsoft.com/en-us/archive/blogs/sql_server_team/tempdb-files-and-trace-flags-and-updates-oh-my#metadata-contention.ย I've seen this contention at a couple of clients in the last year and have had to recommend code changes so that they could get those benefits.
Oops, this wasย reply to Lynn's comment about dropping/not dropping temp tables at the end of stored procedures and it has been so long since I've posted I forgot that you have to do Quote not Reply to include the post you are replying in your post.
Thanks, but the article I read was a blog post that I still can't find.
Sure,ย I was just trying to supply a reason why NOT dropping temp tables in stored procedures can be a performance boost.ย I've never practiced explicitly dropping temp tables in stored procedures because they are dropped at the end of execution anyway and are execution specific, so I never found a reason to drop.
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
February 9, 2023 at 12:22 am
Lynn Pettis wrote:Jack Corbett wrote:Jack Corbett wrote:Not dropping temp tables at the end of stored procedures is one of the pre-requisites to take advantage of the tempdb improvements made to limit metadata contention in tempdb, https://learn.microsoft.com/en-us/archive/blogs/sql_server_team/tempdb-files-and-trace-flags-and-updates-oh-my#metadata-contention.ย I've seen this contention at a couple of clients in the last year and have had to recommend code changes so that they could get those benefits.
Oops, this wasย reply to Lynn's comment about dropping/not dropping temp tables at the end of stored procedures and it has been so long since I've posted I forgot that you have to do Quote not Reply to include the post you are replying in your post.
Thanks, but the article I read was a blog post that I still can't find.
Sure,ย I was just trying to supply a reason why NOT dropping temp tables in stored procedures can be a performance boost.ย I've never practiced explicitly dropping temp tables in stored procedures because they are dropped at the end of execution anyway and are execution specific, so I never found a reason to drop.
Old programming habits die hard. Just something that carried over when I started working with MS SQL Server way back in the 6.5 days.
February 9, 2023 at 4:13 am
According to Paul White (and what I heard early on when they first started meta-caching of Temp Tables), dropping the tables does NOT prevent caching of Temp Table meta-data.
https://sqlperformance.com/2017/05/sql-performance/sql-server-temporary-object-caching
I will admit that it's a waste of code space unless, like I said before, you're using a really big Temp Table and you just want to free up some space in TempDB because you're done with the large temp table but your proc isn't done yet.ย It's still going to have the meta-data cached.ย You could also just truncate the table to do the same thing.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 9, 2023 at 4:14 am
Got the first post on a page again... and again, it's not showing up until another post (this one) is made.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 9, 2023 at 11:14 am
Shifting gears a bit, I'm hoping this year that work will be happy to pay (or at least contribute) to me getting out and going to some SQL based events this year; it's something I've been trying to get out of them for a while, and it seems that the badgering is finally bearing some fruit.
Now that things are mostly back to normal, after lockdowns, etc, I'm hoping that there will be some choice this year, however, does anyone have any particular ones that they would recommend, and know (or hope) are going ahead this year for someone who's UK based? I'm, personally, happy to travel more or less anywhere within the country, but I'm based near London if they helps or changes any of your recommendations.
If you do know of any big events over in Europe give them a shout too, but I suspect I might find it harder for work to pay outright (but if it's a good event, and I can get them to contribute, then it might still be on the cards for me).
Thanks for any ideas you might have.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 9, 2023 at 1:14 pm
Talking about ChatGPT, has anyone seen this one yet? https://www.cnn.com/2023/02/08/tech/google-ai-bard-demo-error/index.html
<headdesk>
February 9, 2023 at 1:19 pm
Shifting gears a bit, I'm hoping this year that work will be happy to pay (or at least contribute) to me getting out and going to some SQL based events this year; it's something I've been trying to get out of them for a while, and it seems that the badgering is finally bearing some fruit.
Now that things are mostly back to normal, after lockdowns, etc, I'm hoping that there will be some choice this year, however, does anyone have any particular ones that they would recommend, and know (or hope) are going ahead this year for someone who's UK based? I'm, personally, happy to travel more or less anywhere within the country, but I'm based near London if they helps or changes any of your recommendations.
If you do know of any big events over in Europe give them a shout too, but I suspect I might find it harder for work to pay outright (but if it's a good event, and I can get them to contribute, then it might still be on the cards for me).
Thanks for any ideas you might have.
SQLBits, but call for speakers closed months ago. That's the big one in the UK. Next is Relay. The call for speakers probably opens late spring. After that, Data Ceilie (sp?) in Ireland and then various Data & SQL Saturday events.
I can list some in europe too if you want.
"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 - 66,166 through 66,180 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply