jim.powers (7/8/2008)

---

orrego.cesar (7/8/2008)

---

I have a big question (I guess that is big only for me), but... 'what is the real advantage of INNER JOIN??? why not to use WHERE condition...

This was my favorite statement

As far as I am concerned the use of stored procedures, database triggers and foreign key restraints is OPTIONAL, not MANDATORY,...

Jeff Moden (6/30/2008)

---

Antares686 (6/26/2008)

---

You could go to your bosses and propose the idea of a DBA doing code quality exams and explain they improve performance, can reduce unexpected downtime and...

See "Using Multiple Lookup Queries" in SQL BOL for help on using Lookups.

Put the query into a text object and look at sp_executesql and EXECUTE. However be aware there are some adminsitrative needs you will have to perform and you open yourself...

That is not really a funtion of full text search. You need either software to propose alternate possibilities or build it yourself. For me I have to compare the address...

Make sure you post this to the site script library and note it a bit better. As well you should do one for C# to ensure your work is credited.

Also you might want to consider a design change.

Units should be the source to determine your number of units not a column in Courses. This is why you have this...

This should have enough info to help you

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx

The problem is that the supposedly intelligent managers at my company keep overridding me and hiring these dummies. They're hiring based only on what the resume says... not on...

Jeff Moden (6/26/2008)

---

I think you're being very generous... I've found that about half the time it's because they're simply a crappo developer that can't program worth a hoot in any...

Simply put it is this. They don't spend a lot of time doing this so they don't focus on what they are doing. Everyone has basically said this in one...

ageuni (6/5/2008)

---

I understand this is a SQL Server forum and as such the majority of readers are going to be database enthusiasts, so I'm anticipating some flaming, but here goes...

OK decide to see what happens when I run the code for the same result each time in the values using a few different methods and here is what I...

Sorry you also have to run DBCC DROPCLEANBUFFERS for the execution plan to actually get regenerated.