Breanna Hansen

[Breanna Hansen @SQLBreanna]

@freestylecoder @SQLMCT @kekline 100% agree. For example, I prefer keywords in lowercase (but I'm probably in the minority there).

[Breanna Hansen @SQLBreanna]

My heart will be in Eastern Tennessee for the next 2 days & I will be thinking of everyone who would have been at @CodeStock this weekend!

[Breanna Hansen @SQLBreanna]

@freestylecoder @jwcarroll And/or:
update tgt
set col1 = src.col1, col2 = src.col2
from SourceTable src
join TargetTable tgt on src.joincol = tgt.joincol
where src.wherecol = tgt.wherecol; -- This is based on the ON clause from the MERGE statement

[Breanna Hansen @SQLBreanna]

@freestylecoder @jwcarroll Something like:
insert into tgt(col1, col2)
select col1, col2
from SourceTable src
join TargetTable tgt on src.joincol = tgt.joincol
where src.wherecol <> tgt.wherecol; -- This is based on the ON clause from the MERGE statement

[Breanna Hansen @SQLBreanna]

@freestylecoder @jwcarroll A bit late to this one, but yes, use a WHERE clause. Just off the cuff here, so this may not be 100%, but the general ideas is to base the WHERE clause on the ON clause in the MERGE statement (plus any additional condition you need).

[Breanna Hansen @SQLBreanna]

Just arrived in Huntsville. Stoked about @devspaceconf. It's going to be awesome this weekend!

[Breanna Hansen @SQLBreanna]

New post: Searching Only Active Jobs https://t.co/EEd6Z8JSxl

[Breanna Hansen @SQLBreanna]

New post: Determine If a Job Has Run Recently https://t.co/eRSDlJ4Sys

[Breanna Hansen @SQLBreanna]

New post: Determine If a Job Is Scheduled https://t.co/T03nDUbTz2

[Breanna Hansen @SQLBreanna]

New post: Finding Which Job Steps Are Reachable https://t.co/4Ze5cF40nh

[Breanna Hansen @SQLBreanna]

Thanks to everyone who came to the #SQLServerGameShow (Developer Edition) @CodeStock. I think we all had a fun time and hopefully learned a bit. #CodeStock.

[Breanna Hansen @SQLBreanna]

New post: Don��t Fear the Timeout https://t.co/kGur1aimGp

[Breanna Hansen @SQLBreanna]

In early 2016 I predicted that #Hekaton would someday become the de facto standard for tables. Now we're seeing some hints of that with yesterday's announcement that some internal tables will be in-memory in #SQLServer2019. Love it!

[Breanna Hansen @SQLBreanna]

The new sys.fn_PageResCracker function is pretty sweet though.

[Breanna Hansen @SQLBreanna]

I do love the new https://t.co/0H8DGLd98c_db_page_info function in #SqlServer2019. It's a step in the right direction, but the fact that it returns only HEADER info probably means I won't use it terribly often.

[Breanna Hansen @SQLBreanna]

Nearly 50 degree temperature drop driving home from #devspace18 ... 80 when I left Alabama this morning; light snow (not sticking) in KC now #SummerToWinterIn12Hours

[Breanna Hansen @SQLBreanna]

"No one prepares us to interview others." @cassandrafaris is going to show us how. #devspace18

[Breanna Hansen @SQLBreanna]

Hey #devspace18 ... Ready to have some fun? Tomorrow morning is the SQL Server Game Show. Be there bright & early @ 8:30am so you don't miss out!

[Breanna Hansen @SQLBreanna]

70% of people at some time experience imposter syndrome. @HMSchreck breaks down ways to handle it at #devspace18

[Breanna Hansen @SQLBreanna]

@aJimHolmes kicks off #devspace18 with a heart wrenching personal story of overcoming adversity