One more little syntax problem - you have a rogue ) in your SELECT statement. get rid of that.

Grant Fritchey (3/5/2008)

---

If the emailaddress is the primary means of accessing this table, then yeah, I'd make it the clustered index. If you have it as a unique non-clustered index,...

Steve Jones - Editor (3/4/2008)

---

Build the table, and determine what the query needs to return. You can index on key fields to return things quickly in an index seek, though...

If you're planning on clustering - then traditional "local disks" aren't going to be an option. At very least you are going to need some way to share the...

Jeff Moden (3/4/2008)

---

Ok, no... you have to use NEWID() to populate the column. It is NOT a self populating column. Then, you would check for an error... if...

Liuc -

you're correct - you now need to get permissions to that network folder for the account that is being used to start SQL Server. You may unfortunately...

True - but in order to enforce it now - I'm going to have to go review the .NET code as well.:)

True. It's not proof of anything. It's also being ramrodded down everyone's throat - so it's coming - like it or not. It's to the point where...

And another of the great ones falls....Wow. I owe him a lot as well - much in terms of imagination, and good times, too.

Agreed - if you want the consultant name - you need to have it in the main "from", and it needs to somehow be the base table. Not quite...

Jeff Moden (3/3/2008)

---

This is the second time I've seen this and I don't know how folks are doing it... I don't know how or why it says "Discuss Content Posted...

Also - you need to look up "parameter sniffing". It looks like you're falling victim to it.

I'm not sure what you're using the functions for - but I'd recommend...

Luke L (3/4/2008)

---

Express Does have a 4 GB db size limit as well, however I'd be more looking at limitations involved around no SSIS, no Sql Agent job Service, and...

GSquared (3/4/2008)

---

I have to admit, I didn't even try to read that view...

hmm - Not quite seeing it - but ok. It looked to me you might pull the same ad_image, but different ad_names in that case (since you can't have...