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...

Sql server edition (express, standard, enterprise) - developer --- if you are using this for Production usage you CAN NOT use developer license - if it is only for...

those files you are getting.... can you answer the following.

• how many files per load
• how many rows per file (max, min and average size)
• how often you get...

why are you dropping and recreating the indexes? what are you trying to accomplish with it?

(for Phil - OP has DROP_EXISTING = ON so indexes are there already while...

Are you saying that this proc runs slower in SSIS than it would if you were running it from SSMS?

Have you determined which statement is the slow one (I...

Internet has a...

It would appear that a simple definition of what you want is as follows:

Return the last weekday of the month (regardless of any holidays).

To help others understand...

As you have not provided the logic for your 'business month end' calculation, I'm not sure how you are expecting anyone to calculate it.

EOMONTH() gives you end of month...