I think Beatrix is on the right track. Something scheduled, likely outside of SQL, is affecting the cards. I would also be sure no "phone home" software is looking for...

Not sure what you mean here?...

Thought this was interesting as I'm doing a little HDFS testing. Haven't seen sp_configure used this way.

How often do your instances reboot/restart? For patching or anything? Take some guess here or use historical data. 12 is good for 3 months with no restarts. If you restart...

Interesting. If you solve it, love to know (or get an article on the solution)

High touch leads and PMs are the bane of getting a project done. The best ones give you an outline of what to do and a phone number to call...

Well, clearly Yahoo is a much better manager than I am. Drafted for me, set the first two lineups because I didn't recognize half the names, and it's worked out...

It's not that a rollback is always dangerous, but it can be. Rolling back 1,000 narrow rows is much different than 100,000,000 wide rows. The select * into isn't always...

Assume no PK if not mentioned, and yes, likely aiming for similar questions in the future with other variations.

Or you should feel free to submit one 😉

https://www.sqlservercentral.com/contributions

Around here, the crazy season starts about January 1, but it lets up on December 31.

Off to another meeting to tell the finance guys they should not have permissions...

mmm,set based results. I like it.

Frederico, Redgate has also had this with SQL Backup Pro and our Object Recovery tool. We could do it because we tracked where objects were...

What's the issue? There shouldn't be much of a difference, or really any, once you're connected. The alias and hostname resolve to an IP+port for the eventual communication.

When I'm in the Redgate office, we have an open plan. I either wear headphones, which sometimes work, or go find a small cube. We have a few available for...

As Phil mentioned, it's good to see what the data is. What I usually want is

-- base data
insert table values (a, 1), (b, 2), (c, 3)

--- results

create...

Yet.

Remember to use the word yet when you have goals or impediments. People might not want to change, yet, but perhaps they will over time. Many things happen on the...