What is normal? Finding outliers with R
How do you currently set alerting thresholds? What is normal? And more importantly, what is truly abnormal? We will explore these questions.
2017-06-13
1,797 reads
How do you currently set alerting thresholds? What is normal? And more importantly, what is truly abnormal? We will explore these questions.
2017-06-13
1,797 reads
Using clustering algorithms to analyse index usage data from SQL Server’s DMVs & simplify complex performance investigations.
2017-05-29 (first published: 2015-12-07)
9,862 reads
Typical BI dashboards display data summaries like counts and averages. We use R to extend on these to identify key associations in a dataset.
2017-01-09
2,331 reads
Predictive / prescriptive analytics is regarded the highest level of advanced analytics. In this post, we emphasise the importance of exploratory analytics to derive meaningful insight.
2016-08-18
2,193 reads
Have you got transactional replication in your SQL environment? Do you need to add a new table to your publication, but can't afford the time necessary to create a full new snapshot? Here is a step-by-step guide. Thankfully, adding a single table is easier than I thought.
2015-01-05
20,957 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers