Well tonight I plan to go home play some Overwatch and shoot some people in the face.

It really depends on what processing they are trying to move from the DB to the application, an everything or nothing approach is probably the wrong idea.  There are certain...

When you say huge refactoring of applications what do you mean?  Unless an application is directly checking the metadata of the underlying tables it would have no way of knowing...

I'm good at figuring out weird problems and making computers do things, as long as people are paying me I'm relatively happy doing that.  There's inevitably going to be some...

You would need to use to stored procedure to do that not a function.

Don't know if you can do this anymore(we were on windows XP) but one of the more amusing ones we did at my last job was setting all the font...

You asked this same question a few days ago, your spelling of forcibly is very distinctive I'm not quite sure who bily is or why I'm trying to force him...

I'm not seeing any aggregate function in there, don't you just need a SUM() around the case statement?

I haven't had huge amounts of experiences with different change approval processes but the biggest area of conflict always is deploying stuff in a timely manner vs. getting proper approval...

Well how fast does the just the select run without the insert?

And how many rows does the distinct return vs. how many rows you were returning with the...