2008-03-14 (first published: 2008-01-29)
1,257 reads
2008-03-14 (first published: 2008-01-29)
1,257 reads
A simple UPSERT can reduce reads on tables. This in turn will increase the performance of a DB.
2008-01-29
12,167 reads
Tool to automatically query combinations of columns in your table to determine candidate for unique key.
2012-08-21 (first published: 2008-01-28)
2,804 reads
2012-03-26 (first published: 2008-01-23)
3,232 reads
2008-01-23
3,110 reads
2008-01-17
2,661 reads
2008-01-15
3,426 reads
The many popular rules concerning T-SQL filtering operators can't be trusted implicitly; instead, you should evaluate your options explicitly.
2008-01-14
2,792 reads
2011-09-20 (first published: 2008-01-11)
2,478 reads
Reformats the text output of queries to trim trailing blanks in wide varchar columns for easy copy-and-paste.
2008-03-10 (first published: 2008-01-09)
2,898 reads
With the PBIR format of Power BI reports, it’s much easier to make report...
By Steve Jones
As we close out the year, I decided to drop this post here and...
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Comments posted to this topic are about the item The Oldest Article
Comments posted to this topic are about the item Happy New Year 2025
How does this capture multiple values from a cursor, and put them into an...
What's the oldest article on SQL Server Central (take a guess)?
See possible answers