I’ll admit it, sometimes I’m wrong. Recently I blogged about the usefulness of a newer feature that was enhanced with the release of SQL Server 2019. Resumable Indexes operations...
2021-04-23 (first published: 2020-01-17)
1,276 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...
2021-04-23
4 reads
I hosted the blog party this month, with the invite to write about notebooks. These are a neat technology, and I’ve written about them at SQLServerCentral. This post is...
2021-04-23
21 reads
When I launched The Noncluttered Index last year, it was with the intention of writing at least twice a week. For a while, that was very doable. Then, work...
2021-04-23 (first published: 2020-01-14)
595 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...
2021-04-22
12 reads
Knowledge of how your system behaves is vital to better control, maintain, and grow the system. While Azure provides all sorts of wonderful assistance within Azure SQL Database, you’re...
2021-04-22 (first published: 2021-04-19)
210 reads
The other day I got a note from Ben Weissman the other day that he was running a new event, http://dativerse.io/. Not much information, but I liked this list...
2021-04-22 (first published: 2021-04-19)
178 reads
One of the technical books that sit on my work desk (or dining table, whichever is the case because I work from home full time now) at arm’s length...
2021-04-21 (first published: 2021-04-15)
410 reads
Next week on Wednesday is the Calgary Data User Group’s second event for 2021, and the second event as a member of Microsoft’s new Azure Data Community. Since last...
2021-04-21
14 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...
2021-04-21
4 reads
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Yes, you’re reading that right, we’re going to download a report that cannot be...
Because we are NABL Accredited Laboratories, our personal care and cosmetics research center provides...
hi, need to known weather fast farwand cursor is faster than a while loop...
Comments posted to this topic are about the item Economics of AI: What is...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers