.

• This reply was modified 3 years, 1 month ago by  water490.

I am super new to SQL Server. I downloaded it on the weekend and transferred over my Access queries.

You bring up an excellent point.  I will take a look at...

Thanks for the reply.

I was hoping to re-use the view in another query but I have changed plans so no need to create index on view.

Thank you everyone.  I have been saving the files to a folder.  it works for me because I only have a few queries. I am so used to Access so...

Thank you everyone for the replies.  I will take a look and implement.

Thank you so much!  That worked.

One thing about the CPU - a lot of SQL Server operations are single-threaded, so having a lot of cores may not benefit you.  There are exceptions (as queries...

• This reply was modified 3 years, 2 months ago by  water490.

Thank you for confirming!!

The links you provided are great.  Thank you for sharing!

The licensing costs are nuts for multi-core processors.  I am not a commercial business nor I do intend to sell anything...

• This reply was modified 3 years, 2 months ago by  water490.

Thank you!

Does the CPU type matter?  Xeon vs I7 etc?