Index Fragmentation in SQL Server: Stairway to SQL Server Indexes Level 11
Internal and external fragmentation – Causes, cures, and when not to care
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.
Pages and Extents: Stairway to SQL Server Indexes Level 4
We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.
SQLServerCentral v3 coming tomorrow
The next version of SQLServerCentral will go love on Saturday, March 30, 2019
Trunk Based Database Development
Trunk based development is what many of us do with shared database servers.
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.
Blogs
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers