http://www.sqlmag.com/authors/author/author/5194499/rss/5194499en-USFri, 25 May 2012 10:52:15 GMTFri, 25 May 2012 10:52:15 GMThttp://www.sqlmag.com/article/data-access/cube-partitioning-testsHerts Chen describes the testing he did to prove his hypotheses about cube partitioning and improving Analysis Services performance.]]>Herts ChenWed, 21 Jan 2004 00:00:00 GMThttp://www.sqlmag.com/article/data-access/cube-partitioning-testshttp://www.sqlmag.com/article/data-access/improving-analysis-services-query-performanceAnalysis Services is a valuable business intelligence (BI) tool, but when queries become complex, Analysis Services can bog down. Get your queries running efficiently by using these techniques for proper cube partitioning.]]>Herts ChenTue, 20 Jan 2004 00:00:00 GMThttp://www.sqlmag.com/article/data-access/improving-analysis-services-query-performancehttp://www.sqlmag.com/article/configuration/automatic-pilotManually customizing replication agent job steps speeds up snapshot replication, but it’s impractical for a large-scale environment. Learn how to automate this customization in the last article of a three-part series.]]>Herts ChenWed, 22 Jan 2003 00:00:00 GMThttp://www.sqlmag.com/article/configuration/automatic-pilothttp://www.sqlmag.com/article/tsql3/manual-transmissionTrying to copy large databases from one server to multiple remote servers can throw your snapshot replication into low gear. But you can rev up the process by manually customizing the replication’s steps.]]>Herts ChenWed, 24 Jul 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/manual-transmissionhttp://www.sqlmag.com/article/enterprise-manager/stop-drop-and-saveHere’s how the drop and save works when you add the customized drop step to a snapshot replication’s Distribution Agent job.]]>Herts ChenThu, 11 Jul 2002 00:00:00 GMThttp://www.sqlmag.com/article/enterprise-manager/stop-drop-and-savehttp://www.sqlmag.com/article/enterprise-manager/bottleneck-bluesAre performance-sapping bottlenecks weighing down your snapshot replication environment? Here’s how to optimize snapshot replication for large databases.]]>Herts ChenWed, 24 Apr 2002 00:00:00 GMThttp://www.sqlmag.com/article/enterprise-manager/bottleneck-blueshttp://www.sqlmag.com/article/replication/why-not-transactional-replication-When you want to copy large data sets to multiple target servers, snapshot replication beats transactional replication hands down.]]>Herts ChenWed, 24 Apr 2002 00:00:00 GMThttp://www.sqlmag.com/article/replication/why-not-transactional-replication-http://www.sqlmag.com/article/replication/custom-scripting-in-sql-server-2000If your scripts are simple, static, and stable, you can use SQL Server 2000’s custom scripting feature to perform custom tasks for snapshot replication. ]]>Herts ChenTue, 23 Apr 2002 00:00:00 GMThttp://www.sqlmag.com/article/replication/custom-scripting-in-sql-server-2000