SQL Server Transaction Functions, Query Across Servers, Triggers Tutorial and String Functions

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [Compare SQL Server XACT_STATE vs @@TRANCOUNT Functions]( This article will compare the SQL Server XACT_STATE and @@TRANCOUNT functions and illustrate the differences with examples. The goal is to reduce the confusion between these two functions, allowing for the correct function to be applied to particular... [mssqltips image]( [Tune and monitor your SQL Server databases]( With just a few clicks, you get expert advice to boost the performance of your SQL Server databases. Within minutes, analyze statements, perform index impact analysis, view trend charts, and monitor your database in real time. ... [mssqltips image]( [Query All Databases Across Multiple SQL Servers]( In this article, learn how to query all databases on multiple SQL Servers and store the results in a single table.... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [Improve SQL Server Data Quality in SSIS]( Learn about the Melissa Data Quality Solutions for SSIS.... [mssqltips image]( [Contained Availability Groups in SQL Server 2022]( In this article, we look at how to setup and configure Contained Availability Groups in SQL Server 2022 and some of the new options this feature allows.... [mssqltips image]( [Multi-Platform Database Performance Suite]( The DBI Web Performance Suite for SQL Server and DB2 is a database performance collection, analysis and recommendation tool to help you troubleshoot and tune your database systems.... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [Triggers in SQL Server Tutorial]( There is often the need to perform a database action in response to a specific event occurring. In this tutorial learn about SQL Server triggers and how these can be used to run additional code after an event occurs like inserting or changing data.... [mssqltips image]( [Calculating Costs for Microsoft SQL Server]( This white paper looks at how costs can be controlled with a sufficient understanding of the Microsoft SQL Server licensing process.... [mssqltips image]( [SQL Server String Functions Tutorial]( This shows how to use the SQL ASCII function to return the ASCII value for a character value.... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]