2012-01-18
4 reads
2011-08-24
3 reads
Big Data I: 16 Papers and original articles
What are the most influential papers in the world of Big Data? Let me suggest:...
2011-05-30
4 reads
2011-05-02
2 reads
2011-02-02
4 reads
2011-01-05
3 reads
Getting ready for the third “Industrial Revolution”: Database 2010-2015
I searched the internet for “connect and forget”. Wonderbox.net offer is described as a...
2010-10-10
2 reads
Database automation and appliances
10 years ago IT professionals considered database technology “mature” and analysts were preparing to...
2010-09-13
4 reads
The application platform for the “Unlimited information” era
“The information age is an idea that the current era will be characterized by the ability of...
2010-08-22
1 reads
The ‘addicted to data’ decade is still in its infancy
“Content is king” is the golden rule of the SEO. The semantic web is all about data. Any web...
2010-06-25
8 reads
Blogs
2024 PASS Data Community Summit Prep
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
A New Word: Bye-over
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Forums
Temporary Table Problem
Hello everyone, I hope you can help me. I have a table with measurement...
A Few Good DBAs
You can't handle the truth!! (about data integrity) A few good database administrators https://www.helpmasterpro.com/blog/a-few-good-database-administrators/...
Python with SQL 2022 Enterprise doesn’t work
I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers