Microsoft and HP’s Database Consolidation Appliance
Microsoft and HP have announced another appliance, called the Database Consolidation Appliance (see my blog about the other two appliances). ...
2011-10-19
1,773 reads
Microsoft and HP have announced another appliance, called the Database Consolidation Appliance (see my blog about the other two appliances). ...
2011-10-19
1,773 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
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers