Stefan Krzywicki (12/19/2011)

---

Revenant (12/19/2011)

---

Yes,...

Ah yes, I well remember the first time I started breathing! Many Shuvs and Zuuls knew what it was to be roasted in the depths of the Slor that...

I wasn't planning on...

The model database should usually be in Full recovery, so that new databases are in Full recovery when you create them. That's the default for a reason and you...

Oksana March (12/17/2011)

---

All the answers so far have been criticism or jokes. Nobody found it useful to know what they ask at real interviews???

Anyway, I am not currently looking for...

Your sub-query that gets the max date doesn't have the same criteria as the outer query. Is it possible there's a date in there that's higher than the max...

Have you taken a look at OpenRowset and OpenQuery?

jcrawf02 (12/16/2011)

---

By the way, if anyone feels so inclined, prayers and happy thoughts would be appreciated for my family today. No more info at the moment, I might share in...

Anyone up on converting flavors of UTF one to the next? http://www.sqlservercentral.com/Forums/Topic1222485-146-1.aspx

That'll be UTF-8 in the Unicode .csv file, per what I'm seeing in a search or two on the subject. Try Googling/Binging "unicode csv" and see if that helps.

Converting...

Most CSV files I've worked with are .txt/.csv, which means ASCII, not Unicode at all.

GREAT way to start Friday! LOL! Thanks!

brad.featherstone (12/15/2011)

---

Sounds like you are used to a larger organization.

Scale does matter. In the Small/Medium Business (SMB) world the person who fills the DBA role frequently fills the data...

I really can't speak to the validity of the code. Yes, it's a valid query, in that in compiles and returns results. But as far as being business-correct,...

NVarchar is stored in (essentially) UTF-16. Can you convert from that in whatever solution you need UTF-8 in?