SQL Server 2022 and the GREATEST / LEAST T-SQL commands
Hi Guys, Welcome back to this little new midweek post. Today we will see two more simple but useful new T-SQL commmands added in SQL Server 2022. …
Search Suggest
T-SQL
T-SQL
SQL Server, speaking about ALIAS ...learn the rule
Hello friends! Welcome back to this short post. We will speak about Alias and only two minute to learn some important things is really a big deal ! …
COALESCE and IIF functions, the CASE statement and a secret at the end of the post
Hi Friends, March has arrived, spring is coming and i am writing this post after a sunny thuesday. Not bad at all! Just a good coffee and it is tim…
SQL Performance: Say no to the "NOT IN" operator
Hello friends, Paraphrasing the title of the american television show " Say Yes to the dress ", our title of today is " Say no to the …
SQL Server: Insert rows in a table and at the same time retrieve the id inserted with only a single statement? the OUTPUT and the OUTPUT INTO clauses
Hello friends! Two or three months ago we talk about How to get the Last Inserted Identity value You know that our goal is to find always the fastest…
SQL Server, How to find a text inside a SQL Server trigger or procedures?
Hello Friend, Today we have a little but useful post. I know many of you already know how to search for text inside a trigger or inside a stored proc…
Learn SQL Server Window functions and Running Totals in five minutes
Hello friends, Welcome back! Someone asked me about this topic so today we have a little bit of T-SQL theory. As usually I will do my best to expla…
Slow query performance using UPPER, LOWER or RTRIM in SQL Server 2017 and 2019
Hi Guys, Are you ready for another interesting post? Today we will inspect and solve a problem that afflict SQL SERVER 2017 and SQL Server 2019 that …
SQL Server, come vedere tutte le proprietà di una tabella con un solo comando
Carissimi lettori, Oggi un articolo veloce veloce! Vi faccio vedere un piccolo tips che risulta essere molto comodo in tante situazioni. Quante volte…