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 5 years, 2 months ago by Lord Slaagh.
• This reply was modified 5 years, 2 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 5 years, 2 months ago by Lord Slaagh.

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

Stay safe folks!

Thanks for the quick response, but my company will never allow a trigger in master.

Do you know of any SQL 3rd party tools that handle something like this?

Hi Phil,

Nice to hear from you. We are actually waiting for approval on this, but for now I am looking for something quick and dirty.

Thanks for your responses as usual....