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...

This might help: https://stackoverflow.com/questions/182750/map-a-network-drive-to-be-used-by-a-service/4763324#4763324

If you want a mapping to persist, there's a flag. You need to be logged in as the user to do this.

By default, the agent maintains 9 logs. Each time the service starts, it creates a new log and discards the oldest one.

If you recycle manually once a week, you should...

1. There are a few things. First, you can parallelize the operations, so that the database backups run concurrently. Second, you can parallelize the writes by sending the backup to...

These will capture information, and it may be useful here. However, the length of the query doesn't necessarily impact the log growth. It can, but the log growth is a...

Is hyperthreading enabled? The product has been shown to work with hundreds of cores. I think you're missing something in your view.

Was there any long running query? I see some bad queries sent from the web server that tie up the SQL Server. Maybe not peg things, but they just take...