John Hick

The Elusive Conditional WHERE Clause

What's this, a conditional WHERE clause that doesn't use dynamic SQL?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.3 (67)

2017-01-27 (first published: 2013-04-18)

39,226 reads

Today’s coping tip is to stop for a minute when you walk outside and...

One of the reasons you may be considering encryption is due to the relevant...

There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

We were getting constant blocking on the db server. However, after stopping the process...

I have a table from a Linked Server that I'm pulling data and would...

Hi, I have a table containing some columns and some simple data. I want...