Browse by Tags

• 4014
• analysis
• cache
• clustering
• component
• databases
• entry
• error
• high availability
• installation
• instances
• integration
• kba
• netmon
• package
• performance
• requirement
• resources
• rowcount
• security
• server
• sp
• sql server
• ssas
• ssms
• table
• trace
• update

A fatal error occurred while reading the input stream from the network. The session will be terminated. Error: 4014, Severity: 20, State: 2
01 October 07 02:40 AM | SQL Master | 2 Comments   

This is a typical error you would get when a SSIS package is executed that involves remote server connectivity. Basically on the error note it will clearly identified as a network related issue. Similar issue happened at our end whereas the SSIS package Read More...

Filed under: performance, sql server, ssis, error, kba, instances, trace, update, installation, netmon, 4014

Whats the best way to setup memory on a four-node cluster?
06 September 07 02:42 AM | SQL Master | 3 Comments   

Though it is more to do with SQL Storage kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances Read More...

Filed under: ssms, high availability, performance, sql server, security, ssis, ssas, analysis, clustering, resources

How to get rowcount efficiently within a SSIS package?
05 September 07 01:50 AM | SQL Master | 2 Comments   

I would like to call this as how efficiently you can obtain counting rows in SSIS package. Usual thought would come is @@rowcount or COUNT_BIG functions, but this is not that efficient way to obtain the results. SSIS provides the snippet within its components Read More...

Filed under: rowcount, component, requirement, sql server, ssis, package, databases, table

Taking advantages of Cryptographic features in SQL 2005 - security
12 May 07 03:16 AM | SQL Master | 1 Comments   

When I had a chance to know about encryption features in SQL Server I always go with books online as a first hand information, but there is more to ask about this feature in 2005 version: Have you ever thought about encryption in SQL Server, how to implement Read More...

Filed under: sql server, security, integration, ssis, cache, entry, ssas

Unable to continue SSIS package after SP2
27 April 07 06:21 AM | SQL Master | 0 Comments   

From time to time we manage our SSIS packages by modifying the configuration file to allow the execution even though the service is stopped. 2 of the packages were working perfectly until we have applied the Service Pack 2 for SQL 2005 couple of weeks Read More...

Filed under: sql server, server, integration, ssis, package, sp