Slowly Changing Dimensions
When designing a data warehouse, how you handle changes to dimensional data over time is the most important decision to make. It...
2012-02-03
1,221 reads
James Serra's Blog
Need to create a time dimension down to the millisecond?
Ok, I know that creating a time dimension down to the millisecond is extremely rare. After all, we are talking...
2012-02-01
1,260 reads
Complex reporting off a SSAS cube
While using a cube in SSAS is usually a great source for reporting, it is not always the best choice....
2012-01-30
2,334 reads
SSAS fact table dilemma
Here is a situation I ran into recently concerning using a fact table in SSAS. This experience may help you out if...
2012-01-27
1,274 reads
Improving cube processing time
As your SSAS cube gets bigger, cube processing time will become a problem. This is especially true as more and...
2012-01-25
11,343 reads
Want to recruit me? Please follow these rules
I get 15-30 calls/emails a week from recruiters (not counting the dozens of auto-generated emails I get). Being a contractor...
2012-01-23
904 reads
PASS Summit session videos online
If you are interested in viewing the recorded sessions for the PASS Summit 2011, you can order the DVD. You...
2012-01-20
887 reads
SQLInspire NYC 2011 Videos available
There are some FANTASTIC videos of the sessions from SQLInspire New York 2011. I highly recommend that you check out...
2012-01-18
531 reads
SQL Server 2012 (“Denali”): SSIS Logging
In previous SSIS versions as the developer you were responsible for configuring all of your logging options, such as what...
2012-01-16
1,219 reads
HP DL980…now this is a server!
I have been fortunate the past few months to be working on a HP ProLiant DL980 G7 Server. This is...
2012-01-13
947 reads
Blogs
SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries
If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't...
T-SQL Tuesday #186–Agent Jobs
By Steve Jones
It’s that time of the month again, when the T-SQL Tuesday blog party takes...
T-SQL Tuesday #186 - Agent Job History Visualization
By alevyinroc
I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs....
Forums
Execution Plan Operators
Comments posted to this topic are about the item Execution Plan Operators
Merge spans with Dates Logic
--for a given member if the startdate and endate is continous we need to...
Need help with merging data based on date and process
I have two sources , one coming from datalake and another is file. we...
Question of the Day
Execution Plan Operators
When looking at an execution plan in SSMS, what types of operators are shown?
See possible answers