Sign in
Microsoft SQL Server Development Customer Advisory Team
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Common Tasks
Blog Home
Email Blog Author
About
OK
RSS for comments
RSS for posts
Atom
Search
Tags
analysis services
BI
Big Data
Concurrency
Data Warehouse
Development & Programming
ETL
Hadoop
Manageability & Serviceability
Migration and Transition
OLTP
Performance and Scalability
PowerPivot
Query performance
Recommended Links
Reliability and Availability
Resource Utilization
sql
SQL Analysis Service
SQL Server
SQL Server 2008
SQL Server 2008 R2
SQL Server Best Practices
SQL Server Reporting Services
SSIS
Monthly Archives
Archives
April 2013
(2)
February 2013
(1)
December 2012
(1)
July 2012
(1)
June 2012
(1)
April 2012
(2)
March 2012
(1)
December 2011
(1)
November 2011
(3)
October 2011
(2)
September 2011
(1)
August 2011
(2)
June 2011
(2)
May 2011
(2)
April 2011
(2)
March 2011
(4)
February 2011
(5)
January 2011
(1)
December 2010
(1)
October 2010
(2)
September 2010
(1)
August 2010
(1)
July 2010
(1)
June 2010
(2)
May 2010
(3)
April 2010
(3)
March 2010
(4)
February 2010
(1)
December 2009
(3)
November 2009
(2)
October 2009
(1)
September 2009
(1)
August 2009
(2)
July 2009
(1)
May 2009
(1)
April 2009
(3)
March 2009
(4)
February 2009
(4)
December 2008
(1)
November 2008
(2)
October 2008
(6)
September 2008
(3)
August 2008
(1)
July 2008
(2)
June 2008
(1)
April 2008
(2)
March 2008
(1)
February 2008
(4)
January 2008
(7)
December 2007
(2)
October 2007
(3)
September 2007
(5)
August 2007
(1)
July 2007
(2)
June 2007
(5)
May 2007
(1)
April 2007
(1)
March 2007
(1)
February 2007
(1)
December 2006
(2)
October 2006
(1)
June 2006
(1)
May 2006
(1)
April 2006
(1)
March 2006
(3)
February 2006
(3)
December 2005
(2)
November 2005
(3)
October 2005
(2)
September 2005
(3)
August 2005
(2)
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft SQL Server Development Customer Advisory Team
New Best Practices Articles Published - Scaling Up Reporting Services 2008 vs. Reporting Services 2005: Lessons Learned
Posted
over 5 years ago
by
carl.rabeler
1
Comments
Reporting Services 2008 was able to respond to 3–4 times the total number of users and their requests on the same hardware without HTTP 503 Service Is Unavailable errors compared with Reporting Services 2005, regardless of the type of renderer. In stark...
Microsoft SQL Server Development Customer Advisory Team
New Best Practices Articles Published - Running Microsoft SQL Server 2008 Analysis Services on Windows Server 2008 vs. Windows Server 2003 and Memory Preallocation: Lessons Learned
Posted
over 5 years ago
by
carl.rabeler
1
Comments
Due to the improvements in the Windows Server 2008 memory manager related to the change in the algorithm for scanning pages in memory, SQL Server 2008 Analysis Services performed equally well during both partition and dimension processing with or without...
Microsoft SQL Server Development Customer Advisory Team
SQLCAT Toolbox
Posted
over 5 years ago
by
Sanjay Mishra
1
Comments
SQLCAT members have published several tools on Codeplex and other places. They are all consolidated here at SQLCAT.com. http://sqlcat.com/toolbox/default.aspx
Microsoft SQL Server Development Customer Advisory Team
Now is time to try SQL 2008
Posted
over 5 years ago
by
lingzhuz
1
Comments
SQL Server 2008 is just around the corner. SQLCAT has been working with our customers and partners implementing pre-release builds. We have a lot good lessons learned to share, here are some of the upcoming best practices papers: · Index Defragmentation...
Microsoft SQL Server Development Customer Advisory Team
New Best Practices Whitepaper published: "Best Practices for Migrating Non-Unicode Data Types to Unicode"
Posted
over 5 years ago
by
Sanjay Mishra
1
Comments
The database system in a company that is growing internationally must support multilingual characters in tables with Unicode data types. Existing d atabases that support only non-Unicode information must be migrate d from non-Unicode data type to Unicode...
Microsoft SQL Server Development Customer Advisory Team
Querying Dimension Members In Analysis Services
Posted
over 5 years ago
by
richtk
1
Comments
Many Analysis Services applications query members to populate a dropdown or find those that match some criteria – starting or ending with a string, existing with other members, having a member property with a certain value, whatever. For example, say...
Microsoft SQL Server Development Customer Advisory Team
Create a default measure in AS2005 cubes
Posted
over 6 years ago
by
Nicholas Dritsas
1
Comments
In some cases, it is not obvious or easy to create a default measure in AS2005 cubes. In fact, there is no default measure by default, which can lead to long query times for queries that specify no measures. We have seen slow behavior with several query...
Microsoft SQL Server Development Customer Advisory Team
Precision Considerations for Analysis Services Users Whitepaper now available
Posted
over 6 years ago
by
Denny Lee [MSFT]
1
Comments
For those of you whom want to know a little more about precision considerations for Analysis Services users, please check out this recently released whitepaper at http://www.microsoft.com/downloads/details.aspx?familyid=bae8beec-9892-4ecd-a9db-292254895f9c&displaylang...
Microsoft SQL Server Development Customer Advisory Team
Four new best practices articles are available
Posted
over 6 years ago
by
Denny Lee [MSFT]
1
Comments
Four new best practices articles are available at the SQL Server Best Practices site on Technet ( http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx ). Two of the articles are on Analysis Services Processing and Querying best practices: ...
Microsoft SQL Server Development Customer Advisory Team
Inconsistencies when using Drillthrough MDX with Perspectives
Posted
over 6 years ago
by
Denny Lee [MSFT]
1
Comments
Author: Denny Lee Contributors: John Desch, Kevin Cox Reviewers: Robert Zare DRILLTHROUGH MDX Overview DRILLTHROUGH MDX is a very powerful way to drillthrough to your original data source of detail data that make up the aggregations...
Microsoft SQL Server Development Customer Advisory Team
Renaming Olap Databases Issues within Analysis Services
Posted
over 6 years ago
by
Denny Lee [MSFT]
1
Comments
If you are view the XMLA script that is generated for an Analysis Services database, you will notice that there are both ID and NAME attributes. The reason Analysis Services has this differentiation is so one could rename an Olap database (which you could...
Microsoft SQL Server Development Customer Advisory Team
SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
Posted
over 6 years ago
by
carl.rabeler
1
Comments
Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services There are a variety of things that you can do to improve the performance of an individual MDX query. To begin, you must identify the source(s) of the performance...
Microsoft SQL Server Development Customer Advisory Team
Application Patterns and database performance: Complex Screens
Posted
over 7 years ago
by
Kevin Cox SQL Server
1
Comments
As promised way back in August, here is the first installment of a series of blogs on database performance from the application point of view. Complex screens can cause database performance problems when each control (grid, list box, etc) on the screen...
Microsoft SQL Server Development Customer Advisory Team
How can SQL Server 2005 OnLine Piecemeal Restore improve availability?
Posted
over 8 years ago
by
thomasda
1
Comments
Question 1: How can SQL Server 2005 OnLine Piecemeal Restore improve availability? Question 2: Can I recover a single object such as a table or specific partition(s) from a partitioned table? Answer: The question is how to get the greatest...
Microsoft SQL Server Development Customer Advisory Team
Optimize Recursive CTE Query
Posted
over 2 years ago
by
shauntj-us
1
Comments
Author : Shaun Tinline-Jones Reviewers: Lubor Kollar; Conor Cunningham; Steve Howard; Kun Cheng; James Podgorski; Jimmy May; Joseph Sack; Welly Lee; Neeraj Joshi; Keith Bauer Introduction We recently assisted a global ISV to address a performance...
Microsoft SQL Server Development Customer Advisory Team
Tuning Spatial Point Data Queries in SQL Server 2012
Posted
over 1 year ago
by
ndr
1
Comments
Written by : Ed Katibah, Milan Stojic, Michael Rys, Nicholas Dritsas Technical reviewers : Chuck Heinzelman Introduction : Spatial Point Data queries require particular tuning efforts to enhance performance and improve overall application throughput...
Microsoft SQL Server Development Customer Advisory Team
Review a working option to setup a SQL Server 2012 BI solution using Azure’s IaaS VMs
Posted
10 months ago
by
ndr
1
Comments
By: Nicholas Dritsas Reviewers: James Podgorski, Olivier Matrat, Sanjay Mishra Overview Azure’s Iaas VMs plus Virtual Networks can be used to configure easily a set of servers/VMs to host the main components of a BI solution. This process...
Microsoft SQL Server Development Customer Advisory Team
New version of Partition Management Utility supports SQL2012, ColumnStore Indexes
Posted
5 months ago
by
Stuart Ozer MSFT
1
Comments
A new version of the Partition Management Utility for SQL Server is now available on Codeplex at http://sqlpartitionmgmt.codeplex.com/ . This is a tool that helps you create necessary staging tables and indexes and associated check constraints, to support...
Microsoft SQL Server Development Customer Advisory Team
Hurricane Sandy Mash-Up: Hive, SQL Server, PowerPivot & Power View
Posted
3 months ago
by
Cindy Gross
0
Comments
For my #SQLPASS Summit 2012 talk SQLCAT: Big Data – All Abuzz About Hive ( slides available to all | recording available to PASS Summit 2012 attendees ) I showed a mash-up of Hive, SQL Server, and Excel data that had been imported to PowerPivot...
Microsoft SQL Server Development Customer Advisory Team
Self-Service BI Works!
Posted
1 month ago
by
Cindy Gross
0
Comments
When I talk to people about adding self-service BI to their company's environment I generally get a list of reasons why it won't work. Some things I commonly hear: I can't get anyone in IT or on the business side to even try it. The business...
Microsoft SQL Server Development Customer Advisory Team
Access Azure Blob Stores from HDInsight
Posted
28 days ago
by
Cindy Gross
0
Comments
One of the great enhancements in Microsoft's HDInsight distribution of Hadoop is the ability to store and access Hadoop data on an Azure Blob Store. We do this via the HDFS API extension called Azure Storage Vault (ASV). This allows you to persist data...
Microsoft SQL Server Development Customer Advisory Team
AlwaysOn Availability Groups Generate Network Traffic with No User Activity
Posted
11 months ago
by
Kevin Cox SQL Server
0
Comments
Author: Kevin Cox Contributors: Min He,Steve Lindell Reviewers: Sanjay Mishra, Juergen Thomas, Jimmy May Creating an availability group needs pings and status checks across the different servers involved. This accounts for approximately 500...
Microsoft SQL Server Development Customer Advisory Team
New Best Practices Articles are available (May 2007)
Posted
over 6 years ago
by
Denny Lee [MSFT]
0
Comments
You can check out the three new Best Practices Articles Predeployment I/O Best Practices http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx by Mike Ruthruff Partial Database Availability http://www.microsoft.com/technet...
Microsoft SQL Server Development Customer Advisory Team
Check out the exciting new SQL Server Best Practices website.....
Posted
over 7 years ago
by
thomasda
0
Comments
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. Drawing on the extensive experience and expertise...
Microsoft SQL Server Development Customer Advisory Team
New Best Practices Article
Posted
over 6 years ago
by
carl.rabeler
0
Comments
Scale-Out Querying with Analysis Services Using SAN Snapshots
Page 5 of 7 (151 items)
«
3
4
5
6
7