Joining Tables Part 2
In this session, Kathi continues her popular series and shows some of the more advanced joining techniques in T-SQL. She shows T-SQL self, outer and cross joins and gives many examples on how to use them.
2007-02-08
5,022 reads
Additional Articles
Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Repor
Relational Data Warehouse or Reporting work loads are characterized by low volumes of very large transactions. These applications are often identified as having predominately read workloads (e.g. Decision Support, Analysis, and Reporting) with periodic feeds or batch loads. It is important to keep these characteristics in mind as we examine the significance of database design, resource utilization and system performance. The top performance bottlenecks or gotchas to avoid for Data Warehouse or Reporting applications are outlined below.
2007-02-08
2,615 reads
Analysis Services Performance Tuning Whitepape
A whitepaper on getting the best performance from your system.
2007-02-07
2,567 reads
Robyn Page's SQL Server Cursor Workbench
The topic of cursors is the ultimate "hot potato" in the world of SQL Server. Everyone has a view on when they should and mainly should not be used. By example and testing Robyn Page proves that, when handled with care, cursors are not necessarily a "bad thing".
2007-02-06
2,669 reads
Using Fuzzy Lookup Transformations in SQL Server Integration Services
This article shows how the Fuzzy Lookup Transformation in SQL Server Integration Services (SSIS) can be used to make matches.
2007-02-02
2,938 reads
Product Review: SQL Refactor
Danny Lesandrini reviews SQL Refactor, a SQL Server Add-In that works with the new SQL Server Management Studio.
2007-02-01
2,964 reads
SQL Server 2005 Command Line Tool "SQLCMD" – Part I
This series will illustrate the various ways of using the SQL Server 2005 command line utility “SQLCMD”.
2007-01-31
2,990 reads
Introduction to message-based applications in SQL Server 2005
Tim Chapman discusses the concept of message-based applications, and the new foundation for building these applications included in SQL Server 2005.
2007-01-30
2,733 reads
Using Indexed Computed Columns to Improve Performance
I recently read a blog post on doing case-insensitive text searches on SQL Server 2005. The post said that an index on a computed column might be used even if the computed column itself wasn't used in the WHERE clause. I was curious to test that and see how far I might take it.
2007-01-29
3,398 reads
Regular Expression Based Token Replacement in ASP.NET
Damon Armstrong presents an extremely powerful and flexible token replacement mechanism for your ASP.NET applications. It is based on regular expressions so allows you to search for dynamic text, instead of just a static token, in a given string.
2007-01-26
2,182 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Lingkar Timur TELP/CS:083135765355
Whatsapp:083135765355 Jl. Salak No.99 & 100, Lkr. Tim., Kec. Singaran Pati, Kota Bengkulu, Bengkulu...
BCA KCP Pasar Minggu Tlp (+62 821°3111°179
Jl. Raya Pasar Minggu No.6, Kalibata, Kec. Pancoran, Kota Jakarta Selatan, Daerah Khusus Ibukota...
BCA KCP Batu Ceper Telp:Cs.08216977726
Whatsapp:08216977726 Kawasan Pusat Niaga Terpadu Blok A No. 8 F, Jl. Daan Mogot No.Km....
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers