I've read the link you gave before and am generally familiar with partitioning. It doesn't really indicate go into how you can purge records using non logged ddl operations....

The first paragraph seems to imply that partitioning will improve the performance of deletes (while purging data). How does partitioning help with that?

Al-Rahim (7/15/2013)

---

The error refers to an account entitlement error... so give properly permissions to secondary agent server account. You should have same account in both primary and secondary servers. Also...

No, I was never able to get this resolved. In the end, I believe it was a network issue because the secondary...

Below is the output from the errorlog. I copy this to a txt file and search for loginname, spid, hostname and so forth to get the type of information...

I have not seen any additional corruption since my initial post. My server specialist indicated there were warnings related to I/O latency that evening, but since then he has...

Thank...

Yes, we sure do. So, are you saying the index rebuild probably fixed the corruption?

The general idea of null is that it means "it is not known what this value is"; if I replace some characters in a sting with an unknown value, how...

I agree with Toreador.

FYI, I found this which describes how a deadlock can occur with a SELECT.

I'm now struggling with why the output from the errorlog seems to include only part of the...

Still looking at this...

Since the app is a web app, I guess nothing can be determined from the two processes coming from the same SPID due to connection pooling. ...

Ah, I see. You had a user input screen that ulimately called a powershell script. I'm with ya now.

I just always try to avoid any issues SQL Injection related.

Mainly to avoid copy/paste behaviour issues in the spirit of "That's how our DBA did it, so it must...

Gotcha on the date formatting. I've implemented that, thanks.

Not sure why we are concerned about SQL Injection on this, though. I'm doing a straight INSERT. Care to...