mishka-723908 (10/21/2016)

---

Thank you for your response

We are not sure yet whether to create it as clustered or not. This is something we will need to test with.

The deletes will...

mishka-723908 (10/21/2016)

---

We have a DataWarehouse with Large Fact Tables . The Some of the tables have about 30 to 60 Columns and we also have some denormalized tables that are...

DECLARE @yourTable TABLE(Name varchar(100), Salary money, dt date);

INSERT @yourTable VALUES

('SAM-1',$67,'20161021'),

('SAM-2',$34,'20161021'),

('SAM-1',$39,'20161020'),

('SAM-2',$45,'20161020');

SELECT

Name,

[21-10-2016] = SUM(CASE dt WHEN '20161021' THEN Salary END),

[20-10-2016] = SUM(CASE dt WHEN...

chocthree (10/21/2016)

---

When the term 'Power BI' is mentioned I think of a visualisation tool. A tool that can hook into various sources (flat files, websites, etc..) and then produce colourful...

Eric M Russell (10/21/2016)

---

Ed Wagner (10/21/2016)

---

Phil Parkin (10/21/2016)

---

chocthree (10/21/2016)

---

All, I thank you for each of your responses. Much appreciated.

Ok, here is the deal. I'm a little long in the tooth...

let me emphasize the recovery. You should practice restoring from a backup to a non-production database. This makes sure your backups are viable so you can restore a database...

I have never heard that SQL is dying. You are the first I have heard say that. While there is RDBMS I would imagine SQL being around. I can't see...

I learned about this not too long ago and think it's a good thing. Grant Fritchey touches on this in his excellent book, SQL Server Execution Plans (page 162):

Since the...

I have not ran SQL 2016 on Windows Server 2016 but Microsoft is pretty good about warning you during the install if the version is supported on the OS. I...

I'm thinking you could use ABS or IIF (ABS being the easiest and most efficient)

ABS:ABS(([Measures].[FMSA Monthly Activity].CurrentMember))

IIF:IIF

(

[Measures].[FMSA Monthly Activity].CurrentMember >= 0,

[Measures].[FMSA Monthly Activity].CurrentMember,

[Measures].[FMSA Monthly...

camiloecheverry11 (10/20/2016)

---

I need a query where I can get the results from column qty hand, qty allocated and qty backordered.

Without any DDL, sample data or anything about your data...

Taking what Luis put together, you can hide these rows by adding an isVisable column to your dataset. Then, for the Row Viability setting in SSRS use an expression that...

Easy.

Add a text box and for it's value use this expression:

=COUNT(Fields!{some non-nullable field from your dataset}.Value, "{your dataset}")

I know that this is a few weeks old but since there was no answer:

So will it be easier if I translate Cognos SQL queries and create SQL views...

Sqlsavy (10/19/2016)

---

Thank you all for the responses.

I've attached query plan with resrticated and unlimitted memory please have a look.

Thanks

query:

UPDATE dbo.table1

SET table1.field = somevalue

FROM dbo.table1 AS ABC

INNER JOIN dbo.table2 AS xyz...