A very nice article. Straight forward and practical advice. It's good to see these practices written about regularly, and I always like hearing the many various preferences that others express.

My...

Views (filtered) have been used for years to implement row level security.

vijay_download (11/1/2007)

---

Hi,

I m NOT using storedprocedure. I m using the ADO command object which will stored the compiled command text. I m passing only parameter value in UPDATE command text....

Robert O'Connell (7/10/2007)

---

The biggest downside to using SQL Server Compact Edition is that it does not allow the creation of stored procedures. This seems to be Access with a...

Jeff Moden (5/30/2008)

---

Howdy folks,

Someone who wishes to remain anonymous, send me an email asking the following questions related to this article. I've not worked with SQL Server 2008 (shoot,...

Yes. 2 should have been an option. I would have gotten it wrong then instead of testing it to get it right.

Nice QoD. We are destined to constantly forget the...

Interesting. It caught it coming and going(when i hit the Back button). It identified this one as Crossword1(1).htm.

Funny thing is, I remember doing that puzzle when it came out, and...

Ravi,

BitDefender didn't actually prevent the puzzle from loading and working. As far as I can tell, it just quarantined something that was traveling along with it.

I know you from other...

What the???

Virus Blocked Trojan.Script.2314!

Thanks Jeff, for some more COOL STUFF.

Most days I don't have time to read the more lengthy articles, but I did today, and I've been meaning to look into these...

I know this is a forum by and for SQL Server bigots but there is also the possibility that those of us who are strong in the .Net CLR and...

Pardon the redundacy, but does anyone have knowledge of, or better yet experience, porting 32 bit CLR functions to a 64 bit SQL Server.

I'm pretty sure that the 64 bit...

Thanks for starting up this topic Steve. I'm very interested in the pros and cons that others express on it.

Let me put this one at the top: What happens to...

I actually was trying to say 'turn my poorly worded comment...

GSquared (5/9/2008)

---

I would consider a question about the Resource database valid in an interview (or QotD). In the interview environment, if asked "What are the system databases in SQL...