- 56
- 134 329
Ted on MSSQL
เข้าร่วมเมื่อ 16 พ.ค. 2016
All things SQL Server. I am open to requests for new MSSQL topics, just let me know!
วีดีโอ
SSAS - Product Category Hierarchy from Star Schema
มุมมอง 1.1K7 ปีที่แล้ว
SSAS - Product Category Hierarchy from Star Schema
Database Engine Tuning Advisor Overview
มุมมอง 17K7 ปีที่แล้ว
Database Engine Tuning Advisor Overview
SQL Server Error and Transaction Handling
มุมมอง 2.2K7 ปีที่แล้ว
SQL Server Error and Transaction Handling
Get Running with Git Bash Command Line
มุมมอง 2.8K7 ปีที่แล้ว
Get up and running with GIT and GITHUB.
02 SSIS Call Stored Procedure From SSIS with Return Values
มุมมอง 5K8 ปีที่แล้ว
02 SSIS Call Stored Procedure From SSIS with Return Values
01 SSIS Load From Excel Files with For Each Loop
มุมมอง 17K8 ปีที่แล้ว
01 SSIS Load From Excel Files with For Each Loop
How can you do it so rather than navigating away from the main report, it opens the sub-report on the same screen as the main report?
i worked 10 years back in MDX and today watched your video to revise all things for an job interview and could able to recall all and felt confident.. excellent video. thanks dear
thanks ted worked 🙂
Hello. This video is so helpful. I would like the data conversion table you show. I apologize, but cannot find video note...I am dumb to navigate TH-cam and find it :( Could you please send or post some other way? Thank you for this video either way. You are so clear in your direction.
Thanks Ted for the great video. Very useful and easy to follow.
Thank you very much for this incredible video
Thanks partner this helped me alot
Crazy g, my mans spanking
Thank you, you really articulated this in such a clear and easy to understand manner. Much appreciated!
I could not find this info anywhere else. Thanks! Also loved the outro. No messing around :)
Thank you for this. I was trying to follow Microsoft's documentation and their instructions didn't really make any sense since they don't explain the variable you're putting on the ForEach Loop is actually the ConnectionString value via an expression.
This is a gold mine. Any chance you might be able to share the slides/notes?
Hi, Could you help me please? How can I use DAX to create measures?
You don't create measure with DAX you create calculations with DAX.
Thanks Ted. I had tried other explanations to no success but this worked perfectly.
Thanks!! Very helpful
Thanks Ted. It is an excellent video and the explanation given by you is outstanding. It helps me lot.
Cool video. At 3:05, if Xact_abort equals =-1, then it seems redundant to have a rollback transaction statement. I am somewhat new to how the engine works. If the rollback statement was not there, would SQLServer rollback the transaction anyway? When are rollbacks implicit?
well explained but need to speed up the tone a bit - I had to use 1.5 speed
Thank you so much! I have looked everywhere for an MDX tutorial, but with no luck. This was extremely helpful. I really appreciate it!
Very helpful
So Simple but so usefull. Thanks a lot!
Thank you very much for the incredible useful video. It clears up all important and confusing points about cube and MDX. I wish I had found it earlier :)
Hi Ted ( I assume this is your name), thanks a lot for this video, this was a great and really helpful video, This is a great start for me and much appreciated. Just a simple point: The AccountDescription must be selected as the NameCoulumn for AccountKey in the DimAccount, otherwise the cube shows the numbers (i.e. account key) instead of account description.
Great explanation...my favorite part? The length, haha.
thanks for the help.
thanks... it was really helpfully
Thank you!
Simple quick and to the point. Very helpful. Thank you!
Will this "start analyze button" actually run this query? I want to optimize update query but i dont want to run it. Ty
Great Ted ! The black screen does not help though.
Cool mate
Does map visual have drill down feature?
Thanks, Ted for the video. It has been of great help, I literally was struggling for a long time as I assumed Delay validation = True was to be set in the property for the FOREACH Loop Container.
Yes it's better be
Could you re-link the data type chart from Excel to SQL you mentioned in the video? The link doesn't work and i would be so grateful to have that cheat sheet.
it's Nov 2018 I'm on all most recent versions and I don't have <Directory> option under Collection in <For each loop> , can anybody knows why,
You definitely have the property of Directory, must have been due to weird design layout of the Editor Window you might have missed it. Once you are in collection, click on the furthest right on the Expressions. Once inside the Property Expressions Editor, you can set your Directory to your variable.
Excelent!! Thank you!!!
Nice
So clear and to the point. Thank you!
Thank you. Didn't understand that I had to set the group by in "(details)" until I saw your video. Saved me a lot of banging my head against the wall.
Thank you so much for the wonderful video :) Very neat presentation. I would recommend others
Great job, and thank you! I'm completely new to MDX, but this tutorial gave me a great breadth of knowledge quickly. Many videos are way too simple or too complex, this struck a very nice balance.
hi. The link is no longer working.
This is GREAT video , thanks for taking the time to make this !
Thanks a lot. It is the best session on MDX
Thanks for creating...Great Video!
Very nice. Detailed and precise at the same time. Can I get a link to download the presentation or email to jerish@hotmail.com
Tx, do you know how to refer to Worksheet name dinamically (single, or first one) Tx
Excellent Tutorial!! Very helpful, thanks!
Great! Thanks
Learned something new today! Thank You!