Browse by Tags

• analysis
• cubes
• Express
• fun
• join
• Katmai
• kba
• olap
• performance
• scheduled job
• SQL 2008
• SQL Community
• SQL Server
• ssis
• statistics
• table
• transactions

• OT: SQL Blog Bracket

  March Madness is here! If you are interested in Joining in on the fun, follow the link below. http://tournament.fantasysports.yahoo.com/t1/register/joinprivategroup_assign_team?GID=91191&P=sqlblog Group: 91191 Password: sqlblog Enjoy! Share this post: Read More... Posted Monday, March 17, 2008 12:35 PM from Rick Heiges | (Comments Off) Filed under: SQL Community, fun, dts

• DTS still alive in 2008?

  I was on a call with several other folks the other day discussing "Katmai". The topic of DTS came up. MSFT had indicated that support for DTS would not go beyond SQL Server 2005 in a variety of channels. I can remember the dozens of Upgrade Advisor messages Read More... Posted Wednesday, August 22, 2007 8:55 PM from Rick Heiges | (Comments Off) Filed under: SQL 2008, Katmai, dts, ssis, Express

• How to set up the Master DTS and OLAP packages to run as a scheduled job in Microsoft SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Analysis Cubes for Microsoft SQL Server 2005 Notification Contents: New and All Modifications How to set up the Master DTS and OLAP packages to run as a scheduled job in Microsoft Read More... Posted Wednesday, August 22, 2007 6:48 PM from SSQA.net | (Comments Off) Filed under: SQL Server, dts, analysis, kba, cubes, olap, scheduled job

• DTS package, how will optimizer treats the transactions?

  With the SQL Server 2000 DTS has very good capability of treating the huge processes as transactions, let's assume these parameters: DTS Package with "Use Transactions" and "Commit on successful package completion" boxes checked. No transaction related Read More... Posted Thursday, August 02, 2007 10:52 PM from SSQA.net | (Comments Off) Filed under: performance, statistics, table, dts, transactions, join