Articles

In the previous tips (SQL Server Integration Services (SSIS) - Best Practices - Part 1, Part 2 and Part 3) of this series I briefly talked about SSIS and few of the best practices to consider while designing SSIS packages. Continuing on this path I am going to discuss some more best practices of SSIS package design, how you can use lookup transformations and what considerations you need to take, the impact of implicit type cast in SSIS, changes in SSIS 2008 internal system tables and stored procedures and finally some general guidelines.

2009-12-14

5,747 reads

TSQL Challenge 19 - Working with consolidated calculations on hierarchical structures

by Press Release

T-SQL Challenges

T-SQL Challenges

This challenge involves generating an organizational hierarchy and calculating the total orders created by each employee and his/her subordinates. It involves a number of challenges such as generating a resultset in the correct hierarchical form, calculating the orders created by each employee and his/her subordinates and finally calculating the total orders created by self and all the subordinates.

2009-12-14

2,432 reads

What SQL Statements Are Currently Executing?

by Ian Stirk

SQLServerCentral.com

This article describes a utility that allows you to identify what SQL statements are currently executing.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(85)

You rated this post out of 5. Change rating

2009-12-11 (first published: 2008-10-28)

63,090 reads

Discuss

Comparing cursor vs. WHILE loop performance in SQL Server 2008

by Additional Articles

Builder.com

T-SQL

There are situations in which you need to individually handle each row in a result set. SQL Server 2008 provides a minimal set of tools — cursors and WHILE loops — to accomplish this task. I'll take a closer look at each option and explain why it's difficult to pinpoint which is better in terms of performance.

2009-12-11

4,754 reads

Fundamentals of Storage Systems – Disk Controllers, Host Bus Adapters, and Interfaces

by Wesley Brown

SQLServerCentral.com

Blogs

We have covered the Hard Disk and the System Bus. This time around we will cover disk controllers and host...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-12-11

3,898 reads

SQL Azure with ASP Dot Net

by Additional Articles

Database Journal

Azure

Don Schlichting demonstrates the development of a SQL Azure ASP Dot Net application, leveraging our existing TSQL and Dot Net skills.

2009-12-11

6,129 reads

SSIS Package Credentials

by Robert Pearl

SQLServerCentral.com

Integration Services (SSIS)

What do you do when you run an SSIS package and it works, but it fails when scheduled? You might have a credential problem. Robert Pearl brings us a solution to a cryptic message that prevents you from scheduling a package.