wilks (7/1/2014)

---

I would always argue in favour of the first method if only in terms or readability and assumed there couldn't be much difference, however, when checking the stats, the...

Kenneth.Fisher (7/1/2014)

---

Yes if you use KILL to end a transaction it will be rolled back and any changes made by that transaction will no longer exist. Unfortunately sometimes there...

If the cube is unprocessed, you can't see it in Excel or browse it in any other client application.

If it fails to process, it will remain unprocessed. If it completes...

Going further even if I don't like to give the complete solution. You could show some effort on trying the solutions and recommendations.

Using Sean's sample data:

SELECT SomeID,

...

A friend of mine was asked to check the lamp from the...

Am I missing something in here?

What are you expecting to get from this? It might affect performance and the result should be the same...

What happens when you have more than 2 numbers?

You could use the Pattern Split explained on this article: http://www.sqlservercentral.com/articles/String+Manipulation/94365/

Declare @X varchar(100)

Select @X= 'Here is some text 15234 here is some...

Basically, the article is describing the need for clustered indexes and not precisely the need of Primary Keys.

PKs are used for referential integrity and are part of the logical design.

CI...

Congratulations Koen. You're certainly one of the top posters on Bi.

On a completely different subject, I'm taking 20467BC course this week and found some surprises like using while loops...

Is that id an identity column? Could you remove the identity property to be able to update it with a ROW_NUMBER() by the natural key? Or simply use the ROW_NUMBER...

ORDER BY doesn't seems logical on an ETL process. Why would you need it?

Thak you for the feedback.;-)

Agreed, you don't need a cursor but you might not even need a udf. If you share the code, we might be able to help you to speed this query....

I've found the same problem since the site was migrated. I hope everything comes back to normal soon.