If you have indexes keyed on tbl2.col1 and on tbl3.col1, then it almost has to be some type of blocking. You could try the query below, might work better,...

Do you have a nonclustered, nonfiltered index containing tbl2.col1?

A nonclustered, nonfiltered index containing tbl3.col1?

If you need to know if all the lines have only product_type = 'A' on any kind of regular basis, I'd denormalize and add a flag to the invoice header,...

Jeff Moden (12/12/2015)

---

ScottPletcher (12/10/2015)

---

Do you have a unique index on Word? You don't want SQL to have to sort the words every time -- that will be extremely slow....

Here's a few notes on the conversion process, and a sample of the first table converted.

The double quotes are fine, as long as "SET QUOTED_IDENTIFIER ON" is active, which it...

Is the log size growing, or just the % used? You don't want the log size to grow dynamically, as that will slow down the database. But tempdb...

If it's for a single, specific stored proc, could you just add code to that proc to save the parameter values that came in? You could even have an...

Do you have a unique index on Word? You don't want SQL to have to sort the words every time -- that will be extremely slow. Also, if...

The clustered index is definitely correct. Date will be mildly more efficient than datetime, but it's not enough of a difference to be a big deal.

Make sure the fillfactor...

kiril.lazarov.77 (12/10/2015)

---

ScottPletcher (12/9/2015)

---

Create a separate index of just the IDs. Then select a random ID using ORDER BY NEWID(), then use that ID to get the rest of the...

kiril.lazarov.77 (12/10/2015)

---

ScottPletcher (12/9/2015)

---

Create a separate index of just the IDs. Then select a random ID using ORDER BY NEWID(), then use that ID to get the rest of the...

If it's always a "w" followed by a digit or digits, perhaps just this?!:

declare @testdata table(expression varchar(500))

insert into @testdata values('[w1+w2+w3/5]'),('[(w1+w2+w3)/5]'),('[(w4-w5*w6)/5]')

insert into @testdata values('w1')

insert into @testdata values('2w3')

insert into @testdata values('4+w5')

select 'w'...

Cluster the table on the month.

I'd include at least the year with the month. Best is to use a column of type date, but if necessary you can use...

No, the syntax is somewhat off. A CASE expression must evaluate to a single value.

For what you're doing, try something like this instead:

IF @Client = 'Winco Foods' AND EXISTS(

SELECT...

Also, for best performance, specify the least likely to match condition first. If one (or more) of the AND conditions are going to be false, you want SQL to...