david.holley (10/16/2014)

---

In VBA, CLng(Now) will return the integer portion of a date CLng(Now) returns 41928, CDate(41928) then returns 10/16/2014. Is there something equivalent in SQL Server that will allow me...

I don't know of anything that would accomplish what you're after, but you may be able to limit the resources he can consume with the Resource Governor if you have...

I have to agree, Victor. This isn't the first time the right answer hasn't been marked as being right. You know, the recent rash of wrong answers being...

You don't have any triggers or cascading deletes here, do you?

Tonsils

Tongue

Grant Fritchey (10/15/2014)

---

There really are lots and lots of good books out there. I'd suggest getting a copy of Itzik Ben Gan's "Inside T-SQL Querying." It's a must read. You...

Congratulations, Grant! Well done! Now go be that positive-direction, common sense voice. Good luck...

Stuart Davies (10/15/2014)

---

Ed Wagner (10/15/2014)

---

Jim_K (10/15/2014)

---

Ed Wagner (10/15/2014)

---

Stuart Davies (10/15/2014)

---

SQLRNNR (10/14/2014)

---

Ed Wagner (10/14/2014)

---

SQLRNNR (10/14/2014)

---

Ed Wagner (10/14/2014)

---

crookj (10/14/2014)

---

SQLRNNR (10/14/2014)

---

djj (10/14/2014)

---

Ed Wagner (10/14/2014)

---

Stuart Davies (10/14/2014)

---

BWFC (10/14/2014)

---

Ed Wagner (10/13/2014)

---

djj (10/13/2014)

---

Ed Wagner (10/13/2014)

---

SQLRNNR (10/13/2014)

---

djj...

Amphibious...

This site has some books available for free download at http://www.sqlservercentral.com/Books/. I've read Grant's book on execution plans and found it very good.

If you're after step-by-step learning...

Have your already determined that it's SQL Server consuming the CPU and not something else? The network admins could have other things (system updates, etc.) running on the server....

Frog

+1 here too. This time the answer is actually wrong...

Can you post the full CREATE TABLE and CREATE INDEX statements?