Will Summers (9/26/2008)

---

To be fair though, there are some new nice features as well. Here is one: being able to monitor a job running in the little popup dialog, after...

jpowers (9/26/2008)

---

Matt Miller (9/26/2008)

---

For what it's worth - this...

It does take some getting used to.

I do prefer the query editing interface better in SSMS, but it does suffer with some weaknesses. The "not remember window...

Remember though, that (non-indexed) views don't get their own execution plans. In a way - they don't get optimized on their own at all.

This is because when a view...

Views don't have parameters, so that's not in the options to track down. This is unfortunately one of the red flags (when you start encapsulating views within other views),...

jcrawf02 (9/26/2008)

---

Matt Miller (9/26/2008)

---

Why people don't actually use probationary periods for what they're designed for (i.e. figure out if someone is a slug, and if they are - they're history)...

For what it's worth - this has been previously...

HanShi (9/24/2008)

---

juliane26 (9/24/2008)

So I follow that in table B I have more than one entry for each value in c1. (I will check on this)

If so - why...

Of course - the "tasks", "generate script" option for a single object is the old Howitzer as a fly swatter. Just right-click on the function and use the "script...

Regular Expresssions. It's the CLR object/language/syntax usually used to parse out ugly/complex patterns in .NET.

It's in the scripting options you pick. If you don't choose "script CREATE", it will default to the ALTER syntax. (which doesn't do the sp_executeSQL thingie from what I...

thusi (9/25/2008)

---

Thanks for the quick feedback Matt. Your 1st suggestion certainly helps. The criteria table itself is not entirely static cos we want to be able to say "these are...

Actually...

Also - for what it's worth. Since you did post in the 2008 forum, you might consider using the new SQL 2008 feature allowing you to build and pass...

I meant - something like a table where you load in the lists of values. For example, in the case you mentioned (where you're looking for patients that...