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...

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 (values(null))foo(bar) for xml auto))...

Of course the RedGate books. If these guys are new to SQL Server and primarily in a support position, then I'd suggest they focus their learning track on backup /...

Kim Crosser (10/6/2015)

---

...

So - I am using parallel tables that contain the primary keys of the source tables and a computed checksum, used to detect changes to the source tables...

Rather than building up a static or dynamic list of OR conditions in WHERE clause, instead load your search keywords into a temp table or table variable, and then join.

select...

If you make the...

The HASHBYTES() function doesn't support a multiple column list like CHECKSUM(), however, a while back I found a solution to this by appending multiple columns after re-casting to VarBinary datatype.

For...