An example of this problem is one that may sometimes be subtle yet dangerous - email addresses. Email addresses in a test system can inadvertently be used if the production...

Barry McConnell (12/11/2007)

---

The reason the PK needs to be unique is so that referential integrity can be maintained, ie the FK must point to exactly one row.

By confusion, I was...

Barry McConnell (12/11/2007)

---

Classic confusion of keys vs. indices. The purpose of a PK is to provide referential integrity; access is provided by an index. One simple case where a PK...

Just my humble observation - and one that I haven't tested in SQL 2005 - is that a lack of a PK causes this issue in Enterprise Manager, assuming there...

Thanks for the excellent article. It is the classic easier-said-than-done list, but given that I can see the value of all of the things you listed, I will take it...

PS - I don't see anywhere obvious where I can specify these connection options in ColdFusion - if anyone knows ColdFusion and can point it out if there is such...

Thanks,

The local server is SQL 2000. The linked server is SQL 2005.

Because this is a SELECT statement, I tried making a view, but I don't know if ANSI_NULLS and ANSI_WARNINGS...

OK, thanks,

Yes, though, that is what I meant. The queries on the new server fail with this error:

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'table1'

I was...

Thanks again, Jeff,

We think we spotted one long-running query that was causing problems, so that is good since I think the developer was able to control it not to run...

Thanks for everyone's advice.

About how much does Idera's Diagnostic Manager cost?

webrunner

Many thanks. I will consult that article.

webrunner

Thanks, Jeff,

The issue with the blocking in this case is that it results from queries waiting so long that they are causing the web site to run very slowly or...

Thanks, absolutely, I don't think I would shrink the transaction file given the size it is now (around 1 GB). However, this application I have been introduced to seems to...

Thanks for your reply.

I was looking at the ldf file in the file system. I understand that the file may stay the same size after a transaction log backup (a...

mekal inc (11/9/2007)

---

Hi again

...

So your best choice i guess is to stay with your current system and buy an addtional 4 Gb RAM and your good to go.

Or reinstall to...