Hi Steve,

Someone pointed this out yesterday, but it happened again today. There's been no category for the last two questions.

webrunner

College is extremely important, but not necessarily in the way people expect. A college degree is the new high school diploma. It allows a person to have a wider range...

Thanks for the replies!

I have one other question. How does memory work for SQL Server 2005? I see in the SQL Server 2005 feature comparison that the Standard Edition uses...

Sadly, I don't get to play many computer games anymore. I play mostly chess. But I...

Steve Jones - Editor (10/7/2007)

---

I think you're ok with memory as well, but with 8GB, you probably want to give 6-6.5 to SQL and see if performance improves

Make sure you...

Sorry for the delayed reply.

We are running SQL Server 2005 SP1.

I don't think the issue is limited to DTS packages, since job history is not being logged for any...

I know I am a terrible estimator; it's definitely something I want to improve. For example, I thought this post would take me one minute to write and it ended...

Thanks, although I can't take credit for it. Someone else recommended it to me earlier. I hope there is another way to work around...

Steve Jones - Editor (10/2/2007)

---

It might be the rebuild. That usually requires 1.5 times disk space in the data file and records a lot of log changes. Can you snapshot...

Interesting question. It made me wonder whether the same questions are asked of other industries - do people who work at car companies...

Jeff Moden (9/27/2007)

---

One of the recommendations in Books Online under "deadlocks, avoiding" is...

Keep Transactions Short and in One Batch

A deadlock typically occurs when several long-running transactions execute concurrently in the...

I think in general most people pitch in when asked, and by and large that is a good thing. But I think it should be clear that a DBA (or...

I completely agree with you, Steve.

The worst case scenario is that the employee gets some time off in an environment where at least there is SQL being discussed everywhere....

"Some folks here have stated they consider the power out to b an outage with their ap becuase the custmer is unable to use it.

OK, what if the customers machine...

I saw the same problem. You can also click the "Print This!" button at the top of the article, and the print format has the word wrap on.

HTH,

webrunner