Database Mirroring Setup Procedure generator
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-20 (first published: 2015-03-17)
937 reads
Scripts
Database Mirroring Setup Procedure generator
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-17
157 reads
Fastest way to split delimited string in SQL Server
Getting rid of R-BAR to split a delimited string. This method is popular for it's simplicity, speed and zero reads.
2015-03-17 (first published: 2013-07-29)
4,829 reads
Enable Filestream on Instance and database
Enable Filestream on SQL instance and database with database name.
2015-03-16 (first published: 2013-08-12)
1,622 reads
Add user with DDL Trigger
DDL trigger will add a user to a newly created database and assign db_owner role. It can be modified for what role is required.
2015-03-12 (first published: 2013-08-22)
1,590 reads
Script out/store all indexes on a server
This script will store all index definitions into a table that you can use to "re-create" the indexes at a later date.
2015-03-11 (first published: 2013-08-26)
2,564 reads
2015-03-10 (first published: 2015-02-16)
1,401 reads
List database restore COMPLETION datetime
This script shows the COMPLETION datetime of database restore.
2015-03-06 (first published: 2013-09-04)
1,237 reads
Restore Database with any number of Ndf files
Execute the code after passing database name on which you want to restore and the path where your backup file being located.
e.g exec sp_restoredb N'mydatabase',N'D:\mydatabase.bak'
2015-03-05 (first published: 2013-09-22)
1,876 reads
Find Top 5 executed queries ordered by execution count
I wrote this query that helps us find executed queries with most number of execution counts. The DMV that we have used in this script is sys.dm_exec_query_stats and the function that we have used is sys.dm_exec_sql_text.
2015-03-04 (first published: 2013-09-23)
4,962 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
how to stop command prompt window from appearing when running PowerShell script?
Hi everyone I have a PowerShell script that is run by Execute Process Task...
Computer Algebra
Comments posted to this topic are about the item Computer Algebra
Renaming a Database
Comments posted to this topic are about the item Renaming a Database
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers