I'll be working pretty much until I die. :w00t: Forget social [in]security, the government has already spent every penny you paid in and when that ran out they borrowed and...

tcorrigan5 (4/30/2012)

---

Here's an article from the Chicago Tribune that describes an entirely different viewpoint at Facebook:

Facebook's rite of passage into the 'Hacker Way'

The money quote

What other Silicon Valley companies "don't...

What a radical idea.... holding someone accountable.

I would add a non-clustered index on parentsectionid alone and see how that works out. Another option is to include the sectionid in that index.

My guess is that the...

SQLKnowItAll (4/18/2012)

---

sturner (4/18/2012)

---

You are right. Every design should be normalized. But vb programmers are pretty much clueless. They typically want to get everything they need in a single select with...

You are right. Every design should be normalized. But vb programmers are pretty much clueless. They typically want to get everything they need in a single select with no JOINs.

Design...

You would have to do some Googling, I don't know any off the top of my head. An FTP (sending) service of which I was referring would be stand...

If you are doing this as a regular part of your production environment I would recommend using a dedicated service to handle FTP requests. The service actually doing the http://FTP...

The only other option you have on a database level is the trustworthy option. If trustworthy=OFF then CLR assemblies marked unsafe or external access will not run.

Whatever login the cold fusion is using needs access to be granted access to the symetric key and/or the certificate you used.

yes.

implementation specifics would be useful to help you. Are you using the same login credentials from coldfusion as you are when you connect via SS management console?

Ya know what Joe? You are 100% correct. Your posts may sound arrogant but the plain fact is...

certificates can be stolen or hacked. Authentication needs to have some real-time component if it is to be completely secure. I like having to use a combination PIN/Password and...

consider adding STATUS column to the non-clustered index, either as part of the composite or as included column. (which way would depend on several things but you could try it...