Set-Based String Splitting table function
Describe and provide a set-based method that takes a multiple character split term and returns as a table
2018-03-19
3,239 reads
bevan ward
Solve Sudoku with T-SQL - Part 1
A Sudoku solution can be resolved using a single select statement. The first article shows this method and next how this can be optimised to resolve complex puzzles in seconds.
2018-02-20
4,154 reads
Formatted ASCII Results from a SELECT
Generate aligned output from SELECT statement for code comments using a simple stored procedure.
2018-01-18
3,222 reads
Blogs
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Manhattan Telpon/WA:08137887595
BCA KCP Manhattan Telpon/WA:08137887595.The Manhattan Square, Mid. Tower, Lt. Ground Unit A & Lt....
BCA KCP Plaza Sentral Telpon/WA:08137887595
BCA KCP Plaza Sentral Telpon/WA:08137887595.Jl. Jend. Sudirman No.Kav.47, Karet Semanggi, Kecamatan Setiabudi, Kota Jakarta...
BCA KCP Pejaten Telpon/WA:08137887595
BCA KCP Pejaten Telpon/WA:08137887595.Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No....
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers