SQLTip

How to Process Multiple Dimensions via BIDS and SSMS

Posted by Jens Vestergaard on in Programming 1 Comment

This is one of those tips I need to write down, before I forget…
Sometimes Analysis Services acts up and you need to do a process full on all the dimensions in the database. When that happens I usually turned to Visual Studio Business Intelligence Development Studio [BIDS] or SQL Server Data Tools [SSDT], which allows you to select more than one dimension at a time, and fire up the processing. See figures below:

Via BIDS

Open a connection to a “live” database

Open Connection
Open Connection

Choose which server/database to connect to:

Choose Server/Database
Choose Server/Database

Select all dimensions and right-click:

Select dimensions
Select dimensions and right-click

Finally, choose processing mode:

Processing Mode
Processing Mode

Via SSMS

Until today, I didn’t know you could actually do the same action through SQL Server Management Studio [SSMS]. You do as following:

Connect to the server:

Connect to Server
Connect to Server

Expand till you get to the Dimensions folder:

Find the Dimensions folder
Find the Dimensions folder

Hit F7 to open the Object Explorer Details:

Select All and Right-click
Select All and Right-click

Select Processing Mode:

Select Processing Mode
Select Processing Mode

 

Loading

Never lose your server list in SSMS again…

Posted by Jens Vestergaard on in Programming 3 Comments

Having to install new laptops, re-install old ones, configuring virtual servers or whenever you get the opportunity to install SQL Server from scratch, you always end up with an empty list of servers, when you try to connect through SQL Server Management Studio (SSMS).

Empty List

There is a way around this minor, but still sometimes very annoying issue.
The information is stored in one file only, on the profile you are currently logged on to. So copying this file, from an existing setup or a shared repository (like SkyDrive or TFS), to the new environment will bring you up to speed really quick.

The file is named SqlStudio.bin and can be found at <DRIVE>:\Users\<PROFILE>\AppData\Roaming\Microsoft\SQL Server Management Studio\<SQLVersion>

Disclaimer:
I have not tested if any third-party tools register anything in this file, so beware and be sure to have the original file ready, in case of dissaster

 

Loading

SQL Server Quick Tip 26 – 30

Posted by Jens Vestergaard on in Programming 0 Comment

 

Loading

So you think you need Enterprise Edition, huh?

Posted by Jens Vestergaard on in Programming 2 Comments

Lately I have been struggling on a specific server in an environment I have been working on. Due to the need for partitioning in the cube, the project demanded an Enterprise Edition of SQL Server 2008R2. The only installation available, with Ent. Ed., had some 80+ databases, and several cubes, installed and running.

As I browsed through the databases, I noticed that quite a few of them could be run on a Standard Edition. I then turned to create a T-SQL statement, that would show which Ent. Ed. features was in use, in each database.

EXEC sp_MSforeachdb N'SELECT * FROM sys.dm_db_persisted_sku_features' 
GO

Turns out, none, zero, zip, nada of the databases uses any Ent. Ed. features. Imagine that.

Loading

SQL Server Quick Tip 21-25

Posted by Jens Vestergaard on in Programming 0 Comment

 

Loading