Is the secondary readable?  If so, was there anything else going on there?

The idea of doing a DROP & CREATE fills me with dread - all the bespoke permissions you could lose...

There's a product over here that claims to kill 99% or so of bacteria and viruses and I've always thought it's the 1% we need to worry about that...

Following on from John's comments, above, you can see if you are using any of those enterprise-only features by spinning up an instance of SQL Server 2019 enterprise edition (or...

Thanks again - I'll...

In keeping with the tenor of the times, I'm just throwing mine away...

In keeping with the tenor of the times, I'm just throwing mine away rather than...

Closing this as it's a duplicate of https://www.sqlservercentral.com/forums/topic/optimise-speedup-query

Out of interest, but I think it might be related... have you got any power management settings configured on that server?

From the post:

Not sure where this is useful or why it's there, but if anyone uses this, let us know.

If you yabingle "quirky update", you'll find examples of its use...

Hi

I use a DB that is used mainly for creating views and tables for another "data" db.

A table has changed and I need to find all the Stored Procs...

this makes me shudder, (don't do this unless under adult supervision) - I've had to occasionally swap the DB to simple mode, checkpoint it,  shrink the log (purely for...

Where is the BCP file created?

I note that you are running the sp_configure xpcmdshell statement after you've attempted to run xp_cmdshell for the first time; I also note that your...

Tonight, I'll be in a theatre orchestra pit for the 5th time this week.  No need for prayers - I...

Tonight, I'll be in a theatre orchestra pit for the 5th time this week.  No need for prayers - I...