I think the most benefit you will get out of a good archiving strategy that separates current data from old data.

Since old data is typically queried less often, the requirements...

You could code up something like this (i assume exactly one of the params needs to be null):

IF (@CampaignID IS NOT NULL AND @Email IS NOT NULL)

OR @CampaignID IS NULL...

Wow, 65 times, and I thought I moved a lot with my 8 times... 😉

Hope you have found your peace in the area you live now 🙂

Well, I should have proposed that from the beginning, but have you already tried to run Tuning Advisor with your query?

Since your original question was not now to improve the...

I think this is one of the dilemmas with modern software. While software should increase productivity, it sometimes just degrades it because it is too complex, rapidly changing, or just...

Hi ronnie,

the additional column probably doesnt provide much value (e.g 99 percent of the rows contain this specific value that is filtered for). But make sure the statistics on this...

Hi Ronnie,

Could you pls post the DDL for those?

If I am not completely wrong, the second index (xref1, objecttype) is not being used at all, only the first one. (The...

Despite what already has been mentioned, do you have some more information regarding your indexes and PKs?

I know it does not provide any value (as already pointed out, a lookup table should be used), but I get an overflow with 9712 WHEN cases.

I just had to...

Just to provide an additional example:

SET NOCOUNT ON

DECLARE @table_index TABLE (fld_index tinyint NOT NULL)

INSERT @table_index VALUES(103)

INSERT @table_index VALUES(103)

INSERT @table_index VALUES(103)

INSERT @table_index VALUES(104)

INSERT @table_index VALUES(104)

INSERT @table_index VALUES(104)

INSERT @table_index VALUES(105)

INSERT @table_index VALUES(105)

INSERT...

Hello David,

a good naming convention is a convention that everyone dealing with your objects follows.

I dont see any reason for not using your suggested prefixes. I use vw and usp,...

I guess in 90% of all cases where table variables / temp tables are applied, there is probably a better solution available like:

- Rewriting the queries...

I think these two QODs really show how evil implicit type conversions are.

Id rather spend this one second on explicit type conversion than on reviewing such code for possible data...

I must hardly object!

I have seen poor quality in some of my projects in the past.

Your article doesnt fall under this category even if it might not be perfect...

Hm, tricky question.

It was not clear to me whether the author meant "pages" as units of 8kb or actual "data pages".

Interestingly enough, MS is returning the size of the Log...