Linked servers are great to query remote databases, but when running update queries they don't always behave like they should. In this tip I will show you a situation where several queries worked fine, but a few did not behave as planned. I will also sh
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...
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.
Microsoft released SQL Server 2014 SP2 and with this new service pack we get some new features. This update introduces database cloning in which a new database will be created that contains just the schema of all the objects and statistics from the specif
We are implementing our first Master Data Services (MDS) model and want to make sure that users cannot enter data that does not comply with certain business requirements. Read this tip to learn how to build business rules for MDS.
I have a dataset where I need to find the minimum and maximum values in a SQL Server table. In the case where multiple rows contain the same minimum or maximum value I only want to select the first occurrence. Read this tip to learn how.
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.