Hello SSC,

This issue has been resolved, but it had nothing to do with the excel version. There was a step in the SSIS package that was renaming the excel file...

Hi Phil,

Nice to hear from you. I will try this. I hope you have a great holiday and stay safe!

250 is a lot for a fact table. I had a dimension table that had 573 columns. The problems encountered were during updates due to page splits. So...

Not sure I understand what you are saying Phil.

Ok, good point, we want to make sure that other developers have correct info. I gave the answer to Jeff. Please let me know if it's accurate.

This answers my question....

Thank you all very much for your responses! Mystery solved 🙂

Stay safe folks!

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