OK, thanks for this information. I will use either the History Cleanup task or the msdb.dbo.sp_purge_jobhistory procedure to handle this option. Just to confirm: either of those will override the...

Steve Jones - SSC Editor (2/7/2012)

---

webrunner (2/7/2012)

---

Thanks, Steve, this editorial, though brief, gave me lots of food for thought. I don't want to get too philosophical, but for some reason...

Thanks, Steve, this editorial, though brief, gave me lots of food for thought. I don't want to get too philosophical, but for some reason (maybe the fact that part of...

Evil Kraig F (1/26/2012)

---

webrunner (1/26/2012)

---

Hello,

I'm wondering if there is any best practice or established convention about dealing with the following:

I'm designing a job that cleans up log tables by deleting...

Evil Kraig F (1/24/2012)

---

A couple of things to check. First, find out if your testuser is associated to any other roles. Then, double check there isn't an explicit...

GSquared (12/15/2011)

---

Another possibility occurs to me:

Most "illegal XML character" errors I've run into have been ampersands ("&"). A few have been brackets. Since it's nvarchar(max), you can:

select *

from...

GSquared (12/15/2011)

---

Are you storing XML in a string datatype (varchar is the most common for that), and then trying to use an XML function on it or put it in...

Thanks so much. I tried using the function on that page but am still getting the error. I will try a few more variations...

Many thanks!!

- webrunner

Hello Ron,

I tried to download the paper referenced in your article, "SQL Server Instance Health Monitoring Tool,"

http://rjssqlservernotes.files.wordpress.com/2011/10/sqlserverinstancehealthmonitor.pdf

located at this page:

http://www.sqlservercentral.com/articles/Performance+Tuning/71784/

But I get an error: "File does not begin...

Grant Fritchey (10/19/2011)

---

What are the 2nd & 3rd highest wait types. Unless you're sure that parallelism is actually a problem on your system (probably evidenced by CPU binding), this is...

SQLRNNR (10/13/2011)

---

What does the winner tell the boss?

"Hey I need a week or three off. Yeah I hope I have wifi, will have to check with NASA....

Thank you, Steve, for raising this topic. The give and take of caring for data versus allowing users to manage it is a daily struggle. One aspect of current data...

john.arnott (5/24/2011)

---

webrunner (5/24/2011)

---

Oh, OK, thanks. So if there isn't a primary key, and the column is reseeded to 2 where an ID of 12 is already in the table, is...

jcrawf02 (5/24/2011)

---

webrunner (5/24/2011)

---

Not so easy for me -- I got it wrong by picking 13. I thought that despite reseeding the INSERT would add one to the current max ID...