Database

How to Fix SQL Server Data Tools (SSDT) Installation Error 2017 – Setup Failed: Incorrect function (0x80070001)

October 4th, 2021
0
Business Intelligence (BI) Errors

SQL Server – How to list the largest tables and indexes in the database and show the size of each

October 1th, 2021
0
Database Maintenance Monitoring SQL Server

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 – Using TRANSLATE to replace multiple REPLACE

September 28th, 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 consult the dollar (USD), euro (EUR) or any other currency in real time with API and SQLCLR

June 10st, 2021
0
Database CLR Query Development Integrations SQL Server

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

SQL Server is extremely fast. You who don't know how to use it!

SQL Server - The “new” GREATEST and LEAST functions

November 27th, 2020
1
Database Query Development SQL Server