I would skip the 2008 exams as they are expired. I think you can still take them, but they won't give you a certification.

The 2012 exams are the way to...

Nice question Andy, thanks.

If you display the value of the parameter in a text box, does it look normal?

The only thing you can rely on is that the output will...

What is the data type of the parameter?

The final sort order has something to do with all the UNIONs. Since UNION filters out duplicates, merge joins are used in the execution plan.

This has some impact on the...

Grant Fritchey (5/19/2014)

---

I usually just refer to row and column. They may not be 100% ISO approved terms, but, everyone knows what you're referring to for the most part. And...

rodjkidd (5/19/2014)

---

GilaMonster (5/19/2014)

---

Grant Fritchey (5/19/2014)

---

jcrawf02 (5/19/2014)

---

As for el Potter, what irked you so much Grant? Was it the fact they were lost in the woods (and whiny, oh so very...

Nice question, thanks.

I always find it a bit strange when I read something like this:

"what are the optimal settings" <> "may be optimal"

Too bad the documentation doesn't really explain why...

Do you know by any chance which 2 records it is losing? At the beginning, at the end, somewhere random?

You have multiple queries/result sets in your stored procedure, that might give...

chandan_jha18 (5/16/2014)

---

I googled over this and found that PowerView can consume this data but what about the data which is already stored in the form of characters and this needs...

You have the only working copy of SQL Server 2012 where CTRL+SHIFT+D actually does something?

How about this:

WHERE NOT((T1.Branch = T2.Branch)

AND (T1.Branch = T3.Branch)

AND (T1.Branch = T4.Branch)

)

It is an Excel add-in and is part of the Power BI offering of Microsoft.

That means the data is read into Excel, which you'd have to read in with SSIS.

You...