select *

from dbo.MyTable

cross apply dbo.MyUDF(MyTabe.Col1, MyTable.Col2) as MyUDF;

That's Cross Apply pseudo-code. You'll get better examples if you look up "Cross/Outer Apply" in Bing/Google/whatever. MSDN has articles on the...

I would tend to suspect the application code far more than the database. NVarchar is just fine with extended character sets.

Another possibility is user-input issues. Is your application...

I would say it depends on what operations you're doing on the data as you retrieve it. Also, what driver you're using for the connection. Quite possibly, you'll...

Are you familiar with using the Apply operator (Cross Apply and Outer Apply)?

With that, you can "join" a function to a table and pass in the values from the table...

Are you asking about Join statements in the From clause? You can include way more than 10, without nested queries.

This sounds like a homework/test question. Is it?

Jeff Moden (12/26/2011)

---

The Question: (well, sort of :-))

... do any of you see or have a problem with me writing and publishing an article on how to rapidly build test...

justforgroups2004 (12/22/2011)

---

Thank you for reply, GSquared! 🙂

I have two servers 7 and 2005. Never worked with SSIS, but just looked it up, and it appears to be a part...

Dev (12/23/2011)

---

In my case I also have 2 post-graduate degrees, one of which pertains managing a business and understanding these types of things. Like a techy MBA :)...

Sapen (12/22/2011)

---

Thanks for the script. I am thinking that the index was created around november 8th,2011. And they were atleast 2 sqlserver service restarts from then and also the server...

stourault (12/22/2011)

---

Thank you guys for the quick response and the ideas here are similar to what I've been testing out but one of the problems I have is that the...

Lutz, that won't get anything that's in both places (if that's possible), nor will it get anything that's in Bins but not in Lots (if that's possible). At very...

A trace might be easier on your server than a trigger, and will capture the same kind of information.

A non-replicated transaction is a non-replicated transaction, whether it's an insert (missing...

Does this essentially get you what you need?

;

WITH LB

AS (SELECT PartCode,

...

David Moutray (12/22/2011)

---

Heh. I'm glad I'm not the only one! ;-)...

I started with a book, SQL Server Bible, way back when. That worked for me.