MDX Calculations Across Multiple Calendars Using Nested SCOPEs (SQLServerCentral 10/10/2016)

Laden...

8 jaren geleden

Html
Tekst

A community of more than 1,600,000 database professionals and growing

Featured Contents

MDX Calculations Across Multiple Calendars Using Nested SCOPEs Azure SQL Database - Azure AD Authentication Know Why to Use log_reuse_wait_desc Column In sys.databases (From the SQLServerCentral Blogs) Pinned Tabs (From the SQLServerCentral Blogs)

Featured Script

Change datetime

The Voice of the DBA

What do you do or think about on the way to work?

I am not sure how long your commute is to work each day. I recently changed jobs and my commute time doubled as my new position is all the way across town. I went from going 15 miles (24km) into work every day, to going 30 miles (48km) instead. I found myself with more time during my commute and some questions came to mind. Now I am sure there are some of you that have a lot further to go to get to work, but that isn’t what I wanted to talk about today.

I was driving to work a last month. Yes, I live in the U.S. and like a lot of people here, I drive to work. Anyway, I started thinking about what do other people do or think about during their commute. I know there are many people that take the bus or the train to work. Certainly this is true in other countries, still there are many here in the states that take mass transit also. So for them there is a whole range of things they could possible do on the way into work. Sleep, eat, read, do work (yuck!). Clearly for people driving, most of their attention needs to be on the roads and on what is going on around them.

As for me, I have my normal routine. I leave early. Usually not long after 6:00am, I am on the road. It seems if I can leave by 6:10 traffic isn’t too bad on the way in. I usually have my radio on, although not too loud. I tend to pray, think about the day. Yes, sometimes I do think about work. Then it occurred to me. What are all these other people doing? Who are they? Where did they come from? Where are they going? What is their story? What are they thinking about?

It amazes me how many people there are each day travelling to work. I am sure that some of you, that take a bus or train, see some of the same people every day. Perhaps you have the opportunity and have the boldness to talk with them and get to know them. For me, I don’t even get past seeing just cars. Rarely, do I look past the vehicle to person inside. I am just trying to get safely to work/home and avoid the crazies.

Recently some of my thoughts on the way in to work were:

Why did that person just cut me off? What is going on in their life that they acted that way? Do they really think they are so much more important than me that they are trying to run me off the road? Why do they think it is okay to drive so far over the speed limit and endanger everyone around them? Why is that person riding my bumper?

These are some of the things I have thought about during my commute. Sometimes these thoughts help me understand my follow commuter. Sometimes they just help past the time.

Share what you think about or do during your commute.

Ben Kubicek from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

Track schema changes for free

DLM Dashboard tracks SQL Server databases to show you exactly what schema changes have been made, by who, and when. You get a full history, with line-by-line differences, and a clear audit trail of your database moving from development to production. Download free tool.

Library of articles for Database Lifecycle Management

Discover a collection of articles about database lifecycle management – covering best practices for your team and tips on each stage in your journey from version control to deployment. Find out more on Simple-Talk.

How to fix SQL Server disk I/O bottlenecks (without a hammer)

In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.

Featured Contents

MDX Calculations Across Multiple Calendars Using Nested SCOPEs

Paul Burton from SQLServerCentral.com

A solution to the problem of multiple calendar calculations within SSAS Multimdimensional cubes using nested SCOPEs More »

Azure SQL Database - Azure AD Authentication

Additional Articles from Database Journal

One of the challenges when considering migrating your on-premises SQL Server databases to Azure SQL Database is its lack of support for Active Directory-integrated authentication. With the advent of Azure SQL Database V12, the authentication capabilities have been expanded, allowing for more flexibility that leverages Azure Active Directory. In this article, Marcin Policht provides an overview of this functionality. More »

From the SQLServerCentral Blogs - Know Why to Use log_reuse_wait_desc Column In sys.databases

zorastalin from SQLServerCentral Blogs

Introduction Most of the time, while working with SQL Server, the transaction log files usually grows due to numerous reasons. Out... More »

From the SQLServerCentral Blogs - Pinned Tabs

Kenneth Fisher from SQLServerCentral Blogs

It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b)... More »

Question of the Day

Today's Question (by GP Van Eron):

You have recently patched one of your SQL Server 2012 Standard Edition instances to SP3 bringng the version to 11.0.6020.0. In SSMS, you execute the following

SELECT @@VERSION SELECT SERVERPROPERTY('PRODUCTUPDATELEVEL')

What will be the result of the second line?

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: SERVERPROPERTY.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

Pro Power BI Desktop

This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

Which languages are allowed for the @language parameter in sp_execute_external_script in SQL Server 2016?

Answer: R only

Explanation:

In SQL Server 2016, only R is allowed as a valid value for the @language parameter.

Ref: sp_execute_external_script - https://msdn.microsoft.com/en-US/library/mt604368.aspx

» Discuss this question and answer on the forums

Featured Script

Change datetime

S M from SQLServerCentral.com

Copy the script and execute. You can change parameter values if you want.

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

extract all Urls from string - Hi all, I have string like this : [code="sql"] DECLARE @input NVARCHAR(max) = ' hihihi hihihi hihihi https://telegram.me/joinchat/BW0OCzvs1F6frTkUj2HEAQ hihihi hihihi hihihi https://telegram.me/joinchat/DigSjj6xZYsI_H2GRjtNQQ hihihi hihihi hihihi hihihi http://telegram.me/ZOJ20/10236 ' [/code] and I want to extract all Urls from this string : result -------- h

Select all child nodes - Hi, I have table like this : [code="sql"] DECLARE @t TABLE ( Id INT , XmlData XML ); INSERT INTO @t (1, XmlData ) VALUES ( '<News> <nNewsID>82172275</nNewsID>...

SQL Server 2014 : Administration - SQL Server 2014

alpha fuel testo Reviews | Muscle & testosterone Boost? - It is advanced with vitamins that the body toughening in the procedure for since quite a while back required result....

Wash down after you workout as your - Wash down after you workout as your pores might be [url=http://infosupplement.com/luminis-skin-serum-reviews]Luminis Skin[/url] stopped up with sweat after you work out...

Checking SQL database mirroring health - Hi Gurus, There is database mirroring currently setup in my environment. I do not want to use SQL management studio (database mirroring...

The balance of minuscule living beings - The balance of minuscule living beings is crucial for good [url=http://myhealthycafe.com/glucotrim]GlucoTrim[/url] limit of retention system Everyone should have the best...

The entire exertion additionally takes care of the skin generously. - The entire exertion additionally takes care of the skin generously. [url=http://www.garciniacambogialean.com/coal-cosmetic-moisturizer]coal cosmetic moisturizer[/url] Along these lines, plainly over the long haul...

Log_Reuse_wait_desc - Experts, Our DB is in Full recovery mode . The total DB size is 25GB and 15GB is log file . We are...

Unable to restore over a database consistantly - We have 2 databases. Database 1 is used by our intranet webpage and ourWeb Development team use Entity Shell for...

Unable to connect to the Report Server from SSMS - Hi, We have report server for the named instance. When I tried to connect from SSMS, I am unable to connect....

SQL Server 2012 : SQL 2012 - General

Perfmon - Hi All can someone please explain this graph for perfmon, how to calculate flushes in KB from the two counters?,...

SQL Server 2012 : SQL Server 2012 - T-SQL

"Add" Hyphen Data Modification - Hello, First time poster on this forum. I've recently been thrown into the world of SQL server, so my experience is...

update 3 tables with the same primary and foreing key values - In t-sql 2012, I want like to update 3 tables at the same time. I would like the lockid value...

SQL Server 2008 : SQL Server 2008 - General

hare the rights to the city's Home Territory and - hare the rights to the city's Home Territory and

SQL Server 2008 : T-SQL (SS2K8)

Select Distinct and sum - Hi there i am trying to output just 2 columns WITH THE RESULTS COLUMN A COLUMN B HOUSE NAME TOTALS HOUSE A...

Reporting Services : Reporting Services

Calculate dynamic columns - Hello team, On Sql Server Report Builder, I'de like to know how to calculate dynamic columns or how to deal with...

Programming : Connecting

Prison inmates are teaching testy dogs - [url=http://www.unl.edu/english/webform/news/Bills%20vs%20Rams%20Live%20Stream%20FRee%20OnlineWebcast%20NFL%20Week-%205%20Sports%20LA%20Memorial%20Watch%209%20Oct%202016.pdf]Bills vs Rams Live Streaming[/url] [url=http://www.unl.edu/english/webform/news/StrEaMFact%20Cowboys%20vs%20Bengals%20L-ive%20S.tr-eam%20AT%26T%20Week%205%209th%20Oct%202016.pdf]Cowboys vs Bengals Live Streaming[/url]

Hurricane Ivan from the ISS - [url=http://www.unl.edu/english/webform/news/%5BFOXSports%20Falcons%20vs%20Broncos%20L-ive%20S.tr-eam%20Authority%20Field%209th%20Oct%202016.pdf]Falcons vs Broncos Live Streaming[/url] [url=http://www.unl.edu/english/webform/news/%5BStrEaMCBS%5D%20Bills%20vs%20Rams%20L-ive%20S.tr-eam%20Los%20Angeles%209th%20Oct%202016.pdf]Bills vs Rams Live Streaming[/url] [url=http://www.unl.edu/english/web

Data Warehousing : Integration Services

Foreach File Enumerator loop qith Excel files - Hi, I have a package that is using a Foreach File Enumerator loop to go through a folder and pull in...

Data Warehousing : Strategies and Ideas

Star Schema Design - Multiple Sources - Hi, I am planning the design of a star schema for a data warehouse. The data will be loaded from 2...

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.

This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.

Deel deze op

Laden...

Andere nieuwsbrieven van Sqlservercentral.com

A Trigger... just not that kind Sqlservercentral.com
Gisteren om 05:10
Configuring Maintenance Plans in SQL Server (20 24-02-21) Sqlservercentral.com
Afgelopen vrijdag om 08:17
How to Resolve SQL Server Database Stuck in Rec overy Pending State (2025-02-19) Sqlservercentral.com
Afgelopen woensdag om 08:13

Meer nieuwsbrieven van Sqlservercentral.com

Laden...

MDX Calculations Across Multiple Calendars Using Nested SCOPEs (SQLServerCentral 10/10/2016)

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

What do you do or think about on the way to work?

Featured Contents

MDX Calculations Across Multiple Calendars Using Nested SCOPEs

Azure SQL Database - Azure AD Authentication

From the SQLServerCentral Blogs - Know Why to Use log_reuse_wait_desc Column In sys.databases

From the SQLServerCentral Blogs - Pinned Tabs

Question of the Day

Today's Question (by GP Van Eron):

Think you know the answer? Click here, and find out if you are right.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

Featured Script

Change datetime

Database Pros Who Need Your Help

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

SQL Server 2014 : Administration - SQL Server 2014

SQL Server 2012 : SQL 2012 - General

SQL Server 2012 : SQL Server 2012 - T-SQL

SQL Server 2008 : SQL Server 2008 - General

SQL Server 2008 : T-SQL (SS2K8)

Reporting Services : Reporting Services

Programming : Connecting

Data Warehousing : Integration Services

Data Warehousing : Strategies and Ideas

Deel deze op

Andere nieuwsbrieven van Sqlservercentral.com

Gerelateerde nieuwsbrieven