Need to proper case names? Want a quick way to reformat a series of words? This article examines a SQL approach to quickly proper casing all words in a field.
2004-08-20 (first published: 2001-10-24)
12,689 reads
Or how to query for a particular type of customer. This article examines how you may query for particular rows that match one condition, but may not match another.
2001-09-19
3,745 reads
This article presents a method of outputting the results of a query as a tab delimited text file using COM.
2001-07-20
6,585 reads
Ever had to calculate the number of business days between two dates? This article presents a way to solve this problem in T-SQL.
2001-07-18
13,016 reads
Xp_sendmail is a great utility that SQL Server provides in order to e-mail messages directly from SQL Server, by using a valid MAPI profile. However, its syntax is rather stringent. In this article by Kunal Das, he shows you how to send messages to a list of recipients generated by a query dynamically in T-SQL.
2005-02-18 (first published: 2001-07-16)
23,973 reads
The fifth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with STUFF.
2026-02-03 (first published: 2001-06-21)
10,938 reads
2001-06-15
7,465 reads
One of the keys to database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation.
2001-06-04
10,718 reads
Sp_MSforeachdb gives a DBA the ability to cycle through every database in your catalog. Find out how to use it.
2001-05-31
13,804 reads
Is there such a thing as a task where you would not need a cursor? Hidden in the depths of the master database are a series of stored procedures that can replace some cursors with these one-liners.
2001-05-22
14,252 reads
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Comments posted to this topic are about the item Can You Really Downgrade from...
Comments posted to this topic are about the item What is CPU Usage?
Comments posted to this topic are about the item Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers