Justin Cooney

Web Development Tips and Examples

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

Category: SQL Tips

T-SQL – Get a Historical Record of SQL Statements Hitting a Table

2013-05-09

Today I’ll review two useful queries that you can use to get information from SQL Server about what SQL statements are hitting one or more of your database tables. If you are interested in further T-SQL tips and tricks, please have a look through related articles I have written.
SQL Server Upserts – Using MERGE to INSERT or UPDATE Table Rows

2013-05-08

The idea of an Upsert was added in the SQL 2003 standard for databases and is implemented using a MERGE statement in both Oracle and SQL Server. So You Might Ask: What is an Upsert? An Upsert does pretty much does what it sounds like: it runs an update on a row where a condition…
T-SQL – Replace Multiple Extra Whitespaces in a String with One Whitespace

2013-05-04

In this article I will review three easy methods that can be used to replace extra spaces between words in a string. Note that if you want to remove extra spaces from the start and end of your string you will still need to encapsulate the output of the routines within the standard LTrim /…

recent posts

about

Category: SQL Tips

T-SQL – Get a Historical Record of SQL Statements Hitting a Table

SQL Server Upserts – Using MERGE to INSERT or UPDATE Table Rows

T-SQL – Replace Multiple Extra Whitespaces in a String with One Whitespace