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
3,281 reads
Algorithm
The Black Boxes
The world of machine learning and artificial intelligence are growing. Steve Jones notes this means we need to decide if we can trust the black boxes.
2016-09-26
63 reads
Data Mining Introduction Part 10: Microsoft Logistic Regression
This is an introduction to the SQL Server Microsoft Logistic Regression Data Mining Algorithm.
2014-06-24
3,953 reads
Data Mining Introduction Part 10: Microsoft Logistic Regression
This is an introduction to the SQL Server Microsoft Logistic Regression Data Mining Algorithm.
2014-06-24
4,206 reads
Data Mining Introduction Part 9: Microsoft Linear Regression
This is an introduction to the SQL Server Microsoft Linear Regression Algorithm.
2014-06-19
4,694 reads
Data Mining Introduction Part 9: Microsoft Linear Regression
This is an introduction to the SQL Server Microsoft Linear Regression Algorithm.
2014-06-19
4,931 reads
Fuzzy-String Search: Find misspelled information with T-SQL
An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008
2014-01-10 (first published: 2012-09-18)
28,692 reads
RE: Starting SQL server - error 1068 and error 193
These both appear to be OS errors, as the corresponding errors in SQL Server have messages that don't seem to apply. I will assume that when you get the error 193 from the mssqlserver service, it fails to execute. If this is true, that is probably why SQL agent won't run. It is dependent on […]
2005-03-23
RE: List of procedures/functions/triggers that modify a given table
Gregory,Try sp_depends"Displays information about database object dependencies (for example, the views and procedures that depend on a table or view, and the tables and views that are depended on by the view or procedure). References to objects outside the current database are not reported."Not sure about triggersYelena
2005-03-18
RE: What is ALTER TABLE actually doing?
But why not? What does the engine actually do to/with all the data pages when a column is dropped? What does it do when a column is added? Philip
2005-03-14
Blogs
Step Up Your Data Game: Learn Advanced SQL Techniques for Analysis
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers