Another consideration, adding PK's means you're adding an index, clustered or nonclustered, to a table where none previously existed. That will affect performance, probably positively, but possibly negatively.

You have tons...

Mike01 (7/12/2010)

---

Another concern with leaving deleted records in the table is primary key issues. If a user enters a record that was previously deleted, it will fail on the...

That's a final approach to logical deletes. I'd just keep an eye on performance because, presumably, you're filtering on that bit, which won't index well, so you could see some...

You're way off in your use of @@RowCount. Every time something is referenced or updated, you're going to get a change in @@RowCount. If you want to use it, it...

shayy (7/12/2010)

---

Thank you both for the fast replies.

1. As i mentioned, i only have one query (maybe 2) which takes the data ordered by ProjectName

2. about using the WHERE, what...

If you're building a custom string every time you execute, that's why you're seeing thousands of execution plans. You simply can't do that. Very, very small changes to the text...

KeyurGohel (7/12/2010)

---

hello, friends i have

table: EmpMst

id empcod empname Sdate ...

chetanr.jain (7/12/2010)

---

Team,

My Client has one service desk application at its two location ( A & B) with individual identical database. Now client wants to merge the both the database (...

shayy (7/12/2010)

---

Hi,

I have a table with these fields:

ID (PK), ProjectName, and some other non important fields (about 20)

Most of my queries i'm doing SELECT * from this table.

there is one...

If you're working with linked servers and running queries against them, you need to know that unless you specifically use a construct like OPENQUERY and pass in parameter values, all...

Alvin Ramard (7/11/2010)

---

Jack Corbett (7/11/2010)

---

CirquedeSQLeil (7/11/2010)

---

Alvin Ramard (7/11/2010)

---

One problem I've seen in the work place is that are too many managers that do not have enough technological knowledge to properly...

Jeff Moden (7/9/2010)

---

Interesting... PASS accepted my abstract on the Tally Table session. I'm actually a bit surprised at that. I had also submitted an abstract on a...

Wouldn't be the first time I did something wrong. Time for experimentation.

Yeah, it's a bit of a bear.

Fact is, you're right Steve, SharePoint doesn't need 'sa', but it needs about 85% of what 'sa' does, so it's easier to just give...

The Dixie Flatline (7/9/2010)

---

Lynn, the only reason I'm holding back is it is the subject of an article I'm writing (if it proves out against spatial indexes).

One...