In our main application, almost all use is by internet users calling our database from a vertical market application. Each one has a login (SQL of course) and it's...

I think I found it in BOL. The option 'Truncate Log on Checkpoint' was checked. This is to minimize growth of the database, it also apparently makes the...

Lot's of laughs on that one. I had started the full scan as part of the original troubleshooting efforts. After 40 minutes it reported 2% done on our...

During repeated attempts to get SQL started I found that 'opends60.dll' and a couple of other DLL files were being reported as 'file or directory is corrupt'. I tried...

George - You wrote:

quote:

---

Example:

User 1

Update table TABLE_A set Field1 = ‘X’ where ID = ‘11111’

Update table TABLE_A set...

The root cause of deadlocks is a design issue. The most common way to get a deadlock is when User1 has Table A locked and then needs a lock...

I appreciate the suggestion about Profiler, but the customer is not that savvy. What in particular would I be asking him to look for?

Any other ideas? I'm getting...

Thanks for the Ping idea, here are the results:

Like most folks, customer has "Discard Pings" on his router. Helped him find and disable that. Ran the Ping test...

Anything over a few hundred bytes fails using Enterprise Manager, Query Analyzer, and our software. The client does not have FTP or web services. Did you have a...

It's not just rowcount though. It's more like a certain byte count of data. I can pull about 5 rows on a small table (Select * from Defaults...

Thanks Andy. I had already used ODBCPING to verify that we were getting through his firewall to the server (although I knew I was since I could access the...

Steve: Now that's what I'm hoping for. The ability to write a SP in VB, using powerful structures like a real Select Case and the non-convoluted If Then...

I'd just like to know how you posted this article on 5/23/02 when it's only 5/19/02 in Florida. I know we can't count votes correctly, but I thought we...

Thanks Steve. You always have such clear precise answers. I knew about SET IDENTITY_INSERT, seems that would only apply when one wants to deliberately copy data from one...

Good article, I hadn't thought that much about it - we don't care that the Identity columns are sequential. Unique we do care about. Your quote from MS...