Did you ever need to apply an aggregate function to fields values in a row? It happened to me just few days ago… I will…
How to know who is blocking a query in Sql Server
It’s been a while since we last heard… The Dummy Programmer was really really busy and couldn’t write any post. But now I’m back to…
Improving SQL Server cursor performance
Hi everyone! Today I want to talk about a performance problem I had a few days ago using a SQL Server cursor. Imagine using a cursor…
Delete all rows from all tables in a Sql Server database
Delete all rows from all tables in a Sql Server database may not be an easy task. This because in a relational database you have…
Search a string in stored procedures, functions and views in a SQL Server database
If you want to search a string in stored procedures, functions and views, maybe you can use some special tools. But, for instance, suppose that…
SQL Server LEN function return 0 passing a string with one space
Try to answer this riddle: What is the result of this SQL Server query: PRINT LEN(‘ ‘) I would answer 1, since I passed a…
Oracle JRE 7 Update 51 (64-Bit) or higher is required for Polybase
During the installation of Sql Server 2016 on a brand new server running Windows Server 2016, in the prerequisites checking phase I obtained the following…