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

Ed Wagner (10/6/2015)

---

Eric M Russell (10/6/2015)

---

It sounds like you...

It sounds like you need to take yourself offline...

Yes, I believe it's a good idea to explicitly name primary and foreign keys. Not only does it provide clarity in error messages, it also makes writing deployment scripts more...

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 Script

Redirect 16 detected

Given a case-use where the requirement is auditing, we can use triggers to capture only specific DML operations (ex: only updates and deletes but not initial inserts), and we can...

Yes. Indexed views are useful for materializing aggregate queries and / or joins. But it can negatively impact table insert and update performance....

Markus (10/6/2015)

---

That just might be it.... when I look at her SPID SQL it shows the select... hum....

That would explain why I see her as a blocking thread to another...

Does DBCC OPENTRAN show any open transactions belonging to that user?

This sounds similar in concept to Oracle's Flashback related features, which leverages the transaction log and are primarily intended for point-in-time recovery, but it allows for Flashback queries as well...