Check if xp_cmdshell is turned on and flip the bit
The code works well for an automation process that needs to have xp_cmdhsell turned on.
2017-02-22 (first published: 2017-02-13)
671 reads
The code works well for an automation process that needs to have xp_cmdhsell turned on.
2017-02-22 (first published: 2017-02-13)
671 reads
2017-02-02 (first published: 2017-01-30)
765 reads
2017-01-30 (first published: 2017-01-26)
17,711 reads
TEMPDB doesn't have to be a black box. Know what objects and processes are causing it to bloat in size.
2017-01-30 (first published: 2016-12-29)
2,074 reads
This script will help you to find out whether a particular id (SQL or Windows ID) is present in the SQL Server
2017-01-26 (first published: 2017-01-24)
630 reads
Decryption Timer to let you know when the removal of encryption for a TDE encrypted database has completed to perform a backup of the data after masking.
2017-01-24 (first published: 2017-01-18)
423 reads
A script to be used as part of development deployments where new databases are required, so as to provide standardisation.
2017-01-23 (first published: 2017-01-18)
448 reads
Use this script to backup databases based on their role in an availability group
2017-01-12 (first published: 2017-01-07)
662 reads
This script will perfrom following tasks :
1. BackUp DB
2. Restore DB from BackUp File
3. Restore DB from DB
4. Create a new DB from Existing Db
It takes care of all the possible failures during these operations, while done manually.
2017-01-11 (first published: 2017-01-09)
1,707 reads
2017-01-10 (first published: 2017-01-05)
926 reads
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...
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
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