I also saw those double smashed and tested it... It works fine

I'm curious... If you had a low power laptop, how many of you would use azure for the heavy lifting.

My surface is just a gateway to either on premis...

your best bet is to set up a domain group and give that group permissions in SQL for your database.

then your domain admins can add other users to the group...

  I use a company issues Surface Pro, and I would not recommend one of these, as there are always issues with RDP on this thing, where it doesn't...

you need to post the error message in full (do it in plain text)- it is chopped off on your print screen

this is step 2 of that job - your...

I have a company issued Surface Pro I7 with 16Gb - the docking station runs 2 additional 27" monitors so I have 3 in total.

it is great to take to...

high cpu is most likely missing indexes, causing the cpu to sort. Or a rogue function.

it's not memory

this is hugely complicated. But i would say 90% is not related to max memory.

This looks like you are trying to do an UPDATE. If so, then

UPDATE  YourTable
SET     columnB = CASE
  ...

This looks like you are trying to do an UPDATE. If so, then

UPDATE  YourTable
SET     columnB = CASE
    ...

extended events have always puzzled me - in theory they are better than a profiler trace, but the display format and functionality is less friendly

personally i'd use a profiler trace...

I've worked with terabytes of data for years, so I have to disagree with joe.

you can often expose your artificial key to the end user if needed, things like "lineitem"

it...

The obvious solution was a GUID, however I hate GUIDs for a number of reasons. One is the huge size--16 bytes does not a useful physical pointer make! My...

I'm with steve on this - the question wasn't "what do you do to fix this" - it was "what error will occur" - and even though I never use...

I see this mistake a lot unfortunately. Using a hashed value based on a multiple column natural key as a primary key.

Algorithms used for hashing values are never guaranteed...