Drop Database Objects Practically Risk-Free!
FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to me and expressed her concern over the normal housecleaning process that occurred at her company. ...
The...
2019-04-17
T-SQL
Find Occurrences of a String Anywhere on an Instance
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
The Sins of SELECT * (BP005)
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
Window Functions vs GROUP BYs
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
Database Fundamentals #21: Using the JOIN Operator, OUTER JOIN
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
Extract the Path from Filename in SQL
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
Why Rolling back inserts with Identity columns is a bad idea.
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
The Difference Between SQL’s JOIN .. ON Clause and the Where Clause
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
Writing Crossword puzzles with a database: T-SQL Tuesday #113
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
Data Type Precedence and Implicit Conversions
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
Blogs
Distance Metrics for Semantic Similarity Searches in SQL Server 2025
Next up in my series talking about The Burrito Bot is diving into the...
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers