Cuppa Corner - SQLServerFAQ's library

Try the new Library (beta). Why?

Sort by: Name

Size

Date

Database Design - A Trip to First Normal Form

Introduction to First Normal Form, in this short presentation Tony Rogerson covers Domains, Functional Dependencies, Repeating Groups, Relation Valued Attribute and First Normal Form.

Last modified:
05/08/10 10:51 AM ET

Duration:
15:18

Size:
14.35MB

My Library ...
Fusion IO Technical Overview and Benchmarks

Technical overview of the FusionIO IO Memory devices, how it works - how it differs from SSD, throughput rate examples and benchmark compared to SAS using SQLIO and IOMeter.

Last modified:
07/08/10 06:25 AM ET

Duration:
28:33

Size:
22.39MB

My Library ...
Lookup and Cache Transform in SSIS

A look at how the cache transform can help you when having to perform the same lookup more than once using SSIS.

Last modified:
05/17/10 08:23 AM ET

Duration:
7:41

Size:
10.65MB

My Library ...
Pipeline Limiter in SQL Server Integration Services

You heard right. The pipeline can be, by design, stalled. In SQL Server 2008 you can see this limiter whereas in 2005 you couldn't even though it was there. Be assured though that the limiter does what it does for the right reason.

Last modified:
05/17/10 08:24 AM ET

Duration:
4:57

Size:
4.92MB

My Library ...
Profiler Data in StreamInsight

Taking Profiler data and streaming it through StreamInsight whilst doing analytics

Last modified:
08/04/10 06:36 PM ET

Duration:
14:34

Size:
27.11MB

My Library ...
Sorting data in the SSIS pipeline

In this sessions I show a couple of ways to sort data in an SSIS Data Flow Task. I have been asked about this a number of times and hopefully this explains some options available to us.

Last modified:
05/29/10 12:54 PM ET

Duration:
13:02

Size:
16.46MB

My Library ...
SQL - Basic Windowing using Joins

Tony Rogerson talks about what he calls "Windowing" in SQL, this is a basic talk - he shows how rolling totals work and how that method can be used for other things.

Last modified:
05/21/10 07:42 AM ET

Duration:
10:24

Size:
15.87MB

My Library ...
StreamInsight Left Anti Semi Join

In this video you can find out how to do a LEFT OUTER JOIN on your StreamInsight data streams

Last modified:
07/18/10 04:55 PM ET

Duration:
10:50

Size:
17.02MB

My Library ...
Table Variable Gotchas

Ever wondered why (or have you even noticed that ) the percentage of query cost relative to batch can be widely different from the real execution cost ? The use of table variables is just one of the things that can cause this. Dave Ballantyne tries to lift the fog....

Last modified:
07/21/10 04:29 AM ET

Duration:
9:45

Size:
10.01MB

My Library ...
Unbalanced DataLoads

Dave Ballantyne - Sql Server is great at producing and caching efficient query plans. However these plans may not be the most efficient, if called with different parameters. How can optimal plans be created to cope with differing ranges of data ?

Last modified:
07/09/10 12:32 AM ET

Duration:
14:43

Size:
14.18MB

My Library ...
Unpivotting Techniques in T-SQL

Rob Farley shows a few ways to unpivot data in T-SQL, including a look at the execution plans involved

Last modified:
06/27/10 03:08 AM ET

Duration:
5:59

Size:
5.55MB

My Library ...