Viewing 15 posts - 496 through 510 (of 2,462 total)
pietlinden (8/30/2016)
Is there a good beginner book on Multi-Dimensional / Tabular? I've been playing with DAX for a while (and I'm still terrible at it!)Especially one that covers security/RLS.
I...
-- Itzik Ben-Gan 2001
August 31, 2016 at 8:11 am
but I'm learning using DAX/PowerPivot/PowerBI. (gotta start somewhere!) and then I watched Brad Gall's presentation on Analysis Services. It's not a new video, but it made me wonder... if you...
-- Itzik Ben-Gan 2001
August 30, 2016 at 3:28 pm
I don't have enough Postgres experience to say how it compares to SQL Server but if you know what you're doing you can make a search-intense workload move pretty quick...
-- Itzik Ben-Gan 2001
August 30, 2016 at 2:15 pm
np!
-- Itzik Ben-Gan 2001
August 30, 2016 at 11:23 am
Just looking at this again, it appears (based on your sample data) that you are looking to do a rolling 3 year average. In that case, you want something like...
-- Itzik Ben-Gan 2001
August 30, 2016 at 10:54 am
A couple things.
First, the order by company in your window clause does not make any sense, I think you want it to be sorting by a date. Second, you...
-- Itzik Ben-Gan 2001
August 30, 2016 at 10:00 am
There are some scripts out there for how to add custom code to your report, you can also handle this through doing some SSRS grouping but each of these options...
-- Itzik Ben-Gan 2001
August 26, 2016 at 1:27 pm
MMartin1 (8/26/2016)
DECLARE @text VARCHAR(100);
SET @text= ' set
nocounto
n
...
-- Itzik Ben-Gan 2001
August 26, 2016 at 12:16 pm
The conventional wisdom is to use Linq to stream XML data. Note this article. I have never used Linq and have heard that it's slow for this; nonetheless, that's one...
-- Itzik Ben-Gan 2001
August 26, 2016 at 11:58 am
djj (8/25/2016)
Ed Wagner (8/25/2016)
Y.B. (8/25/2016)
ZZartin (8/25/2016)
Ray K (8/25/2016)
crookj (8/25/2016)
Ed Wagner (8/25/2016)
Alan.B (8/25/2016)
BWFC (8/25/2016)
Prefectday
Night
Stalker
Talker
Dead
Walking
Running
Jogging
blogging
-- Itzik Ben-Gan 2001
August 25, 2016 at 9:51 pm
I traveled a lot before my daughter was born and loved it. Since my daugther was born, I only travel when then wife and kid can come with. We're all...
-- Itzik Ben-Gan 2001
August 25, 2016 at 9:46 pm
We need more info but here's some code that may help:
-- (1) Some sample data, a sample calendar table for a specific year
IF OBJECT_ID('tempdb..#calendar') IS NOT NULL DROP TABLE #calendar;
DECLARE...
-- Itzik Ben-Gan 2001
August 25, 2016 at 9:17 pm
You can download this book for free: Performance Tuning With SQL Server Dynamic Management Views and it has the queries you are looking for.
-- Itzik Ben-Gan 2001
August 25, 2016 at 8:32 pm
Thx but that is not really the challenge...
What I need is an expression that will give me the 3 letters that follow the nth occurrence of the key word if...
-- Itzik Ben-Gan 2001
August 25, 2016 at 8:29 pm
Matt Miller (#4) (8/25/2016)
-- Itzik Ben-Gan 2001
August 25, 2016 at 3:57 pm
Viewing 15 posts - 496 through 510 (of 2,462 total)