Create dynamic agenda slides with PowerPoint Zoom
There was a time when I saw PowerPoint as a necessary evil – a way of conveying ideas that I wasn’t crazy about, but which worked. These days, my...
2018-11-26
1 reads
There was a time when I saw PowerPoint as a necessary evil – a way of conveying ideas that I wasn’t crazy about, but which worked. These days, my...
2018-11-26
1 reads
There has never been a better time to start a project to champion data privacy In a recent Harris poll sponsored by the payment company Stripe, over 1,000 C-level...
2018-11-21
DevOps is the way of the future – but not all executives understand that yet DevOps practices are powerful tools to build productive, engaged teams who constantly learn and...
2018-11-19
Last week, I was lucky enough to present on the topic of TSQL User Defined Functions (UDFs) in SQL Server at the PASS Summit. My session was live-streamed, and...
2018-11-14
85 reads
It’s the second main-session day of the Summit for the Professional Association of SQL Server. I had a great breakfast this morning with Brent Ozar, along with Nathan and...
2018-11-08
Good morning from Seattle, at the Summit for the Professional Association of SQL Server. I’m lucky enough to be sitting at the blogger table this morning, watching the keynote...
2018-11-07
I’m excited to have a session accepted to GroupBy, a free online conference targeting the Microsoft data platform community. The conference is sponsored by Brent Ozar Unlimited, and sessions...
2018-11-02
1 reads
What if you could assess the performance level of your team by asking one simple question? In his recent webinar with Redgate, Gene Kim (@realgenekim) suggests that you can....
2018-11-02
I was lucky to get an opportunity to present a session to some college students at Seminole State College in Florida last week. I was in town for SQL...
2018-10-08
In this 20 minute session, I define scrum, continuous deployment, test driven development, DevOps, and related concepts. I close with a quick discussion of why Database Administrators and Developers...
2018-10-04
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
Recently I received a cry for help over Teams. The issue was that an...
Hello everyone, I hope you can help me. I have a table with measurement...
You can't handle the truth!! (about data integrity) A few good database administrators https://www.helpmasterpro.com/blog/a-few-good-database-administrators/...
I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...
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