Enabling Cortana for dbareports PowerBi
Last week at the Birmingham user group I gave a presentation about PowerShell and SQL Server
It was a very packed...
2016-11-16 (first published: 2016-11-13)
1,834 reads
Residual Predicate and "Number of Rows Read" in Execution Plans
What is Residual Predicate?
Lets say one gets a query to fine tune. While checking the execution plan, if there is...
2016-11-17 (first published: 2016-11-13)
4,637 reads
What does an Index mean to a Query
This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e96566159ca8644006533/] Even simple, this query was causing troubles on our production...
2016-11-11
21 reads
What does an Index mean to a Query
This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e81b52eda1f0195410103/] Even simple, this query was causing troubles on our production...
2016-11-11
8 reads
What does an Index mean to a Query
This post is about the importance of a right index to a query. The following simple query was considered.
SELECT
[GroupBy1].[A1] AS...
2016-11-11
265 reads
Why we need a PASS Sponsor Portal
Major sponsors in our space get hundreds of emails from us each year, all asking for money. Those are all...
2016-11-11
399 reads
How to deploy your SQL Server database to a remote server
CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server where the target database is.
First time deployment
Backup / restore...
2016-11-11
10 reads
How to deploy your SQL Server database to a remote server
CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server...
2016-11-11
2,134 reads
SSIS Catalog Project Versioning
If you’ve spent much time working with the SSIS catalog, you likely already know that the catalog is where all...
2016-11-15 (first published: 2016-11-11)
1,844 reads
Special Index - XML Index
I will be writing this series of articles for the Special Indexes in SQL Server. In this series we will...
2016-11-11
509 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Question of the Day
Tracking All the Queries
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