Dealing With Upper and Lower Case Data
Gregory Larsen demonstrates several examples of how to deal with different situations related to the case of character strings.
2007-02-16
2,757 reads
Advanced Querying
Tame Those Strings - Finding Carriage Returns
Expanding on his series of string manipulation in T-SQL, Steve Jones takes a look at how you go about removing those unseen characters from your strings.
2008-02-04 (first published: 2007-02-13)
12,835 reads
Joining Tables Part 2
In this session, Kathi continues her popular series and shows some of the more advanced joining techniques in T-SQL. She shows T-SQL self, outer and cross joins and gives many examples on how to use them.
2007-02-08
5,022 reads
Robyn Page's SQL Server Cursor Workbench
The topic of cursors is the ultimate "hot potato" in the world of SQL Server. Everyone has a view on when they should and mainly should not be used. By example and testing Robyn Page proves that, when handled with care, cursors are not necessarily a "bad thing".
2007-02-06
2,669 reads
When To Use Cursors
Most SQL Server DBAs have been taught that cursors are bad and should not be used. However there are some cases and places where they might be useful. SQL Server guru Andy Warren brings us an example of where they may be handy.
2008-01-03 (first published: 2007-01-15)
16,894 reads
Calculating Days of the Week and Accounting Months 5-4-4
Learn how to calculate days of the week based on the current date and how to calculate accounting months.
2007-01-12
3,468 reads
Write PIVOT queries in SQL Server 2005
New to SQL Server 2005 is the PIVOT operator, which gives you the ability to rotate row level data into tabular data without the use of the CASE statement, as was necessary in previous versions of SQL Server.
2007-01-11
5,731 reads
Creative Ways to Use the TOP Clause
Gregory Larsen discusses how to use the TOP clause to help solve requests where you want to restrict the number of records returned based on a record count.
2007-12-27 (first published: 2007-01-05)
8,395 reads
Running totals in SQL Server queries
How often do you need to keep a total of all previous rows values when you run a query? This article shows you how you can achieve this.
2007-11-23 (first published: 2006-11-23)
7,074 reads
Compress Binary Messages Using SQL
Data compression is a great method for maximizing data storage space and making data communication faster. However, compression and decompression of binary data sometimes can be quite tricky. Learn a few useful data-compression techniques.
2006-11-16
1,945 reads
Blogs
TSQL Tuesday #188 Growing community
I am responding late to a T-SQL Tuesday invite from John Sterrett. John’s call...
Time to Revive our YouTube Channel
It’s been forgotten about and neglected for few years but I’ve decided to dust...
Microsoft MVP 2025: Continuing the Data Platform Journey
I am honored to announce that I have been renewed as a Microsoft MVP...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
SQL Server 2022 Clusterless Distributed Availability Group
Comments posted to this topic are about the item SQL Server 2022 Clusterless Distributed...
Navigating Multi Platform Realities in My Database Life
Comments posted to this topic are about the item Navigating Multi Platform Realities in...
Question of the Day
Query Plan Regressions --
For the Question of the day, I am going to go deep, but try to be more clear, as I feel like I didn't give enough info last time, leading folks to guess the wrong answer... :) For today's question: You’re troubleshooting a performance issue on a critical stored procedure. You notice that a previously efficient query now performs a full table scan instead of an index seek. Upon investigating, you find that an NVARCHAR parameter is being compared to a VARCHAR column in the WHERE clause. What is the most likely cause of the query plan regression?
See possible answers