Removing all non-numeric characters from a string

I have a property that I want to keep, but I also need a numeric-only version. If that makes no sense, I’ll give you context. Let’s say you want to easily search for Phone numbers. People tend to enter their phone number in many ways….

Making a text box truly multiline

In Microsoft asp.net WinForms, you can make a textbox multiline. By Multiline, I mean that it allows text to be written across multiple lines. There is a property on the Textbox control called “Multiline”, which you need to set to true. But, you also have…

Bulk disable indexes

If you’re performing a large data migration task, or running a script that will insert many records, you may be able to speed up the process by disabling indexes on you database. This will help, because the database won’t need to incrementally update the indexes…

Introduction to CTE

This post is just plugging a good article that I found on Common Table Expressions (CTE). I was looking at it for assistance with performance. Though I later learned that CTE is NOT useful from a performance perspective. But anyway, the article is available over…

Insert into from a Stored Procedure

Below is the syntax to insert records into a temporary table from the output of a stored procedure. Note, because we can’t specify columns in the EXEC, the temp table signature should match the stored procedures output. Personally I have found this syntax helpful in…

Compare execution plans with SSMS

How have I not seen this before??!! If you have saved two execution plans in SQL Server Management Studio (SSMS), you can use the same tool to compare them! Check out the link below for more. https://blogs.msdn.microsoft.com/sql_server_team/comparison-tool-released-with-latest-ssms/

Easy access to system information

If you’re after a quick summary of the hardware configuration on a Windows machine, Microsoft has you covered. Just open System Configuration, but following these steps Click WIN+R Enter “MSINFO32” The following window will open.

Text replace

A nice simple post today. This is probably well known, but I useful one to know. Below is the syntax for the REPLACE function. As you can see, the first parameter is the source string, second is the text to replace, and the third is…