2021-07-18
15 reads
Step by Step Guide to SQL Server AlwaysOn
AlwaysOn technology in MS SQL Server is designed to increase the availability of your database, it is another step toward...
2017-06-21 (first published: 2015-08-06)
16,864 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,422 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
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 was a table with about 45 million...
2015-10-22
10 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,621 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
53 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
10 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
1,385 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
10 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Putting the Player with the Number
Comments posted to this topic are about the item Putting the Player with the...
Your Security Checkup
Comments posted to this topic are about the item Your Security Checkup, which is...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers