Steve Jones - SSC Editor (10/14/2014)

---

Thanks, a couple updates.

We implemented ASKIMET for posts. This took effect today and shouldn't slow things down, but we are evaluating and discarding SPAM posts....

How have you identified that this insert is the cause of the high CPU condition?

Based on this limited information, unless there is a trigger or triggers, a singleton insert doesn't...

I'm not aware of anyway to do this. SSRS doesn't really give you control over the parameters when using Report Manager.

Duplicate post. Please post answers to this topic, http://www.sqlservercentral.com/Forums/Topic1625532-391-1.aspx

You have to use a tool, but MS has one, http://www.microsoft.com/en-us/download/details.aspx?id=40740

As ZZartin has said, ISNUMERIC() = 1 doesn't guarantee that the value can be CAST to a NUMERIC type. You'd think that would be how it would work, but...

I have noticed in the past couple of weeks that SSC pages have had "random" performance...

I'm very rarely passionate about the software I'm working on. I am passionate about how the software is developed and always make an effort to provide the best solution...

Yes

I don't think you really want to put your clustered index on the UpdateDate, you may want a non-clustered index, but not the clustered index. Here's a good read...

mcfarlandparkway (10/13/2014)

---

Hi Champion, Thank you.

You are right,this needs to be done in application. we are using jqgrid,the data which is populated in the grid has

id description date

34 'present'...

Well, you haven't told us a few things:

1. Where you want this enforced, the application, the database, or both?

2. How you are controlling updates? Is it SQL...

I agree...

I'm assuming you don't want the DELETE to occur if the insert fails. The biggest issue with doing it this way is that you need DTC to be working...

In SQL you use a WHERE clause to limit results. So in your example your query would like this:

Select * from dbo.Dogs Where Name IS NULL

NULL represents unknown in...