Summing a BIT column with a numeric as the outcome

Swapping values of variables

Multiple Defaults

OPENROWSET DNR

Performance Tuning with SQLFacts Tools

The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved into cloud services, their efficiency has a direct impact on the recurring bills. A workload that consumes more resources than necessary costs more to host in the cloud and affects the bottom line for your organization.

Adding Multiple Columns

Passing parameters to query without TVFs

This article looks at an interesting way to help your users get filtered data from a TVF instead of using a stored procedure or specialized view.

Capturing Data Changes

If you capture data changes with the OUTPUT clause, let us know today.

Decoding Set Options

ChatGPT in SQL Server - Practical examples

Introduction ChatGPT in SQL Server In this article, we will learn some basic examples of ChatGPT in SQL Server. In a previous article, we had an interview with ChatGPT an AI chatbot developed by OpenAI. If you do not know how to use it yet, you can go to that article. We will show some […]