Sent: Friday, January 20, 2012 10:30 AM
To: William Assaf
Subject: dba has a questionWilliam,
Can you send me references to support my contention that NOLOCK...
2012-01-24 (first published: 2012-01-21)
3,865 reads
This past Saturday January 21, 2012 I had the opportunity to speak at my first IT Pro Camp in Orlando,...
2012-01-24
873 reads
Every security awareness presentation makes the warning about opening attachments or clicking on links in emails when you don't know...
2012-01-24
1,244 reads
As discussed in my previous post I prefer to use Windows authentication over SQL authentication on my SQL Servers. There...
2012-01-24
1,713 reads
Over the last couple of months I have on several occasions found myself in need of test data for demos,...
2012-01-24
14,183 reads
The PASS Performance Virtual chapter is getting a reboot. We all know that responsibilities and schedules change, and that meant...
2012-01-24
733 reads
Sometimes you will find the need to import a file to a variable using SSIS. In this post, I’ll use Script...
2012-01-24
1,836 reads
I ran across this KB article the other day, which lists a few ways in which performance is affected by...
2012-01-24 (first published: 2012-01-19)
2,191 reads
In my last post, I wrote that the game plan was to post by Dec. 10 on changes in data...
2012-01-24
1,946 reads
By now you must have heard of the SQL Slammer worm. It was quite an infectious little nuisance. The harm it caused came largely due to unpatched, unprotected SQL...
2012-01-24
1 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