Two Clustered Indexes?
Everyone knows that you only get a single clustered index, right? Wouldn’t it be great though if you could have two clustered indexes? Well, you can. Sort of. Let’s...
2022-01-31 (first published: 2022-01-18)
446 reads
Everyone knows that you only get a single clustered index, right? Wouldn’t it be great though if you could have two clustered indexes? Well, you can. Sort of. Let’s...
2022-01-31 (first published: 2022-01-18)
446 reads
I am looking forward to presenting to the Ohio North Database Training User Group this Tuesday, February 1st, starting at 4:00pm CST. It is exciting for me to kickoff...
2022-01-29
35 reads
I was doing a little work with CosmosDB recently, and there were a few things that surprised me about the platform. I’m also not 100% sure I completely understand...
2022-01-28 (first published: 2022-01-17)
237 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-28
31 reads
As a SQL architect or database administrator, it is required to know how to get SQL Server configuration using T-SQL. This post will share
2022-01-28
300 reads
In talking with Microsoft customers, I have found that most are not aware that Microsoft has created industry clouds (see Microsoft Industry Clouds). So I wanted to use this...
2022-01-28 (first published: 2022-01-18)
154 reads
In the last post I wrote about what ScriptDOM is and why it is useful. From this post, I will explain how it can be put to use. What...
2022-01-28 (first published: 2022-01-27)
106 reads
Have you ever had to find the number of rows in a user table, and then wrote a little “SELECT COUNT(*) FROM tblWhatever” and hit execute…and waited…and waited…and waited...
2022-01-28
305 reads
This article will demonstrate the method to store comma-separated values into different columns using SQL Server(T-SQL) query.
2022-01-28
486 reads
Today's post describes SQL queries to get the following information about the processors of a SQL Server instance: 1. The total number of ph
2022-01-28
171 reads
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
By Steve Jones
This was one of the original values: The facing page has this text: No...
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Comments posted to this topic are about the item Create an HTML Report on...
My wife apparently ask her phone a question and below is what she sent...
Comments posted to this topic are about the item I Love Editorials
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers