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,908 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,578 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
453 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
354 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
578 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
624 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
611 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,765 reads
SQL Server 2016 - SQL Service Doesn't Start after GDR Security update
Recently, after an security fix GDR (https://support.microsoft.com/en-us/kb/3194716) on SQL Server 2016 RTM, SQL Service refused to start. Though, the patch...
2016-11-20
1,210 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers