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...

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...

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...

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...

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...

Implementing Full-Text Indexes

In my previous blog we saw the Full-Text Index architecture. 

http://sqlandmorewithkruti.blogspot.in/2016/04/all-about-searching-full-text-indexes_7.html

In this blog we shall see its implementation. Before you proceed...

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,...

MDF File Password Confusion

I had never seen this, but I ran across a blog that mentioned an MDF File password here. The post...