I'll give you the same answer that I posted to you over on SQLTeams about a half hour ago...

Assuming that each "*" in your search data is supposed to represent...

I dunno, Kris... Are you sure it wasn't that statistics needed to be updated, which is what you did with the index work you did?

Yeah... the rows you're talking about have a loop in them.  We can probably identify the rows not only the way you want them but also mark any rows that...

Do the remarks mean anything?  I ask because they appear to be incorrect for the ranges you're talking about both in the  BILL_SQ and the AUDIT_CALC_AMT columns.  It would be...

I used to think the same thing.   Between MS TEAMS and the other bloatware known as MS Office and running SQL...

Hi

I have current dell laptop with intel processor .I has become old and wish to purchased new one .i wish to try one with amd processor .Which one would...

I am trying to understand what could be wrong at the database side other than the symptom of abnormal CPU. Nothing in the logs and event viewer. Any...

Yep... I agree with Chad on this.

I'd also like to add that I'd be really concerned with the "WHY and WHEN" the clustered index was causing performance issues.  If the...

That appears...

thank you all for your input and yes, I do or should have provided an example, which in the future i will next time. but found the root cause,...

From Donald Knuth & Sir Tony Hoare:

Computer Programming as an Art (1974)

1974 Turing Award Lecture, Communications of the ACM 17 (12), (December 1974), pp. 667–673

The real problem is that programmers have spent far too...

That appears to...

Just found this and, being an older person, I'm loving it.

And, to be sure, the stored procedure would NOT have EXECUTE AS 'SA' in it.

As  I said before, the database should be owned by some login that has "sysadmin" privs. ...

are you sure ...?

if I understand ...to run the procedure with EXECUTE AS 'sa' I have to give a user a grant to impersonate 'sa'.

Am I granting him the...