IN and NOT IN
One of the most common mistakes made in T-SQL is thinking that these behave identically. I've personally opened up a...
2010-01-28
1,233 reads
Seth Phelabaum
Windows LiveSynch
After a while, most people who work with SQL have accumulated quite a few scripts that they use for investigation,...
2010-01-20
527 reads
Tally Table - String Cleaning
Overview
This is something that most people eventually need for reporting purposes. This function uses a Tally table to 'clean' a...
2010-01-13
4,206 reads
2010 Goals
It seems like every blog I read has a list of goals posted for the year. This seems like a...
2010-01-09
347 reads
String Manipulation - CHARINDEX()
I see charindex used quite commonly in string manipulation. What I rarely see used is the optional third parameter. Here...
2009-12-21
2,926 reads
String Manipulation - CHARINDEX()
I see charindex used quite commonly in string manipulation. What I rarely see used is the optional third parameter. Here...
2009-12-19
4,465 reads
Tally Table - Character Date Validation
Tally (or numbers) tables are one of my favorite query writing tools. Such a simple premise that can be applied...
2009-12-17
3,185 reads
Tally Table - Character Date Validation
Tally (or numbers) tables are one of my favorite query writing tools. Such a simple premise that can be applied...
2009-12-14
3,037 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
Alamat BCA KCU PURWOKERTO Tlp:0817825533
WA CS 62817825533 Alamat Jl. Jend. Sudirman No.391 A, Brubahan, Purwanegara, Kec. Purwokerto Tim.,...
Alamat BCA KCU SOLO BARU Tlp:08217555651
WA CS 628217555651 Alamat Kawasan Terpadu The Park, Jl. Ir. Soekarno, Solo Baru, Madegondo,...
Alamat Kantor BCA KCU CILACAP Tlp:08218154374
WA CS 628218154374 Alamat Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers