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
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
SQLSaturday Message Templates – Copy From Other Events
For those of you with access to the SQLSaturday admin site (used by event leaders) one of the things you...
2015-12-10
599 reads
The Hour of Code 2015
This year I was interested to see that they did the Hour of Code in the elementary school my daughter...
2015-12-10
634 reads
SQL F.A.D. – Trace flag 834 and columnstore indexes - Syndication – WaterOx Consulting
Trace flags can be good Are special codes we, the DBA, can use to change the way the SQL Server...
2015-12-10
573 reads
Promote Community
When I present at any given event, I generally assume that the people attending have heard of the event that...
2015-12-10
492 reads
Using unique constraints
I ran into an interesting problem the other day. Given the title of the post, obviously a unique constraint was...
2015-12-10
1,632 reads
Hadoop Fundamentals
Have you heard about Hadoop, but never really understood what it’s all about?
Do you need to learn about Hadoop, either...
2015-12-14 (first published: 2015-12-10)
3,416 reads
SQL Server – Trace flag changes in Dynamic data masking in SQL Server 2016 CTP 3.0
Hi friends, In new CTP version SQL server 2016 which is 3.0, I was trying to explore the new masking...
2015-12-10
486 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