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…
Category: Sql Server
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…
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…