Run this to get a breakdown of how much memory is allocated to each memory cache,. The page buffer cache is CACHESTORE_OBJCP and query plan cache is CACHESTORE_SQLCP.

Select [type],SUM([single_pages_kb]) As...

I only use triggers as a last resort, and this isn't one of them. One technique you can use is to add a column containing a CHECKSUM() of whatever columns...

Soundex has been around since 1918 and it's algorithm for letter substitution is documented here:

https://en.wikipedia.org/wiki/Soundex

Perhaps you can use REPLACE() function to massage the keywords before you do SOUNDEX() comparison.

SOUNDEX(replace('Kolton','K','C')) =...

All the folks committed to psychiatric hospitals during past decades, because they were convinced their TV and refrigerator were spying on them, we can let them all out now.

They're no...

Hey Kim, when you get it all working and identify...

Personally, I'd rather not deal with 100 separate SSIS packages, even if they are auto generated by BIML. If you can leverage BIML or .NET to programmatically modify the DataFlow...

Jeff Moden (10/7/2015)

---

Eric M Russell (10/7/2015)

---

Like, that guy who just walked out of the store with a six pack of Pabst beer probably doesn't have more than a few bucks...

Shawn Melton (10/6/2015)

---

Eric M Russell (10/6/2015)

---

When attempting to click on the url for MinionWare, does anyone else get it blocked by their firewall or anti-virus?

http://www.minionware.com

Symantec Endpoint Protection

Web Attack: Malicious Website...

Matt Miller (#4) (10/7/2015)

---

GoofyGuy (10/7/2015)

---

Eric M Russell wrote:

I guess I'll trot out my capitalist top-hat and say that if consumers are...

GoofyGuy (10/7/2015)

---

Eric M Russell wrote:

I guess I'll trot out my capitalist top-hat and say that if consumers are willing to accept...

I'd rather have more generic SSIS packages and manage 100s of views, rather than managing 100s of SSIS packages. I'd also rather deploy 100 views than I would deploy 10...

IoT appliances benefit service providers more than it does consumers. Of course groceries stores would love to peek inside your refrigerator and see what you've got in stock. Not only...

A data dictionary, or metadata repository, as defined in the IBM Dictionary of Computing, is a "centralized repository of information about data such as meaning, relationships to other data, origin,...

mister.magoo (10/7/2015)

---

Eric M Russell (10/7/2015)

---

mister.magoo (10/6/2015)

---

I don't know whether your setup would suit this, but how about converting to xml , then using hashbytes?

select MBT.refID,

hashbytes('MD5',(select MBT.* from...

Alex Gay (10/7/2015)

---

...

The problem was after that many years we only had three members of staff who could program Clipper well enough to provide support, and they were the IT...