Query Data Store Data
The data in the Query Data Store is what makes all the magic happen. From collecting the aggregate performance metrics...
2016-11-28 (first published: 2016-11-21)
1,282 reads
Reload a table quickly.
Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload....
2016-11-28 (first published: 2016-11-21)
2,904 reads
Associative Analytics: Two sample T Test
In the previous post we looked at a one way T-Test. A one way T Test helped us determine if...
2016-11-25 (first published: 2016-11-21)
2,572 reads
An early Christmas present - Great Value SQL Server Training the Decemeber
No No, not my new hat, although it is rather splendid. I have received the weekly email from Learning Tree listing...
2016-11-21
449 reads
Monday Coffee 2016-11-21
Well there were quite a few announcements in the SQL Server world last week.
SQL Server vNext CTP was made...
2016-11-21
352 reads
Task Manager is a liar
I remember asking a question at a recent training event, the outcome? I now don’t use task manager to try...
2016-11-21
576 reads
Columnstore Indexes – part 91 (“SQL Server 2016 Standard Edition Limitations”)
Continuation from the previous 90 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Given the improvements and the availability of...
2016-11-20
621 reads
Custom indexes on VMware vCenter database breaks 6.5 upgrade
Warning! If you have added custom indexes to the VMware vCenter database, you will need to remove them completely before...
2016-11-20
627 reads
Columnstore Indexes – part 90 (“In-Memory Columnstore Improvements in Service Pack 1 of SQL Server 2016 “)
Continuation from the previous 89 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focusing on a...
2016-11-20
607 reads
SQL Server 2016 SP1 Query Specific Wait Statistics Available Through Execution Plans
SQL Server 2016 SP1 added loads of cool new features and options. One of those is a change that expands...
2016-11-22 (first published: 2016-11-20)
1,764 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
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
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
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