Notes from 'Putting a Better SQL Server in Production' - the Ideal Pre-Prod checklist from Robert L. Davis
Last week, I sat in on Putting a Better SQL Server in Production - this is an ideal pre-prod checklist from...
2012-01-25
1,319 reads
Last week, I sat in on Putting a Better SQL Server in Production - this is an ideal pre-prod checklist from...
2012-01-25
1,319 reads
http://www.flickr.com/photos/cubagallery/4690390650/
Hello Dear Reader, last time on Day's of Our Lives there was an election, some people resigned, and other's...
2012-01-25
792 reads
Not blogged for a while due to client and project commitments but something which has surprised me when speaking with...
2012-01-25
569 reads
Janet, my girlfriend, and I went to Colorado Springs a day early, Thursday, to ski on Friday before SQL Saturday...
2012-01-25
702 reads
We as DBA’s face an ever growing list of things to do and services to support. We work in high...
2012-01-25
586 reads
I saw this write up about the built in ability to both restore to factory settings as well as just...
2012-01-25
651 reads
Reblogged from betim drenica's blog:
There is plenty of time I am developing applications for Windows Phone and… tools are great...
2012-01-25
1,362 reads
Reblogged from betim drenica's blog:
There is plenty of time I am developing applications for Windows Phone and…
tools are great (aka...
2012-01-25
1,190 reads
I’ve managed to get by for more than 3 years with the original 64G SSD in my laptop, but lately...
2012-01-24
1,224 reads
In February I will be starting a series of Blog Posts I'm calling a "A Script a Day". Each day...
2012-01-24
615 reads
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...
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...
Comments posted to this topic are about the item A Guide to SQL Security...
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