How to check whether and when sql index statistics were updated last time?
I was working for a client on their very critical and heavily used database. The application was an E-commerce website...
2018-04-19
3,053 reads
I was working for a client on their very critical and heavily used database. The application was an E-commerce website...
2018-04-19
3,053 reads
If you ever had a need to start a SQL job using sp_start_job stored procedure in msdb then you know...
2018-04-19
13,585 reads
For one of my clients, I needed to know and document not only database names, size and locations but also...
2018-04-19
548 reads
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
Comments posted to this topic are about the item PASS Summit Time
I have a backup of full, differential and transaction log setup for our database....
Hello everyone, I hope you can help me. I have a table with measurement...
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