pietlinden (9/15/2015)

---

Anybody using (and like) PowerView? Are there any good resources on it? I kinda like PowerPivot (just having a hard time getting my head around it)... but PowerView...

It helps with visualizing, but also when you create your cube the dimension usage tab will be populated for you.

sipas (9/15/2015)

---

PS Not sure what 'his columns are in the wrong order' means - they're in a different order, but how does that affect the ability to use CHECKSUM to...

Depends on what you are doing.

Suppose that I am running a daily ETL. I uses...

Yeah, but less collisions.

You need to integrate SSRS into SharePoint.

That should work, although I usually create my relationships in the data source view as well.

With such a big table, you might want to use table partitioning for archiving purposes.

Regarding the question: there are alternatives to get the row count:

SQL Server–HOW-TO: quickly retrieve accurate row...

Real developers use HASHBYTES 😀

Tee Time (9/14/2015)

---

Koen Verbeeck (9/8/2015)

---

$t@r (9/7/2015)

---

Yes i have installed the bar code font on server.But when a client sees the report they can't see the bar code on their machine..do...

btio_3000 (9/14/2015)

---

Question:

So let's say I have a default instance myServer of 2008R2 and its named instances

myServer\A

myServer\B

myServer\C

and now I want to side-by-side install 2014 having the same structure of A/B/C -...

Probably because with 0.999 SQL Server doesn't care what comes before...

First of all you need to join your data against a list containing all dates.

That can either be a calendar table, as Phil suggested, or you can generate one on...

Nice one, thanks.

rc 77550 (9/11/2015)

---

I've found 4 fields which cause the Conversion overflow.

1 example: "TotalRevenueLCY".

The total sum value in SQL: 858376803445.19000000000000000000

Min value: -2243974.89000000000000000000

Max value: 429080429080.00000000000000000000

When I put this field as only measure...