2021-07-18
10 reads
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 situation
There...
2015-11-04 (first published: 2015-10-22)
2,263 reads
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 situation There was a table with about 45 million...
2015-10-22
2 reads
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 situation There was a table with about 45 million...
2015-10-22
2 reads
SQL Server issue: switching partitions using the parameter with enabled replication
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,337 reads
SQL Server issue: switching partitions using the parameter with enabled replication
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning for a long time and did not cause any...
2015-10-14
2 reads
SQL Server issue: switching partitions using the parameter with enabled replication
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning for a long time and did not cause any...
2015-10-14
2 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is...
2015-10-12
560 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
2 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
2 reads
Blogs
Removing a Deleted Column from a Data Masker Masking Set
By Steve Jones
Data Masker for SQL Server is a great tool ensuring the data you use...
Containers: A Short Rant
I find myself doing more and more work with containers. Yet, I also find...
Daily Coping 20 Sep 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Metadata-Data-Ratio in a table
Hi all, My understanding about the structure of data within SQL Server is that...
Always On - why No failover occurred?
Hi, I am using SQL 2016 (13.0.5888.11). Last Saturday (18th September), in non-office hours,...
Log Shipping Truncate Log File
Good Morning, I have read that taking a log backup truncates the log file....
Ask SSC