---

Filter by type:

• All
• Blog Posts

Performance and using of VARCHAR boxes as filters in SSRS reports

• by romanhorolskiy

• Forrards Group Database Blog

Very few people have thought about this performance killer. It is all about report parameter of text type.
The initial situation
There...

2015-11-04 (first published: 2015-10-22)

2,242 reads

SQL Server issue: switching partitions using the parameter with enabled replication

• by romanhorolskiy

• Forrards Group Database Blog

It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning...

2015-10-14

1,296 reads

How to create a database on a network share

• by romanhorolskiy

• Forrards Group Database Blog

If for any reason you need to place the database on a network share and by default this option is...

2015-10-12

529 reads

MS SQL Server 2014 Mirroring – thanks for being alive!

• by romanhorolskiy

• Forrards Group Database Blog

I decided to check if there is still database mirroring option in MS SQL Server 2014
Wow! It works!
MIrroring is still...

2015-10-08

586 reads

How to convert to Base64 and backwards via T-SQL

• by romanhorolskiy

• Forrards Group Database Blog

I want to share my way to convert a string to  Base64 and back. Let me note that presented method...

2015-09-30

1,823 reads

SQL Server SSIS: ReplaceNull

• by romanhorolskiy

• Forrards Group Database Blog

One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was...

2015-09-25

1,162 reads

SQL Server Enterprise Edition Advanced Scanning

• by romanhorolskiy

• Forrards Group Database Blog

It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you...

2015-09-24

1,186 reads

SQL Server 2014: ONLINE operation on a single partition of partitioned object

• by romanhorolskiy

• Forrards Group Database Blog

Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful...

2015-09-22

888 reads

SQL Server 2014: parallel execution of SELECT INTO statements

• by romanhorolskiy

• Forrards Group Database Blog

In Microsoft SQL Server 2014 new in-memory options are presented. One of them is online transaction processing (OLTP) that complementing...

2015-09-18 (first published: 2015-09-09)

3,227 reads

Define SQL Server database permissions for development team

• by romanhorolskiy

• Forrards Group Database Blog

The dba routine includes developer’s accounts management. Such as creating sql logins for new developers. There is usually a  standard...

2015-09-14

2,401 reads

Filter by type:

• All
• Blog Posts