Have you ever used XP_RESULTSET in SQL Server? If you're like most DBAs, this procedure is rarely used and can be a little complicated to setup. New author J. T. Shyman brings us a look at just how useful this command can be in executing a command on every database.
2006-06-27
12,871 reads
2004-10-13
1,975 reads
During the process of developing a script to make copies of local SQL database and transaction log backups, I needed to come up with an easy way of locating the backup files. This script queries the SQL2000 backup tables in the msdb database and returns backup start dates, types (D=database, L=Log, I=Differential) and the location […]
2004-02-25
611 reads
2004-02-25
1,822 reads
2004-02-23
1,709 reads
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
By Chris Yates
I get asked a lot about why or how I began working with databases...
Yes, you read that title correctly. I have a somewhat hilarious problem. We have...
Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers