Opening JSON Data with T-SQL
The T-SQL code samples in this tip illustrate ways of displaying JSON formatted data in SQL Server as well as how to transfer JSON formatted data to SQL Server tables.
2021-06-25
T-SQL
SQL Server Resource Governor Game
Learn about the SQL Server Resource Governor and how it can be used to manage your SQL Server workloads via this game format that can help your team gain better insights.
2021-06-09
SQL Server T-SQL CASE Statement Examples
This tip will teach you when and how you can use CASE in T-SQL statements with several code examples to give you a better understanding.
2021-05-14
Never, Ever, Ever Start T-SQL Comments with Two Dashes
In this article, Brent Ozar explains why you should avoid starting T-SQL comments with two dashes.
2021-04-26
What is interpolation?
In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before computers.
2021-03-31
Scripts to Automate Creating and Loading a SQL Server Table
Use these T-SQL strategies for dropping, creating, and populating tables in custom schemas across different SQL Server versions from SQL Server 2019 back to SQL Server 2005.
2021-03-24
A data transformation problem in SQL and Scala: Dovetailing declarative solutions
This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a SQL execution plan for software design.
2021-03-18
T-SQL Tips and Tricks
In this article learn some TSQL tips and tricks working with CTEs, UPDATES, Window Functions, Duplicate Rows, Tally Tables and Concatenating string values in SQL Server
2021-03-10
sqldf in R Example for SQL Server
R has a package called sqldf that allows developers to manipulate data inside a dataframe in the same way a SQL developer queries a SQL table which we will cover with examples in this article.
2021-03-01
How to Batch Updates A Few Thousand Rows at a Time
In this post, Brent explains how to use a combination of two separate topics that he has blogged about recently.
2021-01-20
Blogs
A New Word: Flichtish
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
Automating Container Image Builds with Docker Build Cloud and Github Actions
In a previous post we went through how to use Docker Build Cloud to...
The Ireland and UK DevOps Roadshow
By Steve Jones
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate...
Forums
Linked Server Product Name?
Just came across something weird. Was wondering if anyone else has ever seen this....
Can index fragmentation cause the database to enter suspect mode?
My database was in suspect mode, and when I checked using DBCC CHECKDB, it...
Creating Statistics on XML
Comments posted to this topic are about the item Creating Statistics on XML
Question of the Day
Creating Statistics on XML
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers