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
What you should know if you are using Logical IOs to measure query plan quality
Posted
over 5 years ago
by
LuborK
6
Comments
One of the presenters at recent SQL Server Open World conference in Denmark ( http://www.miracleas.dk/index.asp?page=168&page2=323 ) suggested tuning SQL queries using logical IOs to measure quality of query plan. The IO count is returned for each...
Microsoft SQL Server Development Customer Advisory Team
What’s so BIG about “Big Data”?
Posted
over 2 years ago
by
Denny Lee [MSFT]
4
Comments
As announced during the PASS Summit 2011 Day One Keynote , we are diving deeper into the world of Big Data by embracing and contributing to the open source community and Hadoop. We’ve had a lot of good coverage on this topic with some examples...
Microsoft SQL Server Development Customer Advisory Team
Using ByAttribute or ByTable Processing Group Property with Analysis Services 2005
Posted
over 6 years ago
by
Denny Lee [MSFT]
3
Comments
As noted within the Analysis Services 2005 Performance Guide , there are some niche situations where setting the Processing Group property to ByTable provides more optimal processing than the default value of ByAttribute. In a customer scenario, we...
Microsoft SQL Server Development Customer Advisory Team
Why the obsession with random I/O within the context of SSAS?
Posted
over 2 years ago
by
Denny Lee [MSFT]
0
Comments
by Denny Lee As many of you know from the various blogs, whitepapers, and conferences from SQLCAT, there is a big obsession or compulsion toward I/O by various members of SQLCAT. If you’re not already familiar with this topic, definitely reference...
Microsoft SQL Server Development Customer Advisory Team
Reporting Services Scale-Out Deployment Best Practices
Posted
over 5 years ago
by
Denny Lee [MSFT]
1
Comments
Check out the the third of five technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series: Reporting Services Scale-Out Deployment Best Practices This technical note reviews the...
Microsoft SQL Server Development Customer Advisory Team
Concurrency Series: Why do I get blocking when I use Read Uncommitted isolation level or use NOLOCK hint?
Posted
over 2 years ago
by
Sunil Agarwal
1
Comments
Author: Sunil Agarwal Reviewers: Kun Cheng, Chuck Heinzelman, Shaun Tinline-Jones, Sanjay Mishra, Kevin Liu When using NOLOCK hint on the table or using read uncommitted isolation level, customers sometimes get surprised when they experience blocking...
Microsoft SQL Server Development Customer Advisory Team
Announcing SSAS Maestros v1.2
Posted
over 2 years ago
by
Denny Lee [MSFT]
1
Comments
We are proud to announce that SQLCAT will continue with the SSAS Maestros course in June and July in Redmond and Madrid. SSAS Maestros 1.2 Courses Join us for a five-day deep-dive course on Analysis Services 2008 R2 UDM and join the SSAS Maestro...
Microsoft SQL Server Development Customer Advisory Team
Watch out those prepared SQL statements
Posted
over 3 years ago
by
Kun Cheng
3
Comments
Author: Kun Cheng Reviewers: Sunil Agarwal, Chuck Heinzelman, Shaun Tinline-Jones, Prem Mehra Although not documented very well, the system stored procedures listed below are known to many SQL Server developers and DBAs. For more details, please check...
Microsoft SQL Server Development Customer Advisory Team
Concurrency Series: Minimizing blocking between updaters
Posted
over 2 years ago
by
Sunil Agarwal
0
Comments
Author: Sunil Agarwal Reviewers: Kun Cheng, Chuck Heinzelman, Shaun Tinline-Jones, Sanjay Mishra, And Kevin Liu When a transaction T1 modifies a row, it takes an X lock on the row for the duration of the transaction. If another concurrent transaction...
Microsoft SQL Server Development Customer Advisory Team
Proper partitioning can improve dramatically the writeback process when dealing with large data sets
Posted
over 4 years ago
by
Nicholas Dritsas
4
Comments
Proper partitioning can improve dramatically the writeback process when dealing with large data sets Author: Nicholas Dritsas Reviewers: Richard Tkachuk, Akshai Mirchandani CASE : Customer is using SQL 2008 and SSAS's writeback abilties to...
Microsoft SQL Server Development Customer Advisory Team
Resolving DTC Related Waits and Tuning Scalability of DTC
Posted
over 3 years ago
by
Mike Ruthruff
0
Comments
Author: Mike Ruthruff Contributors: Gert Drapers, Fabricio Voznika Reviewers: Prem Mehra, Jimmy May, Kun Cheng During a recent performance lab we encountered a large number of waits related to the use of distributed transactions. The specific...
Microsoft SQL Server Development Customer Advisory Team
New exciting BLOG coming from SQL Server Customer Advisory Team
Posted
over 8 years ago
by
marksou
7
Comments
Hello SQL Server Community! My name is Mark Souza and I work on the SQL Server product team and manage all customer programs. One exciting team that I manage is called the SQL Server Customer Advisory team (SQLCAT). This team spends 75% of their time...
Microsoft SQL Server Development Customer Advisory Team
Unexpected Consequences of Multiple Result Sets
Posted
over 2 years ago
by
ChuckHeinzelman
5
Comments
Author: Chuck Heinzelman Reviewers: Kevin Cox, Kun Cheng, Michael Thomassy In a recent customer engagement, I was presented with a problem that I have seen in the past and am surprised that I don’t see more often. Take the following table...
Microsoft SQL Server Development Customer Advisory Team
SQL Server 2008 Analysis Services Performance Guide now available
Posted
over 5 years ago
by
richtk
3
Comments
Thomas Kejser and I made some significant updates to the SQL Server Analysis Services Performance Guide for SQL Server 2008 - it's available here . Our hope is to keep it alive and make updates as necessary. So if there is something you'd like to see...
Microsoft SQL Server Development Customer Advisory Team
Using HierarchyID in SQL Server
Posted
over 4 years ago
by
Kevin Cox SQL Server
2
Comments
Implementing a hierarchy structure in a relational data base normally takes a bit of work. The new SQL Server data type for hierarchyID gives a good shortcut to the old methods, makes it faster to get a solution in place and makes it much easier to maintain...
Microsoft SQL Server Development Customer Advisory Team
Whitepaper About Star Join Optimizations
Posted
over 4 years ago
by
Thomas Kejser
0
Comments
When we talk to Data Warehouse customers – they often raise questions about the star joins improvements SQL Server 2008. Star join is a set of optimizations that provide some interesting performance gains in data warehouse workload. Instead of digging...
Microsoft SQL Server Development Customer Advisory Team
Using ProcessingGroup Dimension property option ByTable vs. ByAttribute may error with string keys
Posted
over 4 years ago
by
Nicholas Dritsas
1
Comments
Author: Nicholas Dritsas Reviewers: Thomas Kejser, Stuart Ozer In SSAS 2005 and later, there is a dimension property called ProcessingGroup. It has two values; ByAttribute (default) and ByTable. When you use ByAttribute, SSAS will send a SELECT...
Microsoft SQL Server Development Customer Advisory Team
Win a signed PowerPivot Architecture Technical Diagram at TechEd NA 2010!
Posted
over 3 years ago
by
Denny Lee [MSFT]
0
Comments
There are many reasons to go to TechEd North America 2010 in New Orleans this year. After all, it is THE event for developers and IT Professionals. And if you want to know more about PowerPivot, here’s yet another reason why you need to go. ...
Microsoft SQL Server Development Customer Advisory Team
Interesting observation with table > 1TB
Posted
over 5 years ago
by
Kevin Cox SQL Server
2
Comments
Interesting observation with table > 1TB We have a project using SQL 2005 with a table that is several terabytes. This table has a varbinary(max) column with an average length of 150k bytes. We needed a second copy of the table on a smaller test...
Microsoft SQL Server Development Customer Advisory Team
Full Text Indexing Terabytes of Files with SQL Server and Cloud Storage
Posted
over 3 years ago
by
Nicholas Dritsas
1
Comments
Author: Darko Sancanin, Nicholas Dritsas Reviewers and contributors: Lubor Kollar, Stuart Ozer, Michael Thomassy Business Case There are currently over 50 million files (over 10 Terabytes of data) that the customer is migrating into a custom...
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
SQL Server Migration Assistant (SSMA) v5.0 just released!
Posted
over 2 years ago
by
Mike Weiner - MSFT
2
Comments
Exciting news as earlier this week the SQL Server Product Group announced the release of SQL Server Migration Assistant (SSMA) v5.0! A product with the goal of further simplifying the user experience in automating the migration of Oracle, Sybase, MySQL...
Microsoft SQL Server Development Customer Advisory Team
Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot
Posted
over 2 years ago
by
shauntj-us
6
Comments
Author : Shaun Tinline-Jones Reviewers : Mike Ruthruff, Sanjay Mishra, Alexei Khalyako Not too long ago an ISV that developed solutions using SQL Server as the RDBMS, asked me how they could query a database as at a point in time. This was a relatively...
Microsoft SQL Server Development Customer Advisory Team
New Partition Management Tool Available on Codeplex
Posted
over 5 years ago
by
Stuart Ozer MSFT
2
Comments
As anyone working with partitioned tables knows by now, the process of creating stand-alone ‘staging’ tables to support switching data into or out of a partition can be a management challenge, especially if the design of the partition table or its indices...
Microsoft SQL Server Development Customer Advisory Team
New Best Practices Articles Published - Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
Posted
over 6 years ago
by
carl.rabeler
4
Comments
Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical capabilities. This capability frequently comes with a substantial cost in query performance...
Page 4 of 7 (151 items)
«
2
3
4
5
6
»