SQL Server – How to identify timeout or broken connections using Extended Events (XE) or SQL Profiler (Trace) September 29th, 2021 0 Query Development Database 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) June 15st, 2021 0 Query Development Database SQL Server
SQL Server – How to filter and separate the number and text of a string June 14st, 2021 0 Query Development Database SQL Server
SQL Server – How to write a full number in Portuguese and English using T-SQL function June 10st, 2021 3 Query Development Database SQL Server
SQL Server - The “new” GREATEST and LEAST functions November 27th, 2020 1 Query Development Database SQL Server
SQL Server - What is bitwise operation and how to store multiple values in the same column June 21st, 2019 2 Query Development What not to do Database SQL Server
SQL Server - Performance Tuning Tips: Implicit Conversion? NEVER! February 3rd, 2019 8 Performance tuning Database SQL Server
SQL Server - NOLOCK vs READPAST: Do you know the difference between the two? 26 January 2019 3 Query Development Database SQL Server
SQL Server - How to Identify Instance Initialization Parameters Using T-SQL 11 January 2019 0 Maintenance Query Development DMVs and Catalog Views Database SQL Server
What has changed in SQL Server 2012 in relation to T-SQL - In the view of Developers December 29, 2018 0 Database SQL Server Query Development