Select order_number,

min(serial_number) AS serial_number_min,

max(serial_number) AS serial_number_max,

min(status) AS status_min,

max(status) AS status_max

from...

Sergiy (12/14/2015)

---

You may add something like this into your procedure:

DECLARE @ProcName sysname, @Param INT

SELECT @ProcName = OBJECT_NAME(@@PROCID), @Param = 1000

IF HOST_NAME() = 'My Test Host'

RAISERROR ('Started procedure %s, Parameter supplied:...

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