Orphaned login report for all databases
Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.
2016-02-23 (first published: 2016-02-04)
1,154 reads
Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.
2016-02-23 (first published: 2016-02-04)
1,154 reads
Script finds char types columns defined to allow NULL values but have non NULL values and generates the ALTER statements for the changes.
2016-02-22 (first published: 2016-02-08)
1,009 reads
Gives execute permission on all user-defined types for the specific user
2016-02-19 (first published: 2016-02-03)
724 reads
To show SQL Server and physical server details upon instance restart so that we have visibility of unexpected issues with servers and services.
2016-02-18 (first published: 2016-02-04)
712 reads
Enhanced version of Index Rebuilt Script originally written by Michelle Ufford, which now includes latest version updates and additional features.
2016-02-17 (first published: 2016-02-04)
1,774 reads
The script will restore the all the transaction logs files generated by Red Gate after extracting into .trn files.
2016-02-16 (first published: 2016-02-02)
498 reads
2016-02-15 (first published: 2016-01-29)
934 reads
Synch tables from Server 1 to Server 2 with out dropping tables in server 2 which do not exists in server 1.
2016-02-11 (first published: 2016-02-01)
1,071 reads
2016-02-05 (first published: 2014-05-15)
3,271 reads
Get total access,updates, rowlocks,pagelocks, stats date,rowcount for all tables or specific table by partition
2016-02-04 (first published: 2016-01-22)
884 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