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
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…
Load a huge amount of data in a Sql Server table
Last week I had to load a huge amount of data, about 500,000 rows, in a Sql Server table to make some data processing. UsingRead more…
The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
I was trying to load the content of an xlsx file into a Sql Server database using the “Sql Server import and export wizard” providedRead more…