SQL Noob (11/14/2007)

---

zip codes are one thing, but a lot of times you have varchar data where a sales person fills it out and just puts in the wrong data...

SQL Noob (11/14/2007)

---

there are no good and bad or black or white in SQL, only gray areas and what is good for your situation

we have very few FK's where i...

Personally, I'd say yes, add the constraints.

Everything Michael Earl said is true. You can simply rely on the fact that the application has the integrity covered. However, as a DBA,...

Well, let's say you have 30 different fields, all customizable by the user. This particular user only uses 5 of the fields, the other 25 lie fallow. When you insert...

Congratulations. Wonderful achievement.

Foreign keys do not directly help performance. They are simply constraints on the data.

What you're saying is, that the developers are not like the rest of us humans. They make...

Except if there are gaps (which there usually are) and you really need exactly every nth record from some particular order. Then you still have to do some kind of...

That's right there with my take on it, but I tried supplying the ID field in case the table didn't have one, or there were gaps or whatever. "Every 'X'"...

I think it's a fine idea.

I'd still want to be able to comment on any article from a vendor. That would tend to keep the playing field level and honest....

Slightly off topic...

We had the planet argument in our house too. My daughter was just adamant that there were nine planets and Pluto was one of them. She was ripped...

Oh updates to XML... Well, you just update the whole thing. You don't try to modify subsets within the string. Rely on the app to do that heavy lifting here....

Oh believe me, we can nail Betty Jean's hide to the wall with the traces.

Coming to the discussion late...

I've worked both sides of the issue. From the consultant side, things just get gray very quickly. If I know more than anyone on your staff,...

deb (11/8/2007)

---

Suppose i have 250 records. If i tried by the above suggested queries i am getting 3 .All fine. But how to confirm those are the recoeds in 0th...

There are a number of scripts available on this site that will analyze the indexes and perform a defrag or a reindex depending on the level of fragementation. It shouldn't...