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
9 reads
“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
9 reads
“where ISNULL(column, ‘DontMatch’) = ‘Match’” - is kind of a bad thing to do in SQL as it means that any index...
2015-12-10
49 reads
“where ISNULL(column, ‘DontMatch’) = ‘Match’” - is kind of a bad thing to do in SQL as it means that any index...
2015-12-10
48 reads
For those of you with access to the SQLSaturday admin site (used by event leaders) one of the things you...
2015-12-10
603 reads
This year I was interested to see that they did the Hour of Code in the elementary school my daughter...
2015-12-10
640 reads
Trace flags can be good Are special codes we, the DBA, can use to change the way the SQL Server...
2015-12-10
579 reads
When I present at any given event, I generally assume that the people attending have heard of the event that...
2015-12-10
494 reads
I ran into an interesting problem the other day. Given the title of the post, obviously a unique constraint was...
2015-12-10
1,641 reads
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,424 reads
Hi friends, In new CTP version SQL server 2016 which is 3.0, I was trying to explore the new masking...
2015-12-10
488 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Telp/WA 628217555651 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
Telp/WA 62817825533 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
Comments posted to this topic are about the item Server-level Roles
In SQL Server 2025, can I alter a fixed server role?
See possible answers