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…
Category: Sql Server
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…
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…
Sql Server error using a database with a CLR assembly
Few days ago, I got a Sql Server error using a database with a CLR assembly installed. Running my application I got the following error:Read more…
Reset Sql Server cache
Sometimes is useful to check how a certain query or a stored procedure behaves without cached data, so in this post I will show youRead more…