Viewing 5 posts - 1 through 5 (of 5 total)
Yes this helps and it's a very useful query. thanks Jeff!
September 3, 2020 at 4:27 pm
Thanks Jason and Jeff. Yes I didn't explain it very clear.
Basically, I am trying trying to return the number of logical reads (from the sys.dm_exec_query_stats.total_logical_reads) for the last query that...
September 1, 2020 at 2:17 pm
Identifying results meaning...
Given a sample database schema and DML query provided, I have to come up with the results of the sample query.
This is a section of the exam and...
July 17, 2020 at 7:31 pm
Are there any indexes on the table? what is the execution plan ? If the table does not have any non-clustered index, it will have to scan the table.
You could...
September 1, 2019 at 5:06 pm
You need to include more information. Do you have any code at all? What are the table structures? Where is the team amount column?
September 1, 2019 at 4:56 pm
Viewing 5 posts - 1 through 5 (of 5 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy