EasyBoy (4/16/2014)

---

Thanks Scott and Lynn for your inputs.

As suggested by Scott i have made changes in existing index with filtered index (suggested by Lynn). And i am able to bring...

TomThomson (11/5/2012)

---

The CHAR function depends on the effective default collation, not on any other collation however specified. It's fairly easy to get round it, although somewhat verbose: instad of...

Toreador (4/16/2014)

---

No it wasn't. According to the explanation it was in the dbo schema -...

mr_effe (4/17/2014)

---

I think this solution doesn't help me. Because a switch partition leads to a Schema-M lock. And if all of my parallel processes wants a schema-m lock nothing works...

I don't think it's a good question, or rather I don't think the answer and its explanation fit the question as stated.

The explanation says "Theodore confirmed the user...

Good question. Potentially useful to know this.

Good simple question.

I was surprised to see that 21% of replies thought the feature would be included in we edition and express edition. 😀

+1

A fairly nice question. I saw that this was just the question of a week or so ago in a new disguise, so picked the answer that you have...

I think "none of the above" is nearer to a correct answer than any of the other options, because no one of then is adequate on its own.

SET NOEXEC does...

Nice simple question. But I wonder if the 35% of responses from people who want to deallocate teh key think that the key is some kind of cursor?

SQLRNNR (4/9/2014)

---

sestell1 (4/9/2014)

---

timwell (4/9/2014)

---

For both versions I got this:

Msg 102, Level 15, State 1, Line 26

Incorrect syntax near 'GO'.

"None of the above" was not an option so I knew something...

That's fun. But I'm glad I didn't motice the heading, I might have been careless if I had noticed it and then I would have got it wrong.

Meth

Up