sure thing no problem.

I have attached an Excel sheet with sample data and expected outcome.  In case you prefer to not download file then here is a screenshot with description. ...

• This reply was modified 1 year, 6 months ago by water490.
• This reply was modified 1 year, 6 months ago by water490.
• This reply was modified 1 year, 6 months ago by water490.
• This reply was modified 1 year, 6 months ago by water490.

thank you both!  i know how to fix my query now because of your feedback.  thank you again for the help!!

thank you it worked!

this is super interesting.  i didn't know that.

this begs the question....how do you decide on an appropriate index?  is there a good resource you can suggest that goes over the...

• This reply was modified 1 year, 6 months ago by water490.

does it make sense that an unindexed query is faster than an indexed one?

thank you everyone.  What recommended  settings for parallelism should I set SS to?  Clearly the defaults are not recommended.

thanks everyone!

Yes expected.

The download site also states that v19 will not uninstall or change v18 in anyway.

https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16#download-ssms

The SSMS 19.x installation doesn't upgrade or replace SSMS versions 18.x or earlier. SSMS...

thank you everyone for your feedback.

I found this setting for the DB:

Look at that max size!  so huge!  If I change that to say 1GB max then...

For the data, do you do deletes of the data? Are the tables all have a clustered index?  Are any of them heaps?

Database design can play a strong factor...

OK, so lets tackle the log problem first. As you say its a hobby and no criticality if something went wrong with the DB, then you could most likely...

Seems a little excessive, a 600GB log for a 17.5GB data space.

But without knowing the workload we cannot give you a definitive answer.  But something caused the log to...

The problem in  your original statement is that your calc -- CHARINDEX('^',RIGHT(UNDERLYING_SYMBOL, LEN(UNDERLYING_SYMBOL) - CHARINDEX('^', UNDERLYING_SYMBOL))) -- involves only numeric values, so the result is numeric.  Since it's being...

thank you everyone for your replies.  very helpful

i am going to disable that component and see how it affects SSIS run time.  i will do this for the next...

thank you everyone for your replies.  very helpful

i am going to disable that component and see how it affects SSIS run time.  i will do this for the next few...