I'm dealing with a crappy proc, and a crappy design, right now.

The devs did the "Code first" design.  In other words, the ORM designed the database for them.

I can't...

it could hit hard in nations with older populations, like...

thanks guys - I think this will work nicely  for me - also something I should have been researching since 2016, just never had the need to

Hell it's not just posted questions that are getting worse it's within our dev team

anyone else here wants to kill who ever invented Linq

just look at the end of the...

someone mentioned today that office phones are disease carriers... if someone answers my phone while i'm away then I catch their germs.

As a practical joke 5 or 6 years ago...

could be worse jeff - I called a colleague over for some guidance on who wrote some code... he talked me through the 5000 line long proc with cursors, functions,...

oh man i wish i was in...

• This reply was modified 5 years, 7 months ago by MVDBA (Mike Vessey).

no, it's a good thing.. but I read the stream and was waiting for the jeffplosion (trademarked) where you decided he was "response by agonising reponse" (see what I did...

we've been laughing at this all day

https://www.nhs.uk/conditions/coronavirus-covid-19/

particularly since I'm recovering from flu and pneumonia

stay at home

not go to work, school or public places

not use public transport or taxis

ask friends, family...

oh man i wish i was in that stream ......

DECLARE @Primary BIT, @DB SYSNAME
SELECT @DB = database_name from msdb.dbo.sysjobsteps where job_id = CONVERT(uniqueidentifier, $(ESCAPE_NONE(JOBID))) and step_id = 2

SELECT @Primary = sys.fn_hadr_is_primary_replica (@DB)
IF @Primary = 1
BEGIN
SELECT...

I tend to think that COVID-19 isn't as serious as many people think it is. I'm not minimizing it. People have died and that's very sad and serious. However,...

I am one of those individuals that are at risk. In 1985, I was diagnosed with an incurable, potentially fatal disease: asthma. Now, age is not on my side...

tokens is an interesting idea

the idea behind the proc is that we are consolidating quite a few servers onto a multi node server which is quite experimental hardware (I think...

in 1918 the spanish flu (influenza A) killed somewhere up to 100 million people. we aren't there yet 🙂