UNION queries are evaluated from left to right. If the last query contains duplicates and is preceded with UNION ALL, you will have duplicates in your result set.

I can't seem to find any official documentation of that command.

You're sure you didn't issue an ALTER INDEX or DBCC command?

Aaah, don't say that on this site. Many DBA's will get a heart...

You can start by doing research on what a deadlock is and how to prevent it.

Use profiler to find out which resources are blocking each other and try to resolve...

As already mentioned, a lot of options exist.

Excel is the most notorious one, where you can create a PivotTable on top of your cube.

Most BI clients can connect to SSAS....

What's the question?

What's a positional file?

Can you explain your scenario a bit more?

What is your source? First it is a table, than it is a file.

We need to know this or we can't help you.

Well, at the end, this question has not much to do with SSIS or SQL, so maybe you have more luck in a .NET forum?

Jack Corbett (3/7/2012)

---

I don't think that there is a way to do this. I think you'd be better off going with a file configuration and deploying the...

Is it not an option to create a stored procedure from that .sql file?

What did you do exactly? Which statements did you use?

Another great back to basics question. Thanks!

Nope, I haven't seen VS 11 beta yet. Now I'm not really sure if I want to 🙂

I also had the issue with distributed replay controller with RC0.

Alex Bransky (3/7/2012)

---

Thanks all, that helps a lot. I could easily create a report for it but I'm trying to give my users a single place where they can...