Good morning guys! Today I want to talk about a Sql Server feature that you could use when creating foreign key constraints: the WITH NOCHECKRead more…
Category: Sql Server 2016
Get SQL Server version in T-SQL
Hi guys!! Today I want to share a simple but useful trick to show the version of your SQL Server. Just type the following command:Read more…
Get all referencing tables of a table in Sql Server
Today I want to talk about how to get all referencing tables of a Sql Server table. It is useful, for example, if you needRead more…
Sql Server: apply an aggregate function to fields values in a row
Did you ever need to apply an aggregate function to fields values in a row? It happened to me just few days ago… I willRead more…
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 toRead more…
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 cursorRead more…
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 haveRead more…
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 thatRead more…
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 aRead more…
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 followingRead more…