Introduction to Indexes: Part 2 – The clustered index
In the second part of her series on indexing, MVP Gail Shaw examines clustered indexes. Learn what this index is, how it differs from a heap, and how it can help your queries.
Starting to Program
This Friday Steve Jones asks what resources might help the new DBA learn to program better. Pick the language of your choice and let us know what resources have worked well for you.
Trash Destination Adapter
The Trash Destination and this article came from early experiences of using SSIS and community feedback at the time. When developing a package it is very useful to have a destination adapter that does nothing but consume rows with no setup requirement. You often want run a package part way through development, or just add a path so you can set a Data Viewer. There are stock tasks that can be used, but with the Trash Destination all columns are treated as selected automatically (usage type of read-only), so the pipeline knows they are required.
Advanced SSIS Fuzzy Matching via Record Linkage Methodology
Greatly improve SSIS Fuzzy Grouping performance by using a Conditional Split and Multi Cast.
Clouds, Costs, and Data Analytics
The cloud can be good or bad for your company, but it can easily be a costly endeavor that doesn't save you money. Steve Jones some data analysis is needed to ensure you have a cost effective cloud infrastructure.
Steps to clean up orphaned replication settings in SQL Server
Learn how to clean up your orphaned replication settings.
Indexes, Indexes, Indexes
This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.
TSQL Challenge 81 - Create a Game schedule generator in TSQL
This challenge is to generate a game scheduler based on the Teams given in a table.
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers