<li style="list-style-type: none;">

<li style="list-style-type: none;">

<li style="list-style-type: none;">

<li style="list-style-type: none;">

1. OPENQUERY is your friend. Linked servers and letting SQL Server figure out if, maybe, this...

Shoot... I'm just happy to be on someone's list. 😀 😀 😀

I meet Steve and Grant before they knew how to spell RedGate.  I don't remember exactly but it...

sounds like you want to right click on you r server and go for "poperties"

then go to database settings - these are the default locations, but any existing jobs might...

<li style="list-style-type: none;">

1. OPENQUERY is your friend. Linked servers and letting SQL Server figure out if, maybe, this time, it pushes predicates to the second server to...

watsap expires over Christmas. I've swapped to web apps for most things.

oh jeff, just for fun.. I already met steve, grant, kendra, itzig - i'm stalking you next 🙂 lol - that puts you just above brent ozar

steve put the blendology link in for me, (he's good like that)

also agree with ktflash, don't be afraid to put your solution in... i'm often wrong and never afraid to...

Sometimes it can be better to create a table variable (or temp table) and fetch your data into it, then use that in your join.. not always

I've started using sql...

For a 9-5 job, MI and BI skills will be stable roles - maybe power pivot etc, maybe R

But beware , these will pay a lot less

maybe move to a...

I got myself some smart door sensors because next year I'm getting a large AC unit and I am very serious about not running it when...

I really do think that you should look at Change data capture (CDC)

https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server?view=sql-server-ver15

if you are looking at data auditing

CDC can be quite cool

https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server?view=sql-server-ver15

it might not be your solution, but give it a look over

HI Ben

for my own learning, why "the most recent version of enterprise" fixes your needs

Dark corner of the room, fetal position in a blanket, suck thumb, twiddle hair, beer popsicle, converse...

at 70kg you are pretty much the same as me. - I don't think joe meant it that way