2008-06-27
5,093 reads
T-SQL
2008-06-23
4,641 reads
T-SQL Data Processing
This article from new author Peter Kierstead shows us how to implement your own "fuzzy" dedup/merge logic without resorting to RBAR in T-SQL.
2008-06-23
8,023 reads
The Ultimate Foreign Key Researcher
Searches for actual and potential foreign key columns for a given primary key reference.
2009-10-12 (first published: 2008-06-20)
2,523 reads
2008-06-20
4,354 reads
2008-06-18
4,361 reads
2008-08-08 (first published: 2008-06-16)
931 reads
Correlated Joins Using "Apply"
Discusses the use of the newly introduced APPLY Statement in SQL Server 2005
2009-02-27 (first published: 2008-06-16)
24,987 reads
Compound Assignment Operators in SQL Server 2008
MAK illustrates the use of Compound Assignment Operator that is introduced in SQL Server 2008.
2008-06-13
1,978 reads
Java's String.hashCode() function in T-SQL
T-SQL function to takes a string and produce an integer hashcode matching what is produced by the Java String.hashCode() method.
2008-08-04 (first published: 2008-06-11)
1,350 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
BCA KCU RAWAMANGUN Tlp,Cs:0821-8154-393
WA:08218154393 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers