Are the posted questions getting worse?
- 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:
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - 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?
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/ - 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. 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Jeff Moden wrote: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? 😀
- Jeff Moden wrote: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 - Brandie Tarvin wrote:
Forget leading commas. Let's debate leading semi-colons. @=)
NO! Semicolons are TERMINATORS not BEGINNINGATORS!
- 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.
- 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.
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 - Jack Corbett wrote: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.
-
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Got the first post on a page again... and again, it's not showing up until another post (this one) is made.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Jeff Moden wrote:
Got the first post on a page again... and again, it's not showing up until another post (this one) is made.
I've seen that behaviour too.
-
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 -
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>
- Thom A wrote:
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 RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 66,166 through 66,180 (of 66,816 total)
You must be logged in to reply to this topic. Login to reply