How much Space can I expect to recover from a rebuild after dropping a column? (2024-07-05)

SQLServerCentral Newsletter for July 5, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [How much Space can I expect to recover from a rebuild after dropping a column?]( - [Choosing Between the Lakehouse and Warehouse in Microsoft Fabric]( - [From the SQL Server Central Blogs - How do you restore a SQL Server 2000 database in the year 2024?]( - [From the SQL Server Central Blogs - Polyglot Persistence]( - [Deciphering Data Architectures]( Question of the Day - [Which is a table?]( The Voice of the DBA  Midsummer Fun Yesterday was Independence Day in the US and a day off for me. Today, I'm back to work. Same for my rocket engineer son, one day off. My wife remembers a few of her companies giving a 4-day weekend when a holiday falls on a Tuesday or Thursday, but that hasn't been my experience and isn't this week. I know we're barely into summer, which technically started Jun 21, but most of my life has measured summer between the end of one school year and the beginning of another. That's usually late May (Memorial Day) to early September (Labor Day). I think that's a very American thing, as I know lots of my friends in Europe are just starting their break between two grade years. For those of you in the Southern Hemisphere, I'm sure this time of year is even more different. In any case, since it feels like midsummer to me, I wanted to take a break from technology and write about interesting fun things I've seen lately in the world of books and tv/movies. Even as I write that it seems strange since I think TV isn't a concept for me anymore. I've gone completely to digital streaming, with episodic shows that aren't ever broadcasted. They just drop, individually or as a whole season at once. In any case, I'm starting with [Presumed Innocent](. I read this book a long time ago, probably in 1987 or 1988. I couldn't remember the story, but a friend recommended the series on Apple+. The first episode started slow, and I wasn't sure I'd watch more, but the end caught both my wife's and my own eyes. We had to watch the second episode right away. It's dropping episodes week by week, which feels very old-fashioned and unsatisfying. I've also been working through [Lost in Space]( on Netflix. I've watched the various versions of this since the old black-and-white TV version. I went through Season 1 of this a few years ago and really enjoyed it. I just realized there were more seasons and have been enjoying them. It's a bit silly, far-fetched, and inconsistent in places, but still entertaining as a sci-fi view of colonists traveling through strange places in the galaxy. My wife and I completed season 1 of [Resident Alien]( on Netflix as well. The casting is great and it was very entertaining. A fun watch for us. I haven't found a lot of funny series lately, and fall back on old episodes of [Scrubs]( [Community]( (first 2 seasons), [Brooklyn Nine-Nine]( the US [Office]( and [Mom](. Even though I've seen most of these series, they're still good for a laugh. Once in awhile I even see an episode I haven't seen (or don't remember). In any case, Resident Alien was good. I like to read a lot. This summer, I've caught up on the latest in a few series I've enjoyed over the years. I'm working on [Spinward Fringe 17]( along with [Observability Engineering](. That latter isn't entertainment, but it is interesting. I've also enjoyed these books lately: [Toxic Prey]( [I Will Find You]( [Murder One]( [The Last Detective]( and [The Unincorporated Future](. I've read a bunch more, but those were the highlights. I haven't see many movies this year, but I have watched a few documentaries. The [Thriller 40th Anniversary]( the [We Are the World]( documentary, and the [George Michael]( one were great. I did see [One Love]( (on Bob Marley), but it wasn't that good. The music and actor are good, but the story isn't. If you want a fun, unusual watch, try the [Donut King](. If you've got some fun escapes from work, either written or video, let me know. I enjoy watching a Slack channel at work that is dedicated to movies and tv, getting some recommendations there. I'm sure I'll see something from one of you that's worth checking out. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [How much Space can I expect to recover from a rebuild after dropping a column?]( Cláudio Silva from SQLServerCentral Check how much space you may expect to recover from a rebuild after dropping a column! [External Article]( [Choosing Between the Lakehouse and Warehouse in Microsoft Fabric]( Additional Articles from SimpleTalk Microsoft Fabric is a new centralized, AI-powered cloud data platform hosted by Microsoft. It combines several services of the existing Azure Data Platform – such as Azure Data Factory – with Power BI, while also introducing new services. [Blog Post]( From the SQL Server Central Blogs - [How do you restore a SQL Server 2000 database in the year 2024?]( Randolph West from Born SQL with Randolph West A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I have a SQL Server 2000 database backup that I need to restore to a supported... [Blog Post]( From the SQL Server Central Blogs - [Polyglot Persistence]( Steve Jones - SSC Editor from The Voice of the DBA I’ve seen the term polyglot persistence floating around Redgate a bit recently in the marketing department. I haven’t really seen this term anywhere, and I wonder if you have.... [Deciphering Data Architectures]( [Deciphering Data Architectures]( Additional Articles from SQLServerCentral Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.   Question of the Day Today's question (by Steve Jones - SSC Editor):  Which is a table? Of these items, which are tables according to the relational model from Dr. Codd? CREATE TABLE dbo.Customers_a ( CustomerID INT IDENTITY(1, 1) NOT NULL, FirstName NVARCHAR(50) NOT NULL, LastName NVARCHAR(50) NOT NULL, Email NVARCHAR(100) NOT NULL, ); CREATE TABLE dbo.Customers_b ( CustomerID INT IDENTITY(1, 1) PRIMARY KEY, FirstName NVARCHAR(50) NOT NULL, LastName NVARCHAR(50) NOT NULL, Email NVARCHAR(100) NOT NULL, ); CREATE TABLE dbo.Customers_c ( CustomerID INT NULL IDENTITY(1, 1), FirstName NVARCHAR(50) NOT NULL, LastName NVARCHAR(50) NOT NULL, Email NVARCHAR(100) NOT NULL UNIQUE, ); CREATE TABLE dbo.Customers_d ( CustomerID INT NOT NULL , FirstName NVARCHAR(50) NOT NULL, LastName NVARCHAR(50) NOT NULL, Email NVARCHAR(100) NOT NULL, ); Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) The Variable DateName What is wrong with this code? DECLARE @p NVARCHAR(10) = 'year' SELECT DATEPART(@p, GETDATE()) Answer: A variable cannot be used for the datepart parameter. Explanation: A variable cannot be used for the datepart parameter. Ref: Datename - [ [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2017 - Administration [side effects of giving permissions to run traces]( - Hi All, I would like to know the downsides of giving permissions to run traces in lower environments (DEV/QA/UAT). Our DB team has only two members: one supports PST hours, and the other supports IST hours. The PST resource is on leave for a month, so I have to cover both time zones as needed. […] [Select permission denied despite group having db_datareader]( - I am at a loss and could use a second pair of eyes. We have a Server with database A and database B, a windows security group (MyDom\MyGroupName) which is created with dbo schema as its default in both databases, and a service account in this group. MyDom\MyGroupName has db_datareader in both databases. There are […] SQL Server 2017 - Development [Split fields sql 2017]( - I am trying to split fields in sql 2017. The column holds the following. I am pulling the first 50 characters and now I need to split those into 2 fields. This is a test name1             3006       […] SQL Server 2016 - Administration [connection does not open from SSMS]( - Dear Friends, Would be grateful if anybody can advise why one of my servers, doesnt allow a connection anymore from SSMS on my terminal. The IP address is the unchanged. SQL server port was changed I remember, that i am anyways providing in with the IP as IP:portnumber..Thanks in advace. [How to improve index rebuild for very large table.]( - My online index rebuild job for a 200G table with 40mil rows took me up to 30hrs to complete, this is a once off activity done since we have an allocated downtime for server maintenance. I would want to know, is there any way for me to do it faster? I had an idea of […] SQL 2012 - General [SQL code needed for the WHERE clause..]( - I have a table with data appending on a daily basis. We plan to keep the set of data in this table for one full year and delete everything after August 1st of every year. I am stuck with the query logic to do this. The situations are like this: If today's date is August […] SQL Server 2019 - Administration [Database growth report by full back file and send by email in graph and or html]( - Hello Gurus, How I am in need of all databases growth in 10 instance and send the report by an email. What's the best way to accomplish such task. If anyone has scripts or point me to a website that would be very helpful. thanks in advance. [Backuips are failing]( - After CU 27 update in sql 2019 backups are failing and all mainnaytainence jobs are also faling . we did not find any error on sql logs , pls assist on ho wto resolve this  Message Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 15.0.4375.4 for 64-bit Copyright (C) […] [Query Store with AOAG stuck on waiting]( - Hey Folks, I have a database on SQL 2019 CU24 in an AOAG with 1 primary and 2 secondary. I have enabled Query Store but it will not open and just shows Waiting on the primary. I have QS setup on standalone SQL 2016 databases and they seem to be working fine. Any help is […] SQL Server 2019 - Development [Web API Procedure will not run in SQL Server Agent Job]( - I have a stored procedure that pulls JSON data from a US government web API. The procedure executes fine manually but fails with the error below when executed from a job. I've checked permissions of the SQL Agent and ensured it has permission to execute sp_OACreate and sp_OAMethod procdures. Extremely grateful for any help or […] [Logic similar to EXIST to make all values the same if it meets a criteria]( - Hello everyone, I have a question. Please let me know if someone has any ideas. I need a logic with maybe EXIST(?) to check separately if for one Chain there is a field in REPLENTYPE with a value ‘SINGLE’ – I need all fields for this UPC at a specific Masterchainname to be ‘REPLENISHABLE’ for […] Reporting Services [SSRS Header not Keeping with report]( - Hi all, I have an SSRS report issue is when printing to PDF. i have a subreport that works fine, but when there is ONLY enough space for the header, it will stay at the bottom then the rest of the subreport continues on the next page. here is a screenshot of the subreport, mainly […] SQLServerCentral.com Website Issues [Weird redirect after reporting post]( - I just tried reporting this post: After clicking the 'Report post' button, I was redirected to this post: If I then return to the original spammy post, there is no indication that the report function worked. SQL Server 2022 - Administration [SQL Server 2022 Std edition eval version]( - Hi We are planning to upgrade our SQL Server 2014 Ent edition to 2022 Standard and i want to test Basic Availability Groups future. Is there a free evaluation version for SQL Server 2022 Standard edition? At least i could not find one Thank You SQL Server 2022 - Development [how to bulk insert a file on a azure sql server managed instance]( - Don't know if this is the right place for this topic. I have an internal azure sql server managed instance and am trying to read or write a file to the file system. As i understand, there is no file system on a sql server managed instance. Is there a way to add a file […]   [RSS Feed]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -