Feeds:
Posts
Comments

Posts Tagged ‘Tuning’

Pros/Cons of deploying #SSIS with the SQL engine server

Posted in Integration Services, tagged , , on January 10, 2010 | 5 Comments »

I was asked a pretty good question recently on what are the pros and cons of deploying SQL Server Integration Services packages on the same server that has your SQL Engine Server as well.  While we covered a lot in Top 10 SQL Server Integration Services Best Practices, we never really addressed this issue specifically [...]

Read Full Post »

Quick Tips for clearing up space #PowerPivot for SharePoint Uploading

Posted in PowerPivot, tagged , on January 6, 2010 | 2 Comments »

When you upload your PowerPivot for Excel workbook to your PowerPivot enabled SharePoint site, you typically will deal with much larger files than your other SharePoint sites.  This is the reason why we suggest that you increase the Excel Services and SharePoint to the max file sizes allowed (to do this, follow Step 18 at [...]

Read Full Post »

Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series)

Posted in Integration Services, tagged , , on May 12, 2009 | Leave a Comment »

For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance. Measuring and Understanding the Performance of Your SSIS Packages in the Enterprise (SQL Server Video) Link | Watch this video Author: Denny Lee, Microsoft Corporation This [...]

Read Full Post »

Follow

Get every new post delivered to your Inbox.

Join 869 other followers