You can't determine this. When someone runs a query that requires more buffer pool (or one of the other memory spots), if SQL Server is not at the max, it...

I didn't think much of the sabbatical until I took one. After my second, I think it's a great way to reward long term employees with a chance to unwind...

This exists. For all posts after the first, "Mark as Answer" is an option for the post. Look just above here, to the right of the date.

I got one just before the pandemic. It was a good way to go from standing to sitting and vary my position. I don't stand a lot these days, but...

I've tried to remove a desktop, but I don't get the same resolution or control expanding my laptop to other monitors. Plus, when I am remote, then things are moved...

I've tried to remove a desktop, but I don't get the same resolution or control expanding my laptop to other monitors. Plus, when I am remote, then things are moved...

But in fairness to companies/organizations root cause analysis can take a long time. How to strike a balance between getting up and running again vs. figuring out what failed...

I tend to agree. I've managed SQL Servers that ran for a year without rebooting in the past, but these days, I'd want to at least ensure we had some...

Avoid the news wherever possible, so no idea.

Before my wife took early retirement from an office furniture manufacturer and started her graphic design and web development business we furnished our home office at dealer cost with...

My wife and I are fortunate to have two spare rooms in the house to accommodate separate offices.  She does physical therapy practice management consulting while I'm a software...

I'd do what jonau1 has suggested above. Allow the user CONTROL on the schema, then grant the various rights to the user to work with objects.

I don't believe you can upgrade Express to Standard. I think you need to:

• detach dbs
• script out logins and linked servers
• install SQL standard
• attach dbs
• recreate logins

Might need to provide more information about what is not updated and what the errors are. You've sketched a very general problem that is hard to answer.

Didn't get to watch it. I ended up setting 7 fence posts:

and 900 feet of horse fence