Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order. To make sure a result set is ordered you need to use the ORDER BY clause. In this article I will be exploring how to return an order result set by using the ORDER BY clause.
Perspective makes a big difference and Steve Jones looks at how you might change the way you think about clients, customers, and the work you do.
Learn how you can use SQLCop to prevent your developers from writing stored procedures that are named sp_ something.
Feodor Georgiev provides a thorough walkthrough on setting up SQL Server's Data Quality Services (DQS) and creating the rules it uses to function as a first step towards data cleansing.
Hadoop is a technology that's getting quite a bit of attention in the last few years, including integration with SQL Server. Steve Jones talks about the technology and how it might fit in your career.
In this tip Ben Snaidero looks at how to improve SQL Server Bulk Load performance. He focuses his performance tests on options using the BULK INSERT T-SQL command to judge how the various options affect speed.
Create and Load Sql Server Tables based on Dynamic Access Database
We know that software testing is important, but we often don't do a great job of executing. Steve Jones talk database testing today.
SQL Server keeps the most-used execution plans in cache, so it doesn't need to recompile the same queries every time. How can we benefit from this to find potential performance problems in execution plans?
An interesting new paradigm popped up in the news this week: the data lake. It examines data as a model for organizational architectures.
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers