2021-07-18
13 reads
Forrards Group Database Blog
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,411 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
7 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
6 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,610 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
41 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
7 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,354 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
6 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
6 reads
Blogs
My first year on full disability, wow!
By DataOnWheels
What a year … At the end of May 2024, I went on full...
Getting References for GenAI Results
By Steve Jones
I wrote an editorial on the view of GenAI tech from execs and someone...
SQL Server 2025 Is Here – AI Just Changed Everything!
By Rohit Garg
Top 10 Features of SQL Server 2025 #SQLServer2025 #MicrosoftSQL #DatabaseUpdates #SQLAI #SQLFeatures #SQLServerCopilot #VectorSearch...
Forums
Insert bulk fails when Online Index Rebuild is done
Hi, We are getting issue of Insert bulk failed due to schema change of...
Software Solutions on Cloud Servers
Hi SQL Server Central community, I’m exploring ways to optimize converting JPEG to PES...
Advanced QBO Tips for Better Analysis & Forecasting in 2025?
Hey folks, what cool tricks or tools are you using in QuickBooks Online this...
Question of the Day
Calculating Month End
I want to calculate the end of the previous month as a date that I can use in running a report. What is the best way to do this in SQL Server 2022, assuming I have a date stored in @d?
See possible answers