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
40 reads
Ed Elliott's Sql Developer Blog
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
14 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
610 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
43 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
43 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 on column can't be used. It is...
2015-12-10
4 reads
Find duplicate indexes in SSDT
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...
Duplicate indexes, one of the most pointless things you can do to a table that...
2015-11-27
987 reads
Find duplicate indexes in SSDT
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Duplicate indexes, one of the most pointless things you can do to a table...
2015-11-27
214 reads
Find duplicate indexes in SSDT
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Duplicate indexes, one of the most pointless things you can do to a table...
2015-11-27
209 reads
Find duplicate indexes in SSDT
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Duplicate indexes, one of the most pointless things you can do to a table that just adds pure overhead. No one likes them...
2015-11-27
7 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers