tsql

SQL Server – How to identify timeout or broken connections using Extended Events (XE) or SQL Profiler (Trace)

September 29th, 2021
0
Database Query Development SQL Server

SQL Server - How to identify the store closest to the customer (or the distance between 2 locations) from the zip code (without API)

SQL Server – How to filter and separate the number and text of a string

SQL Server – How to write a full number in Portuguese and English using T-SQL function

SQL Server - The “new” GREATEST and LEAST functions

November 27th, 2020
1
Database Query Development SQL Server

SQL Server - What is bitwise operation and how to store multiple values in the same column

June 21st, 2019
2
Database Query Development What not to do SQL Server

SQL Server - Performance Tuning Tips: Implicit Conversion? NEVER!

SQL Server - NOLOCK vs READPAST: Do you know the difference between the two?

SQL Server - How to Identify Instance Initialization Parameters Using T-SQL

11 January 2019
0
Database Query Development DMVs and Catalog Views Maintenance SQL Server

What has changed in SQL Server 2012 in relation to T-SQL - In the view of Developers