Thanks for chiming in, Brandie.

What I find surprising, is the predicate "IS NOT NULL" using an index seek.

WTF???!??!

Hi folks, I'm really stuck on this one.

Can any of you jump in and clear the fog?

It's a strange thing IMHO, sure beyond my knowledge.

Well, I don't know what to say. I agree with you that the index gets used, that would make me think that IS NULL is SARGable.

It's not my definition, you...

I see the point you're trying to make, but "column IS NULL" is not a SARGable predicate.

The index CAN be used anyway, but this doesn't make the predicate SARGable.

Here's...

For instance, these are one SARGable expression ( REVROLE_ROLEREVU_REVIEWERROLEID.NAME LIKE 'LE REVIEWER%') and a non-SARGable expression (CARE_BOOKSERIES.Id IS NULL ). If...

CASE expressions are non-SARGable: when possibile, avoid using them. Use SARGable expressions on properly indexed tables instead.

What do you mean with "Improve the performance"? Improve compared to what?

This is a great script I borrowed from Jeff Moden that should make things a lot clearer:

--===== "Space Used on Steroids"

-- If "UnusedKB" is negative, it's likely you need to...

You could insert the final results of your procedure into a temporary table (those prefixed with #) and then, based on a parameter, return the number of rows in the...

I'm not sure that I understand what you're after.

Can you attach the actual code (or a simplified version of if) so that I can try to tweak it?

I don't want to echo the response you've already had from other posters.

I just want to suggest that percentage growth is not generally a good idea. Imagine you set it...

You can capure @@ROWCOUNT right after the query execution and then return it as output parameter or as procedure return value (RETURN @myCountVar).

Hope this helps

Gianluca

You could create a backup device that points to the UNC path of the public server and then backup to that device.

naunton (10/11/2010)

---

Thank you again, accept your idea to create #tablename.

when I run this for testing

the message result show as below and it create...

Why don't you use Performance Data Collector?

From the description of your problem, there's the risk of re-inventing the wheel.

GilaMonster (10/11/2010)

---

Generally doing this is...