7:00 No, I'm at least 73% certain this will actually throw error "Subquery returned more than one value". Also, you have two statements that look like they should be in the IF block, but only the print actually is.
Can you please provide link/details for sorting data from application ? If my table has million of records and needs sorting. What do you suggest sorting in app or in DB? I am not really convinced how application sorting will work since normally there is a pagination associated and application would recieve limited amount of data from Database.
@@TheBrentOzar yes i know...but my qs is will they be effecient in sorting millions of records? Since sorting would be done on the entire table not just on 50 -100 records on the page. Also i would have to provide entire data to application in such scenario.
11 years passed it's still precious. tks for sharing
Our pleasure!
@@BrentOzarUnlimited You are a true GEM Brent. Your videos are like finding a treasure from a ocean.
7:00 No, I'm at least 73% certain this will actually throw error "Subquery returned more than one value".
Also, you have two statements that look like they should be in the IF block, but only the print actually is.
Thanks!
Removing unsed indexes. Can you give us link to that script pls
Sure, Google for sp_BlitzIndex.
Can you please provide link/details for sorting data from application ? If my table has million of records and needs sorting. What do you suggest sorting in app or in DB?
I am not really convinced how application sorting will work since normally there is a pagination associated and application would recieve limited amount of data from Database.
If you Google for how to sort data (and your preferred programming language), there are a ton of resources.
@@TheBrentOzar yes i know...but my qs is will they be effecient in sorting millions of records? Since sorting would be done on the entire table not just on 50 -100 records on the page.
Also i would have to provide entire data to application in such scenario.
@@huzischannel That means you're doing a TOP, and as I say in the video, sorting as fine as long as your query has a TOP 50-100.
Not using top but i am using offset and fetch for pagination. Any suggestion for further performance enhancement?
Thank you so much for replying.
Is this in 2019 (now 2020) still actual?
Richard van Dommelen can you be more specific?