VI Editor Basic Commands
A few months back I came across an instance of using VI Editor. Trust me being a SQL DBA it...
2016-04-09
5,157 reads
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...
2016-04-08
737 reads
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...
2016-04-08
571 reads
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...
2016-04-13 (first published: 2016-04-08)
4,432 reads
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...
2016-04-08
45 reads
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...
2016-04-08
56 reads
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...
2016-04-08
12 reads
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...
2016-04-08
483 reads
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...
2016-04-13 (first published: 2016-04-08)
2,642 reads
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,...
2016-04-14 (first published: 2016-04-08)
1,951 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers