Forrards Blog

130 cents total
Database consultancy: Writing to data files

It is a very popular database development task of loading data from the database to files directly. But how does it happen? Is it implemented immediately or the data is stored in memory first and transited to files later? Which event causes data transfer to transactions registration table and to files? Let’s see how it goes.

Forrards
March 31, 2023
Database consultancy: CROSS APPLY

This article is dedicated to the operator APPLY, and more specifically its type CROSS APPLY. This statement was first introduced in SQL Server 2005, but unfortunately many have not learned how to use it, maybe it's because of the fact that the BOL (SQL ServerBooksOnline) this operator is not well and has a very "dry" examples of its use. In this article, I'll show some interesting demonstrations, where the operator can come in handy.

Forrards
March 31, 2023
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Subscribe to our blog

                             

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
How to convert to Base64 and backwards via T-SQL

I want to share my way to convert a string to Base64 and back. Let me note that presented method is not the fastest, but it has one important advantage - it works OOB, without CLR functions. We need a test database and a table to use as an example:

Forrards
March 18, 2023
Performance and using of VARCHAR boxes as filters in SSRS reports

Very few people have thought about this performance killer. It is all about report parameter of text type.The initial situationThere was a table with about 45 million rows. Some columns in the table were VARCHAR and should have been filtered. As a result of filtering by 10 different parameters the total number of rows could have been significantly reduced. SQL Server was going for table scan in this case. Also there was a number of indexes defined on the table.

Forrards
March 18, 2023

Let's discuss your project or resource request

                       

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.