SQL Server and Azure SQL Database: How to Identify Key Lookup occurrences through the plancache April 14th 2022 0 Azure SQL Database Database Maintenance Performance tuning SQL Server
SQL Server - How to identify all missing indexes (Missing indexes) of a database April 7th 2022 0 Database DMVs and Catalog Views Maintenance Performance tuning SQL Server
Azure SQL Database – STRING_SPLIT function finally gets parameter to include number of positions November 5th, 2021 0 Database Query Development News SQL Server
How to Fix SQL Server Data Tools (SSDT) Installation Error 2017 – Setup Failed: Incorrect function (0x80070001) October 4th, 2021 2 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) June 15st, 2021 0 Database Query Development SQL Server
SQL Server – How to filter and separate the number and text of a string June 14st, 2021 0 Database Query Development SQL Server
SQL Server – How to consult the dollar (USD), euro (EUR) or any other currency in real time with API and SQLCLR June 10st, 2021 1 Database CLR Query Development Integrations SQL Server