Look into clustering the table on column A: that will likely address the issue more effectively and efficiently than a slew of nonclus indexes.

Yes, add a new tempdb data file, at exactly the same size as the current data file. Use KB to get the exact size. [That way you will...

Here's a quick script to demonstrate the warning and then the actual error that occurs:

USE tempdb

CREATE TABLE test_index (

long_column_to_index varchar(8000)

)

...

appClinic is the only column(s) that is(are) longer than 900 bytes.

If the total bytes in the index keys are 900 or less, that's not an issue for SQL, so you...

It's just a warning message, unless you actually have a value in that column that exceeds 900 bytes.

You could put that one index create in a separate step, and for...

The integer value for the first day of the month is even easier:

SELECT BOM = @ThisYear * 10000 + @ThisMonth * 100 + 1,

but you must CAST it to char(8)...

GilaMonster (2/25/2013)

ScottPletcher (2/25/2013)

Never??? What if enough memory does not exist to store the results? Surely the results would spill to disk then, presumably...

Not a lot to go on, but maybe something like this:

DECLARE @rows_updated TABLE (

area <same_datatype_as_in_table>,

year <same_datatype_as_in_table>,

benchmark <same_datatype_as_in_table>

...

SELECT

COALESCE(t1.comp_name, t2.comp_name, t3.comp_name, t4.comp_name) AS comp_name,

...

FROM dbo.Tbl1 t1

FULL OUTER JOIN dbo.Tbl2 t2 ON

t2.comp_name = t1.comp_name

FULL OUTER JOIN dbo.Tbl3...

Never??? What if enough memory does not exist to store the results? Surely the results would spill to disk then, presumably to tempdb...

IF EXISTS(SELECT 1 FROM VERSION

WHERE VERSION LIKE '7.[01234567]%')

BEGIN

Usually views contain lots of columns that aren't really needed when several of them are joined to produce a new result set.

Stop using the views and code directly against the...

SELECT

CASE WHEN GETDATE() >= DATEADD(DAY, 1, [current_month_3rd_friday]) THEN

--current day of month is past 3rd Fri, so calc next...

Select

A, B, C,

sum(case when A between 1 and 100 and B between 1 and 100 and C...

Holy cripe! A single, stand-alone INSERT and UPDATE are deadlocking? That table has serious performance issues and should be reviewed immediately. In the meantime, if at all...