No worries but I'm going to one-up your pedanticness. 🙂 Updates that are inserts will run. However, they're not modifying data that was read, they're creating new...

itskanchanhere (4/19/2012)

---

The more I read on Isolation levels the more I get confused

Connection 1:

BEGIN TRANSACTION; 

SELECT * FROM T; 

WAITFOR DELAY '00:01:00' 

-- Start Connection 2

SELECT * FROM T; 

COMMIT; 

----------------------------------

Connection 2:

Update table T ......

That sounds like a perfectly valid method to me. There are certainly other tools such as Powershell or VBScript that can be used but as long as what you're...

Have you checked the details for the step that failed? That's your best bet for figuring out why. If there's too much info in there to display the...

I'm thinking people that do it as a rule without really thinking rather than when they're not sure...

This is a very good point and something I don't think a lot of people keep in mind. At least among the younger generations. It'll be interesting to...

Read committed is down to 16% so it may just be the early people that threw it off. Read uncommitted is up to 5% though. I have wondered...

The application doesn't happen to drop and recreate that table as part of operation, does it? Or is it possible a vendor tech got in due to a report...

I think replication is going to be your best bet. With mirroring you don't get a constantly updated secondary. What you need to do is create a snapshot...

That was it. Kind of. When running powershell from my machine (32-bit) I was getting redirected to the WOW6432Node key. So it would appear I need to...

It's started. It's not that I can't access them at all, it's that I'm not seeing all keys and that I'm seeing some keys that shouldn't be there. ...

Our other DBA and I alternate who is on call. The DBA "on call" handles incoming issues during the day and watching monitoring. For off-hours issues they're the...

I should have gone back and double checked. I assumed it was just asking about a view updating the underlying table, not about the update violating the column constraints....

andersg98 (4/5/2012)

---

use replication or better yet mirror the database and then use snapshots on the mirror to provide acess to the data. You can schedule a drop and create...

No problem. As a side note, there's a lot of good scripts on this site and things in the forums to help sort things out. And if you...