2013-12-05
2,590 reads
T-SQL
2013-12-02
2,975 reads
2013-11-29
2,172 reads
T-SQL Best Practices - Don't Use Scalar Value Functions in Column List or WHERE Clauses
A classic article by Gerg Larsen explaining how and how not to use a function within your T-SQL statements. Where you place your function within your T-SQL statements determines how your query will be processed and can severely impact the query execution plan and the performance of your query.
2013-11-28
6,824 reads
2013-11-26
2,005 reads
2013-11-21
2,148 reads
2013-11-18
1,916 reads
2013-11-25 (first published: 2013-11-15)
2,200 reads
2013-11-14
2,149 reads
2013-11-08
3,197 reads
Blogs
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...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
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