SQLMaestros

Пікірлер

@abhay6276 Күн бұрын

Sir you told us update statement causes fragmentation...last you ran update statement how did it executed fast.? Instead it increases fragmentation level...means whenever dml command execute the data stored on pages which are mis matching with logical order...please clear it 😊

@japspathak 2 күн бұрын

I liked your demo ❤

@erravipratapsingh8409 4 күн бұрын

Cross apply is doing index spool Create NCI on transaction table with all selected column and where clause And another CI on bigproduct table with productid as index key Index spool will be removed seek will start This way index spool is capturing the product table data everytime for each productid

@Ganeshay-996 7 күн бұрын

Link or how can we download

@tonyettah 11 күн бұрын

After 4 years, I recently came across this video Part 1 - How to Troubleshoot a Slow Running Query in SQL Server by Amit Bansal (Recorded Webinar). It has been incredibly helpful in resolving some long-standing issues I've been facing. I want to express my sincere gratitude for such a wonderful session with detailed explanations. Thank you so much - you’re truly the best in what you do.

@damodhardaamu9925 12 күн бұрын

Well said sir 😄

@jackylalo1 14 күн бұрын

Such a valuable webinar, thank you Satya, you explained all concepts regarding index in great detail, appreciate SQLMaestros !

@sumithreddy1032 14 күн бұрын

Informational video which made concept clear

@modusvivendi9038 15 күн бұрын

good content Bansal bhai.. kudos

@damodhardaamu9925 16 күн бұрын

Thank you so much sir 😊

@EvanderFrost-l9f 16 күн бұрын

thanks u sir,

@emadal-mousa8723 21 күн бұрын

Hi, first thanks for this informative video. Another good and quick approach is using "Microsoft SQL Server Performance Dashboard" in SQL Server Management Studio to check CPU utilization, in a real time fashion you will see a bar divided with two colors "orange" , "blue" ...it will indicate what is causing the high CPU utilization is it MSSQL engine "blue" OR another process in the operating system "orange". Thanks.... Emad Al-Mousa

@ManInTheFridge 28 күн бұрын

Block edit is nice I typically edit my syntax in VS code to do something like this

@gosinergya3125 28 күн бұрын

Great info

@dinsharma1409 Ай бұрын

Hi Amit, Please make a video, about facing access issue on folders when running sql services under 'NT Service\MSSQLServer', some time I can't even search name 'NT Service\MSSQLServer', when search to give permission on a folder. first install SQL 2022 and use SQL Service 'NT Service\MSSQLServer', once installed, try to move .mdf and .ldf files of system databases and use linked server and give folder access to another server. Thanks

@akbarmandozai6258 Ай бұрын

Awesome, Great Explanation

@safil747 Ай бұрын

Good idea, thanks.

@AnkitSingh-hi1rm Ай бұрын

Thank you for the detailed info..

@jiridolezalcz Ай бұрын

Nice tip. Many thanks!

@patelnayan1622 Ай бұрын

If we have more column in table and in UI we display that all column and user can sort any column from the UI so how to design index for that kind of scenario.

@Sri.lyricalsongs Ай бұрын

I am trying to fetching ad group members information in SQL server getting above error. How can I resolve this error....

@Sri.lyricalsongs Ай бұрын

Msg 15404, Level 16, State 4, Procedure xp_logininfo, Line 43 [Batch Start Line 0] Could not obtain information about Windows NT group/user 'XXXXXXX', error code 0x2147

@rlwsu Ай бұрын

Thank you very much.

@amarkude2719 Ай бұрын

Yes

@darrylw99 Ай бұрын

Where can i download this, yes you point to the website but where on there please

@lakshmipraneeth8162 Ай бұрын

Sorry Bro i dont have money

@beginnersbook2003 Ай бұрын

I have a doubt I created a table in that I mentioned only one column and insert lakhs of value in that column now if I want to show the data of a vertical column to horizontal each value contains separate cell ..... write a query for this for SQL server

@tiwari_deepak Ай бұрын

Use pivot table

@microsachin Ай бұрын

Create index idx3 on person.person (lastname) include (firstname, emailpromotion,PersonType);

@akbarmandozai6258 Ай бұрын

Wow, excellent explanation and thank you for sharing😊

@سلوان-ت4م Ай бұрын

تحفةةةةةةةةة

@MdSamiulIslam-e1i Ай бұрын

great :)

@SpaceMonkey23101 Ай бұрын

Actual content begins at 5:00

@ganeshk5471 Ай бұрын

very good! man

@shys6110 2 ай бұрын

Thanks for sharing this. Fantastic session

@yasirirfan5262 2 ай бұрын

good work.

@dipayansur9933 2 ай бұрын

Hello ❤

@ilkinbedelov7073 2 ай бұрын

In previous video about Extended Events you show problem that take more time in execution plan.How we could solve the problem using Extends Events.In you video you don't solve problem.Thanks.

@nikunjgajjar246 2 ай бұрын

Thank you .Great information

@maurotorres5675 2 ай бұрын

I once mentioned this to the Senior Database Manager at a company who supposedly had decades of experience. He laughed at me, shook his head annoyed and rudely said, "no why would it include the clustered indexing key automatically". I just walked away in order to avoid an argument. He wasnt my boss but my boss was almost as clueless. As a database developer almost all my bosses were just administrative positions who just set up meetings, did reviews, rambled a lot about obvious things , but didnt actually do any work. I really wish I had a boss like you who knew what he was talking about and I could learn from.