Thanks Scott, for the reply.  However, my question still remains unanswered...let me put it this way.

https://blogs.msdn.microsoft.com/sql_server_team/columnstore-index-performance-rowgroup-elimination/

https://www.sqlpassion.at/archive/2017/01/30/columnstore-segment-elimination/

As explained in the above blogs, for SQL engine to be...

thank you.

Are Azure SQL Data Warehouse and APS (Analytical Platform System) built on same MPP PDW architecture (nodes, distributions etc) ?

If so, while subscribing to Azure,...

many thanks for the replies.

The limitations I have is the DB I am working on (the Parallel Data Warehouse), which does not support XML PATH or Cursor.  However,...

thanks.

1) There are 5 steps in the sqlAgent job.

2) Each step has "Quit the job reporting failure" as On failure condition. Each step goes to next step if...

etl2016 (12/15/2016)

---

okay, I think I got the difference when i did the hex dump using convert(varbinary(max), sourcecolumn)

At source, the content looks like the character "En dash" with ASCII HEXcode...

okay, I think I got the difference when i did the hex dump using convert(varbinary(max), sourcecolumn)

At source, the content looks like the character "En dash" with ASCII HEXcode of...

Hi,

true, actually as a next step, i...

Hi,

Latin1_General_CI_AS is the collation at both source and destination (both of which are SQL server databases)

At source, the character is – (hyphen) and at destination, it is coming as...

Hi,

I am seeing that special character on my SSMS query, where as the actual data does not contain that character.

Basically, data type is varchar for both source and destination (not...

etl2016 (11/18/2016)

---

To quantify further, SELECT X, Y, z, count (*) GROUP BY X, Y, Z HAVING COUNT (*) = 1 should give the...

thanks for the reply.

Actually, I am trying to quantify the feature "grain of a table".

Say, you give "a table" and I should be able to tell its grain, irrespective of...

the combination of Motherboard and 8x8GB RAM and a few other combinations I opted for - were compatible, as offered by a local customised Desktop PC buid company.

Now, I am...

"...Other questions to consider, what version of SQL and OS are you considering.."

I am basically going for W10 64bit and latest Visual Studio and BI tools, Azue cloud computing etc

I...

thanks.

Sorry, missed one bit. I am willing to go for dual-monitor (27inch, 23 inch). From this context as well, do I or do I NOT need Graphics card or...

many thanks.

Every sunday evening 5pm is a cut-off mark and certain aggregations are to be done for that week, with Sunday 5pm as cut-off. As we know, whether...