SSDT Migrating Data Without Losing It
You sometimes want to do things like split a table into two or move a column into another table and...
2015-12-30
218 reads
Ed Elliott
Automatically re-write non-sargable isnulls into sargable code in SSDT
“where ISNULL(column, ‘DontMatch’) = ‘Match’” - is kind of a bad thing to do in SQL as it means that any index on column can't be used. It is...
2015-12-10
3 reads
Automatically re-write non-sargable isnulls into sargable code in SSDT
“where ISNULL(column, ‘DontMatch’) = ‘Match’” - is kind of a bad thing to do in SQL as it means that any index...
2015-12-10
35 reads
Automatically re-write non-sargable isnulls into sargable code in SSDT
"where ISNULL(column, 'DontMatch') = 'Match'" - is kind of a bad thing to do in SQL as it means that any index...
2015-12-10
596 reads
Automatically re-write non-sargable isnulls into sargable code in SSDT
“where ISNULL(column, ‘DontMatch’) = ‘Match’” - is kind of a bad thing to do in SQL as it means that any index...
2015-12-10
39 reads
T-SQL Clippy
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a lot of boiler plate stuff and offers re-writes for...
2015-12-10
5 reads
T-SQL Clippy
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a...
2015-12-10
37 reads
T-SQL Clippy
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a...
2015-12-10
747 reads
T-SQL Clippy
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a...
2015-12-10
38 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...
Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some...
2015-12-01 (first published: 2015-11-24)
2,721 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Forums
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Supervised versus Unsupervised Training of an Artificial Neural Network
Comments posted to this topic are about the item Supervised versus Unsupervised Training of...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers