I'm not sure that I understand you correctly, but if I do, then you just need to check if you have the value 0 in totalhighprtjobs column. Something like...

You don't need to use the over clause. You can just use group by instead:

WITH myMainTable AS

(SELECT 1 AS obj_id, 'A' AS obj_desc

UNION ALL

SELECT 2,'B'

UNION ALL

SELECT 3,'C'

UNION ALL

SELECT 4,'D'

UNION...

This can work...

I've noticed that in your query you wrote the name Model. If the server is case sensitive, you won't find the model database if you'll use a capital later....

Here is one way of doing it:

select 'alter index [' + si.name + '] on [' + schema_name(so.schema_id) + '].[' + so.name + '] rebuild with (online = on)'

from sys.indexes...

You mean that you didn't say it already at day 1?:-)

Adi

I admit that it's been a long time since I've worked with the maintenance plan wizard, but when I did work with it, I found out that most times it...

For such small amount of records per day, I'd do it as simple as possible – One table for all days. By the way I don't think that having...

I think that the problem is with the query that you are using for the alert. The DMV sys.dm_exec_query_memory_grants has records for memory grants that are waiting and...

I didn't check it (next time pleas write a script that creates the table and inserts the data), but I think that the query bellow will do it for you:

select...

Grant Fritchey (12/18/2013)

---

OK. That was just 2014 acting cute. I did get two different plans in 2012.

To understand the differences, look to the properties. I have both plans using...

I don't think that it has anything to do with determinism. In both queries the query gets 1 value (once as a variable and once as an expression)....

Actually with a variable the server doesn't know what value will be used. This is one of the differences between variable and parameter. It can do parameter...

By not working, I assume that you get null value from the isnull function. Most chances are that you have some records that both columns have null values. ...

You have to understand that the sub query is connected to the outer query. Take a look at this query:

SELECT temp_int_field, temp_varchar_field

FROM #temp WITH(NOLOCK)

WHERE temp_int_field IN (SELECT sub_table_int...