Chandio, for the way you are describing your set up, you will need to write a script to check the dates and delete them after they expire. You can...

Dharris, as I understand it links have very little impact (note that I did not say none, especially on the insert and update side, but little) on the speed of...

Alvin Ramard (3/19/2009)

---

timothyawiseman (3/19/2009)

---

Alvin, I think it is a case of ensuring the students know the technique for doing it, even if it is one that they may not initially...

Alvin, I think it is a case of ensuring the students know the technique for doing it, even if it is one that they may not initially use as beginnings.

Remember...

Technically true, but I have been in...

Bruce W Cassidy (3/17/2009)

---

[font="Verdana"]The best way is to use gateway stored procedures to handle your inserts and updates. So they can insert and update into the various tables as...

munderhill73525 (3/17/2009)

---

I thought that too but I am taking a SQL Server class and the assignment specifically says to:

Write a SQL query that uses UNION of the...

Carla;

There are definitely numerous design considerations.

First, the view has to be schema bound. This makes it harder to change any objects the view depends on (you have to remove...

I have to disagree. Given SQL Server 2005's age now, I would not have emphasized...

Excellent script. This should prove useful after tweaking for this specific environment.

Generally, I would not recommend using a multicolumn primary key/clustered index. You may be best finding a single column for your clustered index and then creating multicolumn indexes for...

The article was well done, but it was not really relevant to this site.

Since we are talking about firefox extensions, I find the del.icio.us extension to be top-notch personally.

john g (2/11/2009)

---

If network bandwidth is most critical, you will most likely have to export the data to local disk, then compress, push across, uncompress at the destination, then load.

Hopefully...

I didn't read closely enough the columns listed to see that they could be easily merged. That would definitely be better in this case.

They are not redundant since they have different total indexed columns and completely different included columns.

But, there is a disadvantage to having both. Remember that whenever you do any...