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

OK, we now know you're talking about replication. However, I'd like to point out that today is...

N_Muller (10/1/2015)

---

I have a CSV file with roughly 6 million rows. The file is unstructured; that is, some rows have 5 fields, others have 15, and there are as many...

So, what...