WITH DATA_PURITY (from recent experience, the key to knowing if patching to 14.0.3015.40 was okay)
So there I am, all keen on keeping ahead of the latest security issue, as usual, whilst handling my patching...
2018-01-07
476 reads
So there I am, all keen on keeping ahead of the latest security issue, as usual, whilst handling my patching...
2018-01-07
476 reads
Just a quick note to share last Wednesday night's presentation on how to manage SQL Server vulnerabilities, plus a first...
2017-11-27
548 reads
Assess your vulnerabilities before a system compromise brings it all down: just like what wasn't done early morning on Zhiggy's...
2017-07-26
794 reads
I had a note (or ‘action item’) to make sure that people were informed regarding the ‘uninstall’ of SQL Server,...
2016-07-12 (first published: 2016-06-29)
81,556 reads
Speaking next Wednesday, Vermont SQL PASS group, thanks to Roman Rehak? for the invite! http://www.meetup.com/VTCode/events/223946011/
I'll be doing an update to...
2015-07-17
702 reads
For years now we have dropped using Cat6 at home for Wifi,
since the Cat5e cables in the house we moved...
2015-01-04
1,147 reads
Thanks to the perseverance of SQL MVP Shehap El-Nagar’s invite last year, this brave
man from the Saudi Ministry of Higher...
2014-09-11
1,525 reads
On August 12th, 2014, another infamous ‘patch-Tuesday,’ Microsoft released a series of Security Updates for multiple versions of SQL Server,...
2014-08-22
1,979 reads
Now that it has been a
good five years I have been blogging away here and on SSC, the editors recently thanked
us...
2014-05-12
1,025 reads
For those planning a move to SQL Server 2012, although this process can apply for many Database Migrations, perhaps this Microsoft...
2014-01-13
10,760 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