Thank you very much for clearing this up, Michael. Also, thank you to everyone on SSC who commented! I really, really appreciate it! This was very educational for me.

I will...

Thanks Voldemar. I'll save that query. I have researched DMV's, Query store and Data Collector, but my issue is that I am all theory when it comes to CPU, I/O,...

It sounds like Scott is saying 80-90% during business hours and you are saying 10-20% during business hours. I understand off hours, that makes complete sense, but during business hours...

Ok, so I am just trying to understand here. It looks like we are getting conflicting answers.

Fedrico said during business hours CPU should be between 10-20% max, but Scott said...

Thank you so much for your response. I worked with a DBA that said 99% CPU is ok because SQL Server hogs all the resources. That can't be right. That...

I have a major problem with ego-maniacs that like to hijack meetings. Which is what we had here. I asked for a few practice tests so I can prepare for...

Jeff - I am going to create another thread on this issue. Could you please do me a favor and NOT participate? I would really appreciate it.

• This reply was modified 4 years, 9 months ago by Lord Slaagh.
• This reply was modified 4 years, 9 months ago by Lord Slaagh.

I just noticed your script will fail. Did you not notice the red highlights. You didn't comment your code properly.

jcelko212 - That is a good point, but if you recall DDL definitions and constraints are not required in the spec of this practice test. Plus, this is not a...

Scott - I agree with Jeff in the sense that this test is somewhat unrealistic because you have CTE's and sub queries at your disposal. However, if this is a...

Scott - If you are not looking for the test results to be listed in a string, then I think this is what you are looking for.

create...

Completed script.

create table student_scores 
( 
student_id int NOT NULL,
score_date date NOT NULL, 
score int NOT NULL
);

insert into student_scores VALUES (1,'11/27/2020',80);
insert into student_scores VALUES (1,'12/01/2019',60);
insert into student_scores VALUES...

Acceptable data?

create table student_scores 
( 
student_id int NOT NULL,
score_date date NOT NULL, 
score int NOT NULL
);

insert into student_scores VALUES (1,'11/27/2020',80);
insert into student_scores VALUES (1,'12/01/2019',60);
insert into student_scores VALUES...

Thanks for this... A few questions.

Can you clarify the instructions? I will send you the script once I have completed it. I appreciate the help.

Not sure about the table structure....

• This reply was modified 4 years, 9 months ago by Lord Slaagh.

Thank you both for the recommendations. Nice to see you again Phil.

Stay safe folks!