Question : I have an e-commerce website and I’m in the process of creating a sales report. These reports need […]
Tag: reporting
Suitable way to record users requests for usage invoicing/billing in database?
Question : Is there more efficient way to keep a track of all requests made by each user with timestamp? […]
Data Warehouse design for reporting against data for many time zones
Question : We are trying to optimize a data warehouse design that will support reporting against data for many time […]
Looking for advice on how to integrate data from 100+ client DB’s into a centralized reporting database
Question : I am a SQL Developer (not DBA or Architect) for a small (~50 employees) SaaS company. I am […]
Why does SSRS not update a report’s description?
Question : I created a SSRS 2016 solution and deploy my reports. Each report has a “DESCRIPTION” property, that gets […]
How to easily show very long “canonical” name for each column in all reports?
Question : Related: Does the length of a table name affect performance? For query writing purposes I want to have […]
Assistance creating SQL query in Oracle to split by weeks
Question : I am building a report to show order statistics by week within our company. Here is the SQL […]
Data Warehouse design for reporting against data for many time zones
Question : We are trying to optimize a data warehouse design that will support reporting against data for many time […]
Advantage of using a database snapshot for reporting purposes
Question : What is the performance advantage of using a snapshot of a database for reporting purposes? The way I […]
Replicating tables for reporting purpose
Question : We have 5 tables in a database on Server A that we would like to replicate to Server […]