Newsletter Subject

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

From

sqlservercentral.com

Email Address

subscriptions@sqlservercentral.com

Sent On

Fri, Jul 5, 2024 07:55 PM

Email Preheader Text

SQLServerCentral Newsletter for July 5, 2024 Problems displaying this newsletter? . Featured Content

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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

EDM Keywords (219)

years year wrong write would world working work wonder wife went well week website way watched watch warehouse wanted want voice visit values used us upgrade upc unsatisfying understand tuesday trying topic today time thursday think terminal technology task take table sure summer subreport stuck story stay starting ssms split space someone situations since signed set server series sent send seen seem see seasons scripts screenshot run return restore rest respond report replentype replenishable removed remember redirected recover recommendations rebuild realized read question pulling pros printing primary post point planning plan places permission pdf open one newsletter netflix need music movies month microsoft meets make lot lost loss logic like life leave least laugh latter latest lakehouse know keeping keep job items ip interesting indication inconsistent ideas idea hyperbole highlights help header great grateful graph got good galaxy friends found forums following find file fields field feels faster fails failing eyes experience expect exist executed even europe error episode entertainment entertaining ensured enjoying enjoyed end email editorial dropping downsides documentaries discussion different default dedicated debate dba day date databases database data created cover could cons confusion concept complete clicking clause changed caught casting case bunch break bottom books book beginning barely back awhile architectures apple aoag anyone anymore anybody answer another also advise advace add actor accomplish 30hrs 1988 1987

Marketing emails from sqlservercentral.com

View More
Sent On

11/11/2024

Sent On

28/10/2024

Sent On

16/10/2024

Sent On

09/10/2024

Sent On

07/10/2024

Sent On

05/10/2024

Email Content Statistics

Subscribe Now

Subject Line Length

Data shows that subject lines with 6 to 10 words generated 21 percent higher open rate.

Subscribe Now

Average in this category

Subscribe Now

Number of Words

The more words in the content, the more time the user will need to spend reading. Get straight to the point with catchy short phrases and interesting photos and graphics.

Subscribe Now

Average in this category

Subscribe Now

Number of Images

More images or large images might cause the email to load slower. Aim for a balance of words and images.

Subscribe Now

Average in this category

Subscribe Now

Time to Read

Longer reading time requires more attention and patience from users. Aim for short phrases and catchy keywords.

Subscribe Now

Average in this category

Subscribe Now

Predicted open rate

Subscribe Now

Spam Score

Spam score is determined by a large number of checks performed on the content of the email. For the best delivery results, it is advised to lower your spam score as much as possible.

Subscribe Now

Flesch reading score

Flesch reading score measures how complex a text is. The lower the score, the more difficult the text is to read. The Flesch readability score uses the average length of your sentences (measured by the number of words) and the average number of syllables per word in an equation to calculate the reading ease. Text with a very high Flesch reading ease score (about 100) is straightforward and easy to read, with short sentences and no words of more than two syllables. Usually, a reading ease score of 60-70 is considered acceptable/normal for web copy.

Subscribe Now

Technologies

What powers this email? Every email we receive is parsed to determine the sending ESP and any additional email technologies used.

Subscribe Now

Email Size (not include images)

Font Used

No. Font Name
Subscribe Now

Copyright © 2019–2025 SimilarMail.