Be cautious about building this kind of catch-all query. Here's some great advice from Gail Shaw on the topic. Note that she has multiple posts on the topic. It's...

Sounds like two joins. Once on hotel1 to the table2 id, then on hotel2 to table2 id. This is psuedo code, but you get the idea;

SELECT ha.HotelName...

There's no way to know without testing it on the system you're running it against. Query performance is not simply the T-SQL itself (although that alone is a huge factor)....

Cheers!

"fuel save pro   compatibility to ethernet in addition to Wi-Fi, and for that reason enable completely wireless operations and data ment. The consumer can switch the retrieved information by...

Happy New Year to you, too, Grant.

I only ever made one New Year's resolution (many years ago), and that was not to make any New Year's resolutions in the...

There's no question in my mind that I've lost my mind 😀 and I'm not sure if I've asked it here before or not but I'll ask it again.

Other...

There's no question in my mind that I've lost my mind 😀 and I'm not sure if I've asked it here before or not but I'll ask it again.

Other...

There's no question in my mind that I've lost my mind 😀 and I'm not sure if I've asked it here before or not but I'll ask it again.

Other...

Hourly log backups may not be frequent enough. Think of it like this. If the server crashed, you may lose up to an hour of data if you couldn't get...

You might try looking at the connectivity_error_ring_buffer_recorded Extended Event. It's one mechanism to track timeouts on connections. I think it might, possibly, maybe (did I put enough weasel words in?)...

Here are a few pointers for this common problem. Chances are very high that your databases are in FULL recovery mode, but that you don't have log backups set...

I am bringing in some help on this one. I may be horribly wrong in what I've been saying.

Are you letting constraint names or similar be automatically generated? That could lead to the issue. Stuff like that is likely the cause.

I work for Redgate, so take what I say with a grain of salt...

You want to go and get a copy of Redgate SQL Monitor. You can check it out...