Who hasn't heard this complaint? "Our system is running slowly right now." It's a universal challenge across every industry, but the solution is often unique. That's mostly because enterprise systems grow more complex by the day. That makes troubleshootin
Microsoft SQL Server Extended Events, a replacement for SQL Trace, provides a useful and very customizable framework for managing very technical, low-level event information about a SQL Server database and its instances. However...
Sometimes there is a need to find if a string value exists in any column in your table. Although there are system stored procedures that do a "for each database" or a "for each table", there is not a system stored procedure that does a "for each column".
In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and t
On June 5, 2006 MSSQLTips.com started with just one tip in an effort to offer solutions to real world SQL Server problems. Ten years later, we never expected MSSQLTips.com to grow into a global community of millions of SQL Server Professionals.
There is often the need to compare both data and database structures from two databases either on the same server or on different servers. Most text editors have a built-in process to allow you to do a diff and identify any differences between the two fi
Continuous Integration has become standard practice for many development projects. Every time a developer checks in a piece of code, the entire project or solution is built and deployed to an environment to make sure it didn't 'break the build'. Developer
SQL Server 2016 introduced a new feature, Temporal Tables, which allow you to keep a historical record of all of the versions of each row in a table. As rows get introduced, changed, and deleted over time, you can always see what the table looked like dur
Do you know how to provide high availability protection for SQL Server without upgrading to Enterprise Edition? Learn how to get robust data protection features for a fraction of the cost of SQL Enterprise Edition with AlwaysOn Availability Groups in this
This paper demystifies query tuning by providing a rigorous 12-step process that database professionals at any level can use to systematically assess and adjust query performance, starting from the basics and moving to advanced query tuning techniques.