Yes, you are correct in everything you wrote. TableA and TableB are separate entities. Yes, this is a bad practice because it violates normalization rules. I would very...

thanks and btw this is not for searching. Is for support of our software application and is all internal stuff. So there are only 4 branches/queries in the IF...

This is for a commercial software install so the stored procedures will not be changing except for system upgrades. So if the SPs do not change after the initial install...

Thanks for the suggestions but as far as I know

1. sending app has a connection to read the data but selects one row at a time and returns out of...

After thinking about this for a minute I was a little confused about why everyone is trying to use a ranking function when the data is already 'rankable' via the...

Yeah, I basically understand all that and thanks for the information. Needless to say I will be working on my maintenance scripts this afternoon. I was just surprised that...

Thanks for the suggestion. I updated the statistics on the tables used in the query and it came back to normal. I understand what happened but frankly I'm...

Thanks for the suggestions. I'm not using powershell yet but it's definately on my need-to-learn list. The script task is also a good idea but I need to check...

Ok, I think I figured this out. Was a pain in the neck but here goes.

The last large chuck of the file has only 2 of the 87 fields populated,...

No reply needed, figured this out. I finally realized that the view sysmail_allitems has a where clause that checks the username of the sent emails and my application user is...

Thank you. I just did a simple test and sp_RefreshView was what I was looking for. I Must have had a brain cramp when I googled this topic before.

This seems a little excessive, since all these tables pertain to a given loan id why can't it be :

SELECT ..

FROM loan L

JOIN Borrow B on B.LoanId =...

Yes, it does appear to be an auto close type of situation but the auto close property was False when I checked it. I'm just going to monitor this...

Ok, It's a little repetitive but here it is. This is the exact verbiage except that I replaced the customer database name with 'CustomerDbName' for privacy reasons. I...

Thanks for the suggestion but AutoClose is set to False. I did notice the following: Initial datafile size was 152mb, current size is 569 mb, and growth rate was set...