Shrink Database Log Files One by One (2023-03-31)

SQLServerCentral Newsletter for March 31, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Shrink Database Log Files One by One]( - [PASS Data Community Summit 2023 registrations are open!]( - [Snowflake Temporary Tables vs. Transient Tables]( - [From the SQL Server Central Blogs - SQL Bits 2023 Recap]( - [From the SQL Server Central Blogs - The AI T-SQL Tuesday–#160]( - [Expert Performance Indexing in Azure SQL and SQL Server 2022]( Question of the Day - [Minimal DOP Feedback]( The Voice of the DBA  Building a Better Profile I give talks on branding and managing your career at various events. Often I am helping people to better market and sell themselves if find new opportunities. One area that I talk about for data professionals is the online profile. I think having one is important, especially as many of our contacts with potential employers are made digitally. I ran across [an article that focuses on LinkedIn](, specifically the profile you create there. It has some thoughts on recommendations, accomplishments, certifications, and more. I like the thoughts, and I do think they help showcase who you are as a professional working in some field. It is worth reading through the article and adjusting your profile to include these items. I'd guess that most people don't have these things to add. They might have friends who will write a recommendation, but what about classes, certifications, projects, etc? Getting those is real work, and it's an investment of time and effort to grow your abilities. Having a full (or fuller) profile helps you stand out. It helps give hiring managers confidence that you are a person who can do the job they need. Getting this full profile, however, is something you need to do over time. Invest in your skills and showcase this in your profile. One easy way to do this is to take the work you do and document it. Write blogs, share posts, create an ongoing commentary of what you do at work. When you feel proud of something you've done, find a way to add it to your profile. This will create the impression that you are getting things done and solving problems at work. I'm sure all of you do this. Take a little time and ensure the next person that might consider hiring you, or the person you want to hire you, knows this as well. It can be easy to talk about these things in an interview, but you need to get the interview first. Your resume/CV and profile are how you get the interview, so be sure you are taking care of them across time. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Shrink Database Log Files One by One]( Manie Verster from SQLServerCentral Learn how you can shrink your transaction log files serially, one by one. [External Article]( [PASS Data Community Summit 2023 registrations are open!]( Additional Articles from Redgate In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Sign up to receive the latest updates in your inbox. [External Article]( [Snowflake Temporary Tables vs. Transient Tables]( Additional Articles from MSSQLTips.com When working with Snowflake, it is important to understand the different types of tables available and when to use each one. In this tutorial, we will compare Snowflake temporary and transient tables, highlight their similarities and differences, and provide examples of when to use each type of table. [Blog Post]( From the SQL Server Central Blogs - [SQL Bits 2023 Recap]( DataOnWheels from DataOnWheels I had an amazing time adventuring to Wales with other members of the data community last week! It was my first international conference, and I had heard so many... [Blog Post]( From the SQL Server Central Blogs - [The AI T-SQL Tuesday–#160]( Steve Jones - SSC Editor from The Voice of the DBA It’s time for T-SQL Tuesday again, and this time there is an interesting invitation. Damien Jones reached out and wanted to host, so he gets to pick the topic... [Expert Performance Indexing in Azure SQL and SQL Server 2022]( [Expert Performance Indexing in Azure SQL and SQL Server 2022]( Steve Jones - SSC Editor from SQLServerCentral Take a deep dive into perhaps the single most important facet of query performance―indexes―and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other […]   Question of the Day Today's question (by Steve Jones - SSC Editor):  Minimal DOP Feedback When SQL Server 2022 adjusts DOP using the DOP feedback feature of Intelligent Query Processing, what is the minimal level that can be chosen? 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) Contained Availability Groups In SQL Server 2022, a contained availability group adds which features to an AG? Answer: logins and SQL Agent Jobs synched across nodes Explanation: A contained availability group is designed to sync those objects in master or msdb across the nodes is done in limited fashion, but of the list above, this includes logins and SQL Agent jobs. Ref: What is a contained availability group? - [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 [Calculate log space required on principle for maintenance activity]( - Hi all, We have a database configured for asynchronous mirroring. We have some planned maintenance activity on mirror server. Expecting for 6-8hrs. How to calculate the log space requirements on Principle server after you run the command on principle alter database set partner suspend [Need an alert for a sudden increase in data]( - Hi All, Today, all of a sudden the size of the data file (.mdf) is increased by 30 GB and drive got filled up. Is there a way, to get an alert on such sudden increase of data and can we capture the query(s) and spids which caused the data grow that huge? Regards, Sam SQL Server 2017 - Development [Tsql query to show currently running sql agent jobs]( - Hi All, Using Tsql query I want to know currently running sql agent jobs and how long they have been running in [dd hh:mi:ss]? Expected output: job name , start time, duration [dd hh:mi:ss] I can see it in Job activity monitor for currently running jobs but it is not telling me when it started […] [SQL Agent Job schedule]( - Hi All, Want to know what are the SQL Agent Jobs scheduled for today at what time they are going to run ? Env : SQL Server 2017 CU23 Regards, Sam [how to identify table(s) changing quite often]( - Hi All, Is there any query using which we can tell what is the table which is changing the most or more frequently? The idea, is to identify those tables and run update statistics with full scan on daily basis instead of weekly basis. Regards, Sam SQL Server 2016 - Development and T-SQL [SQL blocking caused by running ALTER VIEW script]( - Hello experts, One of our developers tried to alter a view and reported to me that it was taking a long time. When I checked, it turns out that, for some reason, running the ALTER script is consistently causing database blocking. I ran a trace to capture the blocked process report. Below is an excerpt […] SQL Server 2019 - Administration [SQL Agent jobs - script to get what jobs failed]( - I have been trying to find SQL that shows what SQL Agent jobs failed as our manager wants a report generated showing what jobs fail. The below SQL I have found but it shows which steps fail but that is not what I want. Reason being is that we have an AG environment and the […] [Need help desperately]( - I accidentally ran this on a dev server which has locked my acct and I am unable to drop the trigger. Can someone help please? --Create the dbo.ServerLogonHistory Table CREATE TABLE dbo.ServerLogonHistory ( EventType VARCHAR(512), PostTime DATETIME, SPID INT, ServerName VARCHAR(512), LoginName VARCHAR(512), LoginType VARCHAR(512), SID VARCHAR(512), ClientHost VARCHAR(512), IsPooled BIT ) GO --Grant insert […] SQL Server 2019 - Development [Seperator after value]( - Hi, I need to insert a separator after each value but I don't want to mess the db with irrelevant characters. The best separator would be a semicolon. I got 5 columns in my db and export them via SQL Server Agent further to my FTP Server. The easiest way would be through the Server […] [Get a Date Time Stamp of table when another columns value changes.]( - I have created a table as per below query CREATE TABLE [dbo].[mydbtemp]( [Datetime] [datetime] NULL, [Tagvalue] [int] NULL ) ON [PRIMARY] GO Inserted Values Like insert into MYDBtemp values ('2023-02-03 03:00:00.000', '1') insert into MYDBtemp values ('2023-02-03 04:00:00.000', '1') insert into MYDBtemp values ('2023-02-03 05:00:00.000', '2') insert into MYDBtemp values ('2023-02-03 06:00:00.000', '2') insert into […] [SSIS C# Script Question]( - Hi everyone I am working on a SSIS package where I am automating data collection and table updates. My script is not performing as expected. I am not sure how I can revise it in a way that doesn't make the script too complicated. I am hoping there is an efficient way to fix it. […] [Slow performance when processing a JSON file in Azure]( - We have a stored procedure that can load up a JSON file and process this in 12 seconds However on Azure ...this is taking up to 90 seconds. this is running on an Azure pay as you go database. Now the code isnt too complex as is doing the following. Code is shown... Json File […] SQL Server 2008 - General [how to write a query by using some filter patterns in SQL Server?]( - what I want is to apply some filter patterns to search the data. For example. There is a large physical table in the database regarding medicines, I want to allow search even if user write lasix, lasixx, lasixxx, lasax, lasi, lisax. Data should be retrieved for the medicine lasix. How can I write these filter […] SQL Server 2022 - Administration [script to find the frequent used login information in the sql]( - Hi, Kindly some one share the script or query to get the login information used for the sql database in the instance. InstanceName,DatabaseName,HostName,LoginName,Program,date used etc Thanks, Jo [SQL Server Agent is not expanding and Jobs are not visible]( - Hi, We are not able to expand the SQL SERVER Agent. It is taking very long time. It is throwing below error. Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: ADDITIONAL INFORMATION: Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222) For help, click: -- If the Agent opens No […]   [RSS Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -