Fix Orphan Users for Instance Migration
Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.
2016-01-04 (first published: 2015-12-17)
1,554 reads
Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.
2016-01-04 (first published: 2015-12-17)
1,554 reads
Script uses undocumented extended stored procedure xp_readerrorlog to find failed logins (grouped) and last successful login
2015-12-30 (first published: 2015-12-15)
1,812 reads
2015-12-29 (first published: 2015-12-09)
1,969 reads
This script adds empty first step for every job for easier job history viewing.
2015-12-28 (first published: 2015-12-10)
1,847 reads
2015-12-25 (first published: 2015-12-17)
1,685 reads
2015-12-23 (first published: 2015-10-19)
2,000 reads
A script to get the user table query ratio and update radio,etc
2015-12-21 (first published: 2015-12-11)
1,753 reads
2015-12-18 (first published: 2015-12-09)
3,937 reads
This script outputs sql server service, start type, status, Service Account, installation location, start up time, uptime of sql server related services along with startup trace flags.
2015-12-17 (first published: 2015-12-09)
1,124 reads
Use this script to set recommended Log files size growth for larger DBs. For more, please refer article: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files
2015-12-15 (first published: 2015-12-07)
1,216 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