It's DVORAK. I tried learning it once. It was so painful. I don't think about typing any more but I had to on that keyboard. It was too painful. I...

You can't really do that, no. You could break up the longer running process into smaller transactions so that there are available windows between commits for other processes to obtain...

GilaMonster (7/23/2009)

---

Just checked out the local news. There have been some riots in Mpumalanga, the province to the east of where I live and also in the Western Cape, mostly...

Well, that answers the question. And it also puts forward a second: Why...

If I understand the question, you do need to make sure that the statistics are updated on the second database. usually just leaving the auto update statistics set to on,...

I agree with Jeff. In a small shop, you have to cross the lines, a lot, but the fact is, it's your job to work together. That's it. End of...

Hey Gail,

Being completely clueless as to facts on the ground, I have to ask.

There was a report on the radio of very severe rioting in SA. You OK?

I'm sure they occupy a little, but not anything to worry about.... unless you're declaring thousands of them or something.

sqlrumble (7/23/2009)

---

Hello,

I've looked around but was unable to find recent comparisson reviews off SQL Monitoring Software.

I've been asked to review SQL Server Monitoring software. Our instances are a mixture...

CodePlex is where Microsoft publishes the databases. If you get it from any other source... it might not be what they say it is. I'd stick to CodePlex.

Could you post the actual execution plan?

I suspect you're missing an index,but it's also possible that, without any thing to filter that table, you're getting a scan.

You may be able to see it in the Schema Changes History standard report.It only shows changes since the last time the service started.

Locking is a natural and important part of updating data in SQL Server. Intent locks, and others, should be reduced as much as possible, but they can't be prevented or...

The code is almost always relevant to the problem when we're talking about TSQL.

As several people have pointed out, depending on what was referenced or how things were referenced in...

The overviews will barely get your feet wet. It's a hard thing to learn, or least I've found it to be so far.