MongoDB – Drop database

The dropDatabase command drops the current database, deleting the associated data files.
Different methods to drop database

Method 1:
1. select the database...

SQLCover Code Coverage for SQL Server T-SQL

Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see how many statements in your database code have been...

SQLCover Code Coverage for SQL Server T-SQL

Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see...

SQLCover Code Coverage for SQL Server T-SQL

Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see...

Using PowerShell to set Extended Events Sessions to AutoStart

When you look after more than a few SQL Servers you will need to perform the same actions against a...

Utility function: dbo.JobName(@job_id)

As often as I have to pull a job’s name based on its job_id in the MSDB system tables, I’m truly...

VMware CPU Co-Stop and SQL Server Performance (continued)

A number of you sent me some excellent questions about this topic, and my favorite asked me for the query...

Win a SQLBits Pass

You can win a free conference pass to SQL Bits, in Liverpool, May 4-7. It’s easy, just post a review...

All about Searching - Full-Text Indexes

SQL server has the capability to store text-based data in the form of char, varchar, nchar, nvarchar, text, ntext, image,...

Announcement: Backup(n.) vs Back Up(v.)

Let it be known that the word “backup” is a noun (it refers to a thing), and “back up” is a verb (it...