In recent days I was working on one of my projects, in which it was necessary to install Sql Server 2019. I restored the databaseRead more…
Category: Sql Server
Sql Server error: Cannot construct data type date, some of the arguments have values which are not valid.
Imagine waking up on a cold winter morning, and receiving an error from your customer that reads as follows: “Cannot construct data type date, someRead more…
Getting SQL Server sample databases
Good morning my friends! It’s been exactly a month since we last spoke! I’m very busy with a new project, which I hope to shareRead more…
SQL Server and SARGables predicates
Today I will share with you some suggestions about using SARGable predicates. First of all let’s start explaining what is a SARGable predicate…SARGable stands forRead more…
Sql Server Instant File Initialization
Sql Server Instant File Initialization is a Sql Server option that, I have to admit, I didn’t know. Activating this option you can slightly improveRead more…
Sql Server add constraint WITH NOCHECK
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…
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…