In a report entitled "Really Urgent Analytics: The Sweet Spot for Real-Time Data Warehousing," Forrester advises intelligence and knowledge management professionals to familiarize themselves with the various approaches for adapting a data warehouse to meet real-time requirements, and, if necessary, consider bypassing the data warehouse altogether.
With the Labor Day holiday in the US, Steve Jones takes a break from writing and brings you a compilation of mistakes from the past few months.
IBM is testing a new hardware disk array that vastly outperforms any current arrays. What does this mean for the database world?
We are looking to automate the processing of our SQL Server Analysis Services dimensions and cubes. We'd like to add this processing to our existing SQL Server Integration Services (SSIS) packages which periodically update our data warehouse from our OLTP systems. Can you give us the details on how the Analysis Services Processing Task can be used in an SSIS package?
Learn two built-in functions for SQL Server data conversion from T-SQL date/time values to character types. These methods include SQL Server CAST and CONVERT.
With the Labor Day holiday in the US, Steve Jones takes a break from writing and brings you a compilation of mistakes from the past few months.
With the Labor Day holiday in the US, Steve Jones takes a break from writing and brings you a compilation of mistakes from the past few months.
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
I am excited to host T-SQL Tuesday for the first time. I want to...
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers