I gave the proposed logic CASE but I am open to anything.  If code has an error then return NULL else run the code

I was playing around with the query.  I figured out the problem.  The query didn't like the alias.  Once I removed the alias then it worked.  That is so odd...

Thank you so much!  it works now!!

Is anyone able to help me with this?

I used DBCC SHRINKFILE (1,0) to shrink the MDF file.  The size of the MDF file is about 20GB.  How long should this command take to run?  Should it be...

• This reply was modified 4 months, 2 weeks ago by water490.

I found queries to help

https://learn.microsoft.com/en-us/sql/relational-databases/databases/display-data-and-log-space-information-for-a-database?view=sql-server-ver16

How do I interpret the results?  I ran sp_spaceused to get this:

The MDF is close to 37GB and LDF is close...

Thanks for the reply.  Very helpful.

Is there a way to look at the system to see why the increase is happening?  A more "scientific" answer to figure out the root...

• This reply was modified 4 months, 2 weeks ago by water490. Reason: fixed a typo

You can export the data as text files as long as you re-import the files to check it goes smoothly. People often find commas in csv fields...

You can export the data as text files as long as you re-import the files to check it goes smoothly. People often find commas in csv fields or unescaped...

thanks for the feedback.

Just for my own learning...what order should these tasks be done in?

I am not sure...

• This reply was modified 5 months, 2 weeks ago by water490.

Instead of moving processed files to a single archive folder, create a timestamped folder in the target folder and move the file there.

You will never get collisions if you...

issue fixed.  Adding IS_MS_SHIPPED = 0 removes the SP in question.

I have made some progress on this.  I had to change the FROM table and now I can see the creation and last modified dates.  However, the query is showing...

Does encrypting the DB cause performance issues (ie run time increases) for queries?