I don't see why, although if you're joining to system table-valued functions that might cause issues.

SQLMyFriend (5/4/2011)

---

That sounds just like what I heard from my former collegue.

He told me it will be a great pain when upgrading- you ignore the collation of older server, and...

Interesting question, thanks.

lance.kentwell (5/4/2011)

---

Doh! knew thre would be a catch things cant be that easy. Unfortunately it is a big table. If I use = and put the exact...

RichardDouglas (7/15/2010)

---

There's a book on amazon by Tom Carpenter SQL Server 2008 Administration: Real-World Skills for MCITP Certification and Beyond (Exams 70-432 and 70-450) has anybody used it? There are...

I had this "issue".

The database collation had changed at some point, so the older character columns (not tables - tables don't have collations) had one collation and newer ones had...

Keep in mind though, that LIKEs with leading wildcards are a recipe for poor performance - so careful if your table gets large.

Thanks for the question. I dithered a little as well, before selecting the "obvious" answer of 4. A good, non-trick question.

Brandie Tarvin (4/18/2011)

---

Duncan Pryde (4/18/2011)

---

No problem. Let me know if you need...

No problem. Let me know if you need anything else.

Duncan

Brandie Tarvin (3/11/2011)

---

I'm looking to upgrade my 2k5 DBA cert by taking 70-453 and just wanted to know if anyone's sat the exam yet.

I'm a generalist DBA and I'm trying...

Thanks for a good question.

rmechaber (4/13/2011)

---

Duncan, nice follow-up to your last question. I'm gratified? relieved? to see so many wrong answers, as I thought everyone else but me knew what Tibor Karaszi pointed...

Cliff Jones (4/13/2011)

---

A very good question. It is unfortunate that some are not getting the message that it is trying to convey, that not all date formats are portable...

Based on what I'd seen in question threads, it looked to me as though datatype/code/syntax questions were always popular, which a couple of you have confirmed here. It's perhaps because...