SQL Server Performance Tuning and Query Optimization | Sql Server Interview Question Part 01 | sql

HOW TO WRITE QUERY TO INCREASE THE PERFORMANCE BY ROW NUMBER

For Quiz-

Find Us On FaceBook-

[dharmendradwivedi]

Nice video, Helpful for performance tunning

[prameeSri]

Thank you sir, second method is really cool..

[goluSingh-suxs]

Nice way to explain things very easy to
Thanks...

[sathishgoud]

nice nice videos for learners keep it dude..

[anjukumari]

What you have explained that's really awesome. ...
Keep it up...

[merealfaazmeripehchaan]

please make it a practice to copy the source or provide a link. It will be really helpful for everyone who want to practice.

[manjunathreddy]

Hi, your videos are very informative :). Please also try to share the queries and files/material which you use here, so that we can also practice along with you. Thanks.

[shreddersengupta]

Great video.
One question, isnt Windowing with partitioning has same performance with same group by ?

[somasreebiswas]

nice video, please do provide input as well.
create table accounthistory
(
membernbr int,
acctnbr int,
Entrydate date,
amount numeric(14, 2)
);
insert into accounthistory
select 1, 1, '2018-07-29', 150
union
select 1, 1, '2018-07-30', 140
union
select 2, 1, '2018-07-29', 260
union
select 2, 1, '2018-07-31', 480
union
select 2, 2, '2018-07-28', 150
union
select 3, 3, '2018-07-25', 560

[Dharmendrakumar-bgor]

The way of explaining is very good but for practice please give the table schema

[allaboutdata]

nice video, but what if we have row num as 1, 2, 3, 4 how you would select ? where you can not directly use rownum=1

[ravipaul]

i have a question.
why we using CTe or Derived table for filter the row, i know error will comes if we use where clause in base query, can you tell me what could be the reason behind error.

[saikrishnareddy]

How to achieve the same result using group by

[dibyanshukumar]

can you provide link of Bank of America Sql question

[rajeshkumar]

Simple way write to delete duplicate data