Customizing Statistics Histogram in SQL Server 2019
The use of statistics in SQL Server is tightly embedded in the query optimizer and query processor. The creation and maintenance of statistics is usually handled by the SQL...
2019-04-01
218 reads
The use of statistics in SQL Server is tightly embedded in the query optimizer and query processor. The creation and maintenance of statistics is usually handled by the SQL...
2019-04-01
218 reads
Today Steve has an announcement about his role in moving Books Online forward.
2019-04-01
555 reads
SQL Server 2019 will bring more than graph query languages. We will be able to use a document query engine and a specific JSON engine.
2019-04-01
3,247 reads
2019-04-01
1,384 reads
It’s T-SQL Tuesday again, and I’m writing in response to Shane O’Neil’s invitation about cookies. Read what he asks and...
2019-03-29 (first published: 2019-03-12)
373 reads
Trunk based development is what many of us do with shared database servers.
2019-03-29
727 reads
2019-03-29
468 reads
2019-03-28 (first published: 2015-10-07)
190 reads
2019-03-28
407 reads
The SQL in the City Summits are back for 2019, and we’ve got more scheduled than every before. You can see the complete list on our event page, and...
2019-03-27
138 reads
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