Performance tips for SSAS
Over the past few years I have developed a list of ways to improve performance in SSAS and in two...
2011-10-17
4,137 reads
Over the past few years I have developed a list of ways to improve performance in SSAS and in two...
2011-10-17
4,137 reads
In SSAS, to improve query performance, it’s important to understand what happens inside analysis services when a query is run. ...
2011-10-14
1,216 reads
Some announcements and notes from SQL PASS Summit 2011, going on this week:
It was announced that the official name of the...
2011-10-13
1,637 reads
Some announcements and notes from SQL PASS Summit 2011, going on this week:
It was announced that the official name of the...
2011-10-13
981 reads
In SSAS, there is an Error Configuration object that is central to the management of data integrity errors.
The following picture...
2011-10-12
2,435 reads
Here is a quick example of when using temporary tables will give you a big performance gain. I recently was...
2011-10-10
881 reads
When building a SSAS cube, you typically have a star schema containing dimension tables and fact tables. For dimension tables,...
2011-10-07
2,243 reads
If you are the decision maker in your company and you are tasked with purchasing one or more servers to...
2011-10-05
1,301 reads
In our day-to-day activities, browsing the web is one of the most important aspects of our job. Whether researching for...
2011-10-03
802 reads
Microsoft has made available SQL Server appliances and reference architectures that allow customers to deploy data warehouse (DW), business intelligence (BI) and...
2011-09-30
3,769 reads
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers