mister.magoo (9/6/2015)

---

For this simple example, I believe this form may produce a good result:

(only tested on SQL 2016 CTP 2.3 using Kevin's test data from a few posts back)

SELECT first_name,...

All of the above advice is good (especially Jeff Moden's), but have you considered using Service Broker? Asynchronous logging is one of its primary use cases. On the...

Something that "might" help the optimizer generate a better execution plan is really no help at all. You need something that will deliver predictable performance. A query that...

Performance inside a trigger will be much like performance outside a trigger, with the additional caveat that the Virtual Inserted and Deleted tables are like table variables in that they...

The article has moved here: http://sqlmag.com/t-sql/showdown-bcp-vs-dts

I should also add that this explains why the logical statement NULL = NULL also yields NULL. We don't know either value in this statement. It is possible...

Yes, there is a reason for the default behavior of ANSI_NULL, and it goes back to the core concept of relational databases.

Relational databases are based on a mathematical model (first...

Since the primary key on the table from which you are deleting records is a foreign key on other tables, check to ensure that the foreign keys are properly indexed...

sqlguy-736318 (3/5/2015)

Thanks! I seem to remember that there was a heuristic for a long time that queries that join more than 5 tables should generally be avoided. Is...

Correct. sp_ExecuteSQL requires NVARCHAR.

I am still having trouble understanding the table structure. Please send us CREATE TABLE statements for the tables you want.

Please send us the two queries that you are running.

Also, it may be a little bit of a language barrier, but I am having trouble understanding what you want to...

My rule of thumb is exactly what you just described: if I have trouble understanding a query, I want to break it into smaller pieces that are easier to...

Well, so far, "Karate Kid" is the runaway favorite. Is this due to some sub-conscious accumulation of violent frustration on the part of DBA's? Hmmm.

My personal favorite was...

I must say, this is the most moderate and reasonable discussion on SQL Code Smells that I've found online. Usually, a blog about SQL Code Smells (or worse, SQL...