Have you ever had a conversation like this? Developer: “Hey, we’d like to know every place a particular column is used”. You: “On which database?” Developer: “Ummm….all of them, please.”
2019-04-17
If Prompt warns you of use of the asterisk, or 'star' (*), in SELECT statements, consider replacing it with an explicit column list. It will prevent unnecessary network load...
2019-04-17
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc… However, not all environments allow you to use those features (eg. vendor...
The...
2019-04-16
The OUTER JOIN returns one complete set of data and then the matching values from the other set. The syntax is basically the same as INNER JOIN but you...
2019-04-15
While I was preparing an article, I faced the challenge to extract the path from a filename in SQL Server. It’s an interesting challenge with many possible uses, so I...
2019-04-13
It wasn’t until the other day that I realised what the behaviour was when rolling back a transaction with an insert on a table with an identity column, to...
2019-04-11
A question that is frequently occurring among my SQL training‘s participants is: What’s the difference between putting a predicate in the JOIN .. ON clause and the WHERE clause?...
2019-04-09
Todd Kleinhans (b/t) is host for T-SQL Tuesday this month and wants us to talk about how we use databases ... Continue reading
The post Writing Crossword puzzles with a...
2019-04-09
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data. When the data types do not match, SQL Server has to...
The...
2019-04-09
From SQL Server 2017, it becomes more practical to use JSON arrays for representing and processing a matrix. SQL Server can read them, and update values in them but...
2019-04-09
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Comments posted to this topic are about the item Finding Motivation
Comments posted to this topic are about the item The Last Binary Value of...
Comments posted to this topic are about the item SQL Art, Part 2: New...
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers