I was researching how to roll my own solution like this using a job and tsql itself.

I'm totally going to give this a shot and look into taking it...

I learned a bit here, but it turns out that my database is already set up in days with various attributes on them and then periods with their own attributes.

I...

PaulB-TheOneAndOnly (11/18/2011)

---

ShawnTherrien (11/17/2011)

---

IMO, a student entity is basically the most immediate information about what a student is. Maybe just their name, SSN, birthdate. A lot more can be broken out...

Dev (11/18/2011)

---

To me this is like saying that everything about a car is an attribute of the car, so the car table can be a flat 800 fields....

This article looks very promising.

I've got my own trigger based CDC (field at a time) capture set up created by dynamic SQL pointed at a table.

I would prefer to...

Martin Nyborg (11/1/2011)

---

In "normal" web application it is not the logged in user that access the database, but a single trusted nt user or a sql user in the connecting...

Nice article!

I've been trying to learn all the regex I could and got frustrated when I found out SSMS implemented a MS version of regex

I've had this exact issue come up on deployments.

Drop FKs, drop Indexes, recreate FKs.

It makes sense that this would use the clustered index for the FK, though I can't say...

Lowell (7/5/2011)

---

SSMS is not the ideal tool to display varchar(max) fields, as GSquared was implying:

one of the settings it uses for increasing perforamnce can also prevent the full text of...

lol, your url got a little hijacked.

http://www.sqlbits.com/Sessions/Event6/High_performance_functions

That might be something.

Results to Grid: 65535 characters. Seems to be the max.

Results to Text: 256. Explains the short text. I can set this to a max of 8192....

Thank you.

I understand the topic of optimizing a cursor based routine pretty well and yet again another day comes where I learn how much more I have to learn....

Thanks 🙂

I'm running READ COMMITTED SNAPSHOT.

The issue is only in writes. A lot of deletes and inserts on a single table.

Things have been better since I've optimized the indexed...

I did attempt a read uncommitted transaction around the statements, but that didn't help, it still deadlocked on heavy testing.

Then I did some research on ISOLATION LEVELS. Found a guy...

Well thank you all for your input.

I can see that I really opened up a can of worms in the way I asked this question... maybe it was too...