Identify Tables With Dropped Columns
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
2,401 reads
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
2,401 reads
Long term data storage isn't something we always need for databases, but it is something the world needs. A new technology has promise for those use cases, both in durability and preserving the algorithms needed.
2022-06-24
375 reads
I ran across a tip on MSSQLTips from Joe Gavin recently, and it got me thinking about hardware and disks. For a lot of us, we deal with servers and storage, and not disks. While we might have a disk on a laptop or desktop, most of the production systems just attach to remote storage. […]
2021-11-03
291 reads
Understanding all the storage options available to...
2019-12-30
This article is an extract from the book Tribal SQL. In this article, Mark S. Rasmussen offers a concise introduction to the physical storage internals behind SQL Server databases. He doesn't dive into every detail, but provides a simple, clear picture of how SQL Server stores data.
2013-10-21
3,767 reads
In my previous post, I showed you how to build a snapshot backup catalog...
By Steve Jones
Train employees well enough that they could get another job but treat them well...
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Why Data Modelling Still Matters...
Hi when i think of server hops , i think of how kerberos assists...
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers