Topic

Microsoft uses editions for SQL Server and service tiers for Azure SQL Database to provide combinations of product features, performance,...

The SQL Server XTP Databases performance object provides In-Memory OLTP database-specific counters. In other words, the SQL Server XTP...

While the current 70-762 Exam Ref "Developing SQL Databases" emphasizes that using Extended Events is an efficient way to tackle locking...

The permissions system works the same in all versions of SQL Server, SQL Database, Azure Synapse Analytics (Formerly SQL Data Warehouse),...

When the query optimizer compiles a T-SQL statement, it also tracks up to 500 indexes that could have been used if they had existed. The...

This week I moderated a very excellent and informative PASS Marathon live webinar's session by Thomas LeBlanc @TheSmilingDBA The topic of...

1. Stored procedure Basic structure: ALTER PROCEDURE [Procedure name] AS SET NOCOUNT ON BEGIN TRANSACTION PRINT "Transaction complete"...

You distribute the amount of memory, CPU, and IO available to SQL Server among resource pools as a means of reducing contention between...

There are three ways of returning data from a procedure to a calling program: result sets, output parameters, and return codes. This...

Updating statistics is important. If the statistics are out of date, queries to a table would take longer time to execute. This is also a...