@@servername is normally the way to go, but it depends on how you refresh your environment

I worked with a company who cloned all of their EPOS systems in 400 stores,...

damnit... I use these almost every day and I still got it wrong (I don't cheat and run the code)

we use persisted computed columns in so many areas - one...

It's 4 part naming - i'll give openquery a go - I've been playing with all sorts of techniques, but I've found that even if I Kill the spid half...

in each database you can set the parameterisation options (right click on the database, go to properties and go to options)

obviously stored procs with nice parameters would be the ideal...

have you run a sql profiler trace to see what the  client app is  trying to do - sounds like the UI is doing the rounding for you

The plan splits for each block of code - the bottom 2 sections are function calls within your proc - i'm afraid you can't keep them as 1 plan (that...

checksum has bitten me so many times (it was there when I started), binary checksum is a bit better, hashbytes is even better - but as phil says "hashing algorithms...

a great start - I use rownumber over (partition by order by) a lot

one of the more overlooked windowing fuctions though is NTILE - especially when you are dealing with...

then it's clear that the 2 steps in the job are operating under different security contexts.

try this - is your sql agent service running as a domain account ? (if...

Back in 2005 I started a new job with a large UK based gambling company.

I think it might have been my 2nd week with the company and I got pulled...

Good point, if I: is a mapped drive of a network share, the mapping may not exist for the user the backup job is running as.  UNC path name...

What about storing it in the ring_buffer and just pulling it out of there?

Am I totally missing the purpose of Extended Events?  I thought they were supposed to be...

as a test, try writing it to a UNC path rather than a mapped drive

\\servername\sharename\filename.txt

so

select columnA, case when column a<>1 then columnb else 0  end as colb from mytable

but your spreadsheet results don't match what you are asking - maybe it's a language barrier...

Being honest - why bother with the log file?

I have an operator and alerts set up for all jobs... I also have a script that checks the last run status...