No, I would have gone a different way. A heigh table, a width table, etc., and then a Type table that can be mapped to each of the other tables...

Compusol (6/21/2011)

---

First I would like to thank all of you for your input. Initially I was going to give more information but I thought by keeping it simple it would...

The cluster is on ID but you're searching on DOCID. Unless that's a typo, that would explain why you're getting the scan.

Sumanta Roy (6/21/2011)

---

Hi grant,

As you said ANSI 89 outer joins are no longer supported in 2008, I have one doubt. If we change the database compatiblity level to SQL server...

I'd break out the Height, Length, Depth, Weight measures into... probably, four different tables, each with a type lookup into a lookup table. I'd consider making a single measure table,...

It's less than 1gb? Why not look into using SQL Azure? Sounds like a perfect solution.

But, the key point here is, that you can't use nolock with a delete. A delete operation absolutely must lock as it deletes, no options. If you issue a nolock...

If there is no blocking occurring, then your hardware is extremely slow, or there is a problem with your code.

As was already stated, there's not enough information here to provide...

Microsoft books online shows exactly how to configure your system for performing stand alone installs through the command line. You can then do this from a batch file or, better...

Lynn Pettis (6/21/2011)

---

Not much better here either. Would help if he would figure out how to make his urls he posts clickable. I don't feel like showing him,...

I'd be very careful...

Jayanth_Kurup (6/20/2011)

---

I agree when done properly Agile is great for the developer , in fact I have enjoyed working in this manner coz it allows me to do just enough...

I don't know. It's something I'd have to test. You need to let us know what a "large number" looks like to you.

Are you asking if output parameters are slow? No, they're not. If anything, they can be faster than returning a result set.

Are you asking if large numbers of output...

Brandie Tarvin (6/20/2011)

---

polasabhushan (6/20/2011)

---

But I can say that, before taking a full or differential backup, we are truncating log by changing recovery model from bulk-logged to simple and again to...