Knowledge Base
Search Results ...
Tips for Tuning SQL Server Merge Statements
SQL Server MERGE statements, introduced in SQL Server 2008, offer a powerful way to perform multiple DML operations in a single statement. However, tuning these statements for optimal performance can be tricky. This article provides some tips on how to go[.....]
Using Change Data Capture (CDC) for Audit Requirements
In today's data-driven world, being able to track and audit changes to your database is not just a sensible precaution, it can also be a regulatory requirement. Fortunately, SQL Server 2012, SQL Server 2014, MySQL 5.6, DB2 10.5, and Azure SQL all support a[.....]
Using OPENQUERY for Cross-Platform Joins Between DB2 and SQL
For enterprises that manage multiple databases across different platforms, combining data from these varying sources may present a complex challenge. However, SQL Server provides a function called OPENQUERY that allows users to execute a pass-through query[.....]
Comparing SQL Server Full-Text Search and LIKE
When it comes to searching textual data in SQL Server, two options that usually come to mind are Full-Text Search and the LIKE operator. Both are tools that can be used for pattern matching and searching text, but they differ in their approaches and capabi[.....]
Migrating DTS Packages to SSIS 2016
Migrating DTS packages to SSIS 2016 can be a daunting task, particularly for databases that have been heavily invested in SQL Server 2012 or SQL Server 2014. However, with careful planning and execution, the transition can be a smooth one. This blog aims t[.....]
Introduction to Azure SQL Database: First Impressions Note from the Data Whisperer
Greetings, fellow data enthusiasts, and welcome back to SQLSupport.org. I am the Data Whisperer, and today I am excited to share my first impressions of Azure SQL Database. As many of you are already aware, Azure SQL Database is a cloud-based relational da[.....]
SQL Server Wait Stats Interpretation for Performance Tuning
In the world of SQL Server, understanding wait statistics is crucial for effective performance tuning. SQL Server uses wait statistics to track the amount of time a thread has to wait before it can get the resources it needs to execute a task. This data is[.....]
Cross-Database Joins and Security Considerations
In today's data-driven world, information is often distributed across multiple databases. This increases the complexity of querying data, as you may need to retrieve information from more than one database at a time. In SQL, this is accomplished via cross-[.....]
Using SSIS Expressions for Dynamic Connection Strings
Welcome to another post on SQLSupport.org. Today, we will be discussing a fascinating topic: Using SSIS Expressions for Dynamic Connection Strings. SSIS (SQL Server Integration Services) is a powerful tool offered in SQL Server 2012 and SQL Server 2014 for[.....]
Dimensional Modeling in Financial Reporting Systems
The modern financial reporting systems are increasingly moving towards dimensional modeling. This design concept, which structures data into a form that is easy to understand and navigate, is becoming a vital tool in financial reporting systems. This blog[.....]