Are nulls stored in a nonclustered index?
When you index a nullable field, are the rows with nulls stored in the index? It’s easy enough to find out by creating a table with a nullable field, and then creating an index on it.
Based in Dallas, TX? Join Redgate and Braumiller Law Group at their GDPR event tonight.
Join the FACC DFW for a night of innovation and European-American networking across industries. We invite you to a discussion with experts from Braumiller Law Group and Redgate Software UK to help answer your questions and learn about GDPR in copious capacities. (Use code REDGATE for member rate.)
Breaking the 4th Wall with Unity
Even when creating games, your code has access to environment variables and document files. In this article, Lance Talbert shows how to access files to convince the player that maybe the game knows more than it should.
Complimentary access to Gartner Guide
Redgate has been acknowledged as a representative vendor in the Gartner 2018 Market Guide for Data Masking. For Gartner’s insights, analysis and recommendations on data masking you can get your complimentary copy of the report from Redgate.
Indexes with Included Columns: Stairway to SQL Server Indexes Level 5
Included columns enable nonclustered indexes to become covering indexes for a variety of queries, improving the performance of those queries and with the only overhead being an increase the size of an index.
Create Azure Data Lake Linked Service Using Azure Data Factory
In this article we walk through a step-by-step example on how to create an Azure Data Lake Linked Service in Azure Data Factory v2.
Experiments with full text search
Would a crazy idea using full text thesaurus and phonetic keys actually have worked?
No More SQL Server Installs
Today, Steve wonders when we'll stop installing SQL Server on a host machine.
Creating CRUD Stored Procedures in SQL
Back to the basics: learn how to Create, Read, Update and Delete operations are pivotal for any database application. Plus, you’ll see how to use Stored Procedures to manipulate data on the database side instead of on the application side.
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers