Видео

Hi Erik , will that query work with SQL 2019?

Cool way to get "under the hood" while the car is going down the highway 😎 Was there a resolution to the single-threaded Index (Eager Spool) operation that would have actually run in parallel like the other Clustered Index operation?

Should there be a significant execution time difference between the serial v Parallel version? the serial ran in 1m 23s and the parallel in 1m 18s

1:11 No love for GetPlans = 2?

The best SQL Server training on internet (EDD) could use some links to these too many great videos as complementary material ;)

What's impressive is you not only have to put in all the effort and research to discuss a topic, you also have to intentionally craft queries that demonstrate the problems related to it.

Darling for President!

Is it a bug - or is it a feature??😂😂😂😂

I feel a powerful urge to do more Postgres. How strange.

*slaps the enterprise level Ferrari, You can fit SO much garbage code in this bad boy

Me: Where DocDate = '20241018' SQL server: English, other ducker Doo. you speak it? Me: Where DocDate >= '20241018' And DocDate < '20241019' Sql Server: See it wasn't that hard, was it?

At last, an antidote to Brent's arrogasms.

Lets us accept the fact that Erik is the Michael Jordan of performance tuning and Brent is, well I am open to ideas.

providential video, I was just having a problem of "I, sql server command, I create unquestionable plans" when instead there are indexes that he does not want to use

Much better! Of course, with the real-sized Stack database, getting that query to finish 20 times would be quite an ordeal....

We need to find a way to get a third video on this... Maybe we need to get Erik to rant about features that aren't available on Standard Edition. I'm pretty sure this is one of them.

With the focus on fairness, maybe it's time to update your slogan to "my rates are reasonably fair."

Useful, many thanks. I wonder if there is any possibility for automation or code-smell-checking? Developer is a human beeing not fully concentrated for all of the details that should be met everytime.

Awesome Erik! Updated my tips repo 🤫

Anyone complaining about long videos has obviously never spent hours troubleshooting code, only to find that the code is fine but the datatypes act differently under different collations.

Pay no attention to the name of the stored procedure. It is surely not making fun of anybody! Great video 😀

Man I love you,I love Brent I love Kendra...you guys are my hero ! 9 years as a DBA now and since day 1 I'm with Brent and Kendra and I remember when you joined the team. thanks for everything !

That's epic 😂

*"Oh gosh, it sounds like real trouble, it sounds like a job....for Darling Data"* .... (I know, I know, it's in jest). Entertaining though. Hope he gets you back

Awww, man, c'mon, that's not fair - you used a different query, hahaha. The video was begging people to get automatic tuning to work for that particular query in the post.

Exec dbo.MicrosoftCertifiedMaster - you are a cruel person, Mr Darling 😂😂😂

As i always suspected, you're way smarter than Brent

from what I learned, the reason why it says 13.x seconds is because it is the sum of the number of seconds for each thread running in parallel. please correct me if im wrong

I want your datalength!

Long videos are like second breakfast-there's always more than you expect!

I dont have an issue with your length. You are long enough lol seriously though who is actually complaining about 15 minute videos?

Is that “live Elvis entertainment “?

Don't shorten your videos too much or I'll have to shorten my lunch break accordingly 😁 Erik, are you ever concerned the Unicode strings take twice as much storage as non-Unicode? If you will never (well, never say never, right??) have Unicode characters, is it worth the storage overhead?

When making a dynamic SQL string using multiple NVARCHAR(MAX) variables why does it sometimes not take more than 4K characters? Did any1 else face this issue here? On stack overflow I read it's due to 8K page size. But it happens only on some complex dynamic queries and I am not able to recreate it in simple scenarios.

It’s about how rounded it is

Hi, how long this 75% discount is available, I am planning to buy this in the 1st week of November, if it is still available at that time. thank you for a generous offer!

:

Shorts from Erik. O tempora, o mores!

I like it!

Whats your go to metric when gauging query performance?

Why is there no sort operator in the Query Plan at 07:55? Of course it uses the Index on the descending reputation first, but it should still need to order by the ascending Id column - except reputation is unique (in the higher ranges), but even with statistics the SQL server can't know/guarantee this, so it would need to sort. A possible reason would, if the ID is the clustered Index and SQL server guarantees, that rows would always be implizit ordered by Reputation DESC + Id ASC, even when the Id is not specified in the CREATE INDEX (the columns of clustered Index will always be included, but I in my opinion unsorted.)

So covert! Didn't think of you as that sneaky 🤣🤣

i do like devious and mischievous things...

Very interesting, what database are you using for your testing? Is it stack exchange?

My brain is mush now watching this

We went the fancy route and wrote our own code scanner with ScriptDom that gets run as part of the build pipeline. If the developer used anything smelly, we block the PR. Lol

One of my greatest pains in life is the comment from the developer "No I am 100% certain that my code is not causing any blocking because I put NOLOCK hints on all my SELECTs. So it must be something else."

I am going to add this to my toolkit. Thanks!

Kronos Quartet Plays. Chanting circle of dudes "String to String!"

Hi Erik, I replayed the same queries on my box and I have a different result, the first query (with fetch) took 10 seconds on the first run (4.2M pages read from disk), 2 seconds the next run. The second query with the row_number function was not faster altough batch mode was used. I double checked the execution plans and they are exactly the same as yours. Am I missing something? PS I use PoorMansTSqlFormatter for my formatting 🙂, and thanks for all these unforgettable parties 🥳🥳🥳