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.<?query --SELECT [GroupBy1].[A1]...
2016-11-11
337 reads
Friday Reading 2016-11-11
It’s Friday so no releases to Production today (ha!) which means in-between my code reviews, server audits and other tasks...
2016-11-11
302 reads
Linked Server Security
Problem
When creating Linked Servers, security often gets overlooked. This can lead to accounts on one instance having access, sometimes with...
2016-11-11
22,383 reads
SQL Server 2016–Live Query Statistics
WOW!!! The next great update to Execution Plans is a way to watch the processing of rows through iterators while...
2016-11-15 (first published: 2016-11-10)
2,063 reads
Azure SQL Server 2016 VM
With Windows Server 2016 just been released, now is the perfect time to build an Azure VM with SQL Server...
2016-11-10
1,034 reads
The PASS Global Alliance Program (GAP)
One of the topics I forgot to mention from the Roundtable was a swell of dissatisfaction with the GAP. Not...
2016-11-10
399 reads
Is it safe to grant Administer Bulk Operations?
First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are...
2016-11-14 (first published: 2016-11-10)
2,308 reads
Query tuning 101: Problems with IN ()
If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...
2016-11-14 (first published: 2016-11-10)
5,717 reads
CHECKDB’s Hidden Snapshot
I am in the middle of some research regarding CHECKDB and learnt something new. From SQL Server 2014 onwards the...
2016-11-10
463 reads
SQL Server 2016 - “Number of Rows Read” on Execution plan
One of the coolest things to release with SQL Server 2016 was “Number of Rows Read” information in execution plan....
2016-11-10
842 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