Eric M Russell (5/21/2014)

---

I've seen fact tables in a star schema model with 20+ foreign keys. By default, foreign keys are not indexed, and nor should they generally speaking. Actually,...

Had a quick look at it again and discovered minor snags:-D

Firstly, this is not going to work for more than one customer at a time so I added a variable...

Hugo Kornelis (5/20/2014)

---

I decided to run a quick experiment to see if I could find any limits. Here is the code I used to create a table with lots of...

Just had the chance to to a quick test, the physical table splitters seems to be at...

TomThomson (5/20/2014)

---

Nice question, clear, unambiguous.

But it's kind of interesting .... you know that Chinese proverb (or maybe urban myth?) about interesting times?

The interesting thing here is that 253...

Good stuff!

😎

Marcus Farrugia (5/20/2014)

---

Hi, I'm trying to get the difference between the two times in minutes with the seconds rounded up or down

As an example the difference in the times:

1900-01-01 09:27:49.000,...

This is often used when dynamically creating the where clause, simplifies the script as all conditions start with the "AND".

😎

Check for missing/empty values, these are known to cause this error. A workaround would be to "replace" the missing values with 0 (zero).

😎

I got stumped with work, be back to you tomorrow:cool: or as soon as I can.

Ok, next thing then, is there a varchar(max)/nvarchar(max) (text_stream) or a float/real column in the dataflow?

😎

Now that...

Do replace char(13)+char(10) with '' ( empty string)

😎

Edit: character code.

Check line 4489 for an extra delimiter character

😎

A simple way would be along these lines

😎

USE tempdb;

GO

DECLARE @DSET TABLE

(

ClassName VARCHAR(50) NOT NULL

,NAV ...