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)