Before talking about a multi-tenant database, let’s explain in a nutshell what a multi-tenant system is. Multitenancy is a software architecture that allows a singleRead more…
Category: Sql Server 2016
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 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…
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…