Thanks for this discussion, Steve!

Does anyone used TOAD for SQL Server? Is it worth it?

-- webrunner

Thanks, everyone!

Sue_H, I followed the article and walked through the steps carefully. Thank you for posting it!

https://sqlquantumleap.com/2018/06/11/changing-the-collation-of-the-instance-and-all-columns-across-all-user-databases-what-could-possibly-go-wrong/

Turns out one of the databases had a limit on file growth which was...

• This reply was modified 5 years, 4 months ago by webrunner.
• This reply was modified 5 years, 4 months ago by webrunner.
• This reply was modified 5 years, 4 months ago by webrunner.

Thanks, Phil,

Sorry about that site. I didn't get the warning but didn't realize it could be marked as suspicious by security software.

Below are the relevant bits of the page's suggestions.

This...

Thanks, that was a good one.

Thanks for these links!

-...

LOL

I think the bigger issue is the high variability in case...

• This reply was modified 5 years, 7 months ago by webrunner. Reason: Corrected case fatality rate info based on https://www.sciencealert.com/covid-19-s-death-rate-is-higher-than-thought-but-it-should-drop

Interesting idea, but my guess is that Amazon is keeping a lot more PII (especially if one extends the PII concept to potentially sensitive audio conversations) than it is helping...

Thanks!

Just FYI - I think the issue was with the account I was using to run IE. Once I tried connecting through a shortcut that I had set up to...

Welcome back, Steve, seems to me like your sabbatical went by really quickly, so it's good to hear that it wasn't that way for you and that  you feel refreshed....

Nice question, and it got me because I got it wrong. Although DBCC is often used for "checkdb," of course it has other commands such as OPENTRAN.

Thanks for the Monday...

Thanks, Sue, that was it!

I'm going to review our guest accounts to make sure no inappropriate ones are enabled or have connect permissions.

I disabled guest for the database in question...

Hi,

Do you mean something like the topic of this article?

Deleting the data from the database is the easy part, a simple delete loop will handle that nicely.  The problem is...

 If you don't know which type of insert/update pattern your suffering,

Hi Jeff,

Can you recommend a starting point for a scalable way to find out these insert/update patterns across dozens or...

• This reply was modified 5 years, 8 months ago by webrunner.

Thanks for feedback responses everyone and yes its better to work backwards from answer and possibly explain your code syntax logic. I just learning sql. Did not know what...