Featured
Authors : Sanjay Mishra, Prem Mehra Technical Reviewers : Lubor Kollar, Michael Thomassy, Lindsey Allen, Mike Ruthruff, Kaloian Manassiev, Kevin Cox, Thomas Kejser, Mike Weiner, Mark Souza, Joseph Sack, Glenn Berry (SQL Server MVP) Overview A frequently ... More
Whitepapers: Deep level technical whitepapers on specific SQL Server best practices.
-
1,855 Views
Comments
Writers: Sung Hsueh, Antony Zhong, Madhan Arumugam Technical Reviewers: Claude Lorenson, Clifford Dibble, Lindsey Allen, Sambit Samal, Sethu Kalavakur...
-
1,668 Views
Comments
Writer: Fernando Caro Technical Reviewers: Jimmy Wu, Sanjay Mishra, Qingsong Yao, Juergen Thomas, Burzin Patel, Wanda He, Tres London Published: October...
-
3,738 Views
Comments
Writers: Manaphan Huntrakoon, Nicholas Dritsas Technical Reviewers : Burzin Patel, Sanjay Mishra Published: August 2009 Summary: An essential part of IT...
-
2,484 Views
Comments
How Microsoft adCenter takes advantage of groundbreaking performance and scalability enhancements and innovative design tools available with Microsoft...
-
2,100 Views
Comments
This article describes how to update Office SharePoint Server farms with minimal downtime. By following the procedures in this article, you can update...
-
8,624 Views
Comments
Writer: Thomas H. Grohser (=tg=) Contributor: Lindsey Allen Technical Reviewers : Sanjay Mishra, Lubor Kollar, Stuart Ozer, Thomas Kejser, Juergen Thomas...
View All Articles>
Technical Notes: Deep level technical short papers on specific SQL Server topics
-
2,049 Views
Comments
Authors : Sanjay Mishra, Prem Mehra Technical Reviewers : Lubor Kollar, Michael Thomassy, Lindsey Allen, Mike Ruthruff, Kaloian Manassiev, Kevin Cox, Thomas...
-
681 Views
Comments
Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson, Steve Pontello, Thomas Kejser ASLB is a custom...
-
2,858 Views
Comments
Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson, Steve Pontello, Thomas Kejser This technical...
-
2,499 Views
Comments
Author: Alexei Khalyako Contributors : Dmitry Artemov, Sergey Pyrin Technical Reviewers: Vijay Tandra Sistla , Mike Weiner, Mark Souza Editor: Beth Inghram...
-
6,524 Views
Comments
Authors : Ayad Shammout (CareGroup Healthcare), Denny Lee Technical Reviewers : Lukasz Pawlowski, Sanjay Mishra, Prem Mehra, Michael Thomassy, Lindsey...
-
7,601 Views
Comments
Author: Carl Rabeler Reviewers: Prem Mehra, Troy Starr, Kevin Donovan, Burzin Patel, Doron Bar-Caspi, Prash Shirolkar, John Wyss This technical note describes...
View All Articles>
Top 10 Lists: Review our summary list of best practices, recommendations, and common issues.
-
18,523 Views
Comments
Author: Carl Rabeler Reviewers: Mark Souza, Prem Mehra, Lindsey Allen, Mike Weiner, James Podgorski, Donald Farmer, Robert Bruckner, Sanjay Mishra, Lukasz...
-
32,433 Views
Comments
Author: Mike Weiner Contributor: Burzin Patel,Sanjay Mishra Reviewers: Lubor Kollar, Kevin Cox, Bill Emmert, Greg Husemeier, Paul Burpo, Joseph Sack, Denny...
-
9,671 Views
Comments
Author: Burzin Patel Contributor: Kun Cheng Reviewers: Sanjay Mishra, Denny Lee, Mike Ruthruff, Sharon Bjeletich, Mark Souza, Peter Carlin, Hermann Daeubler...
-
14,683 Views
Comments
Author: Joseph Sack Technical Reviewer: Burzin Patel, Juergen Thomas, Lindsey Allen, Justin Erickson SQL Server 2008 failover clustering introduces several...
-
61,049 Views
Comments
Authors: Thomas Kejser, Denny Lee Contributors: Runying Mao Technical Reviewers: Burzin Patel, Kevin Cox, Peter Carlin, Mark Souza, Richard Tkachuk, Len...
-
29,282 Views
Comments
Contributors : Stuart Ozer, with Prem Mehra and Kevin Cox Technical Reviewers : Lubor Kollar, Thomas Kejser, Denny Lee, Jimmy May, Michael Redman, Sanjay...
View All Articles>
SQLCAT Blog Mirror: Review our tips and tricks from enterprise customer lessons learned; mirrored from our SQLCAT Blog at http://blogs.msdn.com/sqlcat.
-
141 Views
Comments
Posted by: SQL Server Customer Advisory Team
- 03-16-2010
Author: Sanjay Mishra Reviewers: Prem Mehra, Alexei Khalyako, Kun Cheng, Mike Ruthruff, Thomas Kejser, Sunil Agarwal To enable read committed snapshot isolation (RCSI) on a database, one needs to execute the following command: ALTER DATABASE <db_name>...
-
371 Views
Comments
Posted by: SQL Server Customer Advisory Team
- 03-03-2010
Author: Thomas Kejser Reviewers: Juergen Thomas, Sanjay Mishra, Stuart Ozer, Lubor Kollar, Kevin Cox, Kun Cheng In this blog, we will provide additional details on a well-hidden feature in SQL Server 2008 – partition-level locking. But before we illustrate...
-
289 Views
Comments
Posted by: SQL Server Customer Advisory Team
- 03-02-2010
SQL Server 2008 R2 added a much requested feature: Unicode compression. It addresses the need to compress Unicode strings. It is implemented as part of ROW compression, which was added in SQL 2008. That is; if ROW compression (on SQL 2008 R2) is enabled...
-
645 Views
Comments
Posted by: SQL Server Customer Advisory Team
- 03-01-2010
Author: Kun Cheng Reviewers: Peter Carlin, Mike Ruthruff, Thomas Kejser, Nicholas Dritsas XML data type is usually used to store semi-structured data with great flexibility and query capabilities. It’s a good choice for developing platform agnostic applications...
-
558 Views
Comments
Posted by: SQL Server Customer Advisory Team
- 02-02-2010
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 project management...
-
1,038 Views
Comments
Posted by: SQL Server Customer Advisory Team
- 12-16-2009
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...
View All Articles>
Resources
PowerPivot blogs from SQLCAT team members:
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|