Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

What Do You Drop?

Many years ago I was training for a triathlon. I had competed in the Sandman Triathlon the previous year in Virginia Beach and wanted to do it again. I had a young child, work was busy, and I was struggling to find time to swim, bike, and run every week. One night, I was at a work event with a customer who was also a triathlete. He was much more competitive and successful than I was at competing in triathlons, and he told me I should just get up earlier and find time to train or ensure I spent time after work on training before I went home to ensure I was meeting my goals.

That sounded fine. Want to be better at something, then spend time on it. Certainly, that's what I often advocate for your career. Spend time on your career.

However, if I get up earlier, then that means I'm more tired at the end of the day. I'll go to sleep, or more likely fall asleep, earlier and miss time with my wife. She won't like that. If I try to ensure we get the same amount of time, I'd likely shortcut time with my kid. There's no magic way to find more time. If I take time to do one thing, I'm taking time away from something else.

The same thing happens at work. Our Chief Marketing Officer noted this at our global meetup recently, saying that too many people are adding new tasks or projects and letting other work fall away. They don't mean to let other work drop, and sometimes that's a problem, but the reality is that we can only get a certain amount of work done as a group, and if we add new work, old work gets lost. The same thing applies to coding software. We might get more work from a developer in the short term, but that falls apart long term, and it can be bad for retention.

Time is one of the most valuable resources you have in life. I see this more and more as I age, and you must recognize that it's a limited resource. For a short time, you might be able to get more time by sleeping less (or working more), but those things mean you are dropping other things in your life. That often isn't good for our health, relationships, or happiness over time.

If you want to do something more, or new, then you should consciously decide what to drop. You have to make decisions and choose what is a priority and what is not. The things that are not a priority might get dropped (or their time reduced). That's a big part of growing and maturing, as well as one of the worst parts. Making choices is hard.

Decisions you make are rarely permanent. They are often choices you make for a period of time. You'll make some great choices and those might be long-term or permanent. You might make bad choices, which hopefully are short-term, and then decide to make a new choice. Whether this is at work or in your personal life, make the choices that drive you forward, towards your goals, but with an eye on keeping a balance across all parts of your life.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
  Featured Contents
SQLServerCentral Article

Recover a Database from Suspect Mode Step by Step

Nisarg Upadhyay from SQLServerCentral

Learn how you can recover a database that is in suspect mode.

External Article

Index cleanup : Harder than it looks

Additional Articles from SimpleTalk

I’m not the first person to write about cleaning up unused or redundant indexes.

External Article

10 tips for Test Data Management success

Additional Articles from Redgate

What are the challenges to implementing a successful test data management strategy? In our recent webinar ‘Harnessing the Power of Test Data Management: Strategies for Success’, Redgate’s Steve Jones was joined by Hamish Watson (DevOps Consultant) and Daniel Watkins (Director/Principal Consultant) to talk all things TDM and how to implement it efficiently and effectively. Here are 10 key tips and takeaways from their conversation in a short blog post.

Blog Post

From the SQL Server Central Blogs - dbatools Required Filesystem Access for Database Restores

alevyinroc from FLX SQL

The Problem While performing an instance migration this spring, I happened upon something I didn’t expect in [dbatools](https://dbatools.io/). It should have been a simple backup/restore copy of the databases,...

Blog Post

From the SQL Server Central Blogs - Kilt Day!

Grant Fritchey from The Scary DBA

This is a quick blog post to announce that I am reviving Kilt Day at PASS Data Community Summit. Over the last few years… ah hell, let’s just say...

Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

Site Owners from SQLServerCentral

Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance’s performance. 

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Adding and Updating

I run this code, but get an error:
USE AdventureWorks GO ALTER TABLE Sales.CreditCard ADD defaultcard BIT UPDATE sales.CreditCard SET defaultcard = 0 
What's is the error?

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)

Database Options and Numeric Roundabort

I run this code:

ALTER DATABASE sandbox SET NUMERIC_ROUNDABORT Off

Then, in the sandbox database, I run this:

DECLARE @a NUMERIC(5,3) = 1.24 DECLARE @b NUMERIC(5,3) = 1.465 DECLARE @c NUMERIC(5,1) SELECT @c = @a + @b SELECT @c

What is the result in @c?

Answer: 2.7

Explanation: When I set numeric_roundabort off, this just works, with the result (2.705) being rounded to 2.7. Ref:

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
Searching for the Assumed Full Backup - I have this maintenance plan with differential backup and maintenance clean-up task in it. The plan runs once daily, and the clean-up task is deleting backup files older than 1 week. There is no other full backup plan or subplan there in SSMS. I ran the following script day before yesterday, yesterday and today to […]
SQL Server 2016 - Development and T-SQL
Can you pass an undeclared variable to a Stored Procedure - If I have a SP that calls another/different SP can I pass to that second SP a variable that has not been declared within the 1st SP and which was not passed to the 1st SP like the below?  I am walking through some code in a SP and found that it had a variable […]
SQL Server 2019 - Administration
Windows 11 & sudden SSMS sorting nuisance - When I was still in Windows 10, I'd open up SSMS (version 18) and go to Object Explorer Details, where I would see the folders System Databases and Database Snapshots up at top and all the individual database names listed in alphabetically order (unless I sorted otherwise). Now that I've upgraded to Windows 11, something […]
HADR SYNC COMMIT / deadlock rebuild index - Hi, I have some interesting issue. Server1 2024-08-09 02:59:25- start session 234 with UPDATE STATISTICS on Table1 WA_sys_xxxx stat 2024-08-09 03:00:08 - start session 800  - with ALTER INDEX on Table1 with Index1 2024-08-09 03:00:25 - deadlock session 800 like victim and session 527, which is application with some MERGE 2024-08-09 03:04:22 - first record […]
Ping a sqlinstance - How do I (ping/check if up and running) a sqlinstance  from t-sql ?  
SQL Server 2019 - Development
can my phone run ssms inside our firewall? - Hi my phone is now upgraded to allow teams , outlook etc using my work account.   Its a portal more or less. Is there a way to leverage my new portal to run ssms from my phone so i can check on the status of a couple of jobs rather than carrying my pc around […]
what have people done for ssrs params needing very precise start and end times - Hi we run 2019 standard.  one of our mfg locations requires somewhat precise start and end param times along with the start and end dates controlling how an ssrs report is filtered. our main user doesnt like the idea of them typing hh.mm.ss.nnn next to the date showing when they pick a date from the […]
Integration Services
Destination Table - Condition Amount 0 - I need your assistance with an ETL process that runs every six months. Currently, we are in Calendar Year/FY 2025, which started in July 2024. The issue is with the "Condition Amount" for FY 2025. Data comes through correctly until the "Insert Data Into Task" step (please see the attached screenshot). However, it appears that […]
Destination Table - Condition Amount 0 - I need your assistance with an ETL process that runs every six months. Currently, we are in Calendar Year/FY 2025, which started in July 2024. The issue is with the "Condition Amount" for FY 2025. Data comes through correctly until the "Insert Data Into Task" step (please see the attached screenshot). However, it appears that […]
Destination Table - Condition Amount 0 - I need your assistance with an ETL process that runs every six months. Currently, we are in Calendar Year/FY 2025, which started in July 2024. The issue is with the "Condition Amount" for FY 2025. Data comes through correctly until the "Insert Data Into Task" step (please see the attached screenshot). However, it appears that […]
Design Ideas and Questions
Why is it a good idea to not restore a production database to test? - (I looked over all the forums here on SSC and this one seemed the best for my question. If you think I'm wrong, I'm sorry I posted my question here.) For years I've read here and elsewhere that it is not a good idea to restore a production database to its equivalent test database. I've […]
SQL Server 2022 - Administration
Collation Change - Any recommendations on changing the collation if DB ? There is dependent objects so simple alter won't work. Also DB to big to generate script with schema and dats
In primary alwayson replica index maintenance plan need tobe prepare fordowntime - Dear all, I have a 3.5 tb primary always on database with 2 secondary replica one is sync and dr is async In primary always on replica index maintenance plan need to be prepare for downtime can any one mention the order for the plan and its steps to follow Do we need to suspend […]
OLA's Maintenance scripts - should I be reorganizing? - Hi These are my current params for nightly maintenance: USE MASTER EXECUTE dbo.IndexOptimize @Databases = 'MY USER DB', @FragmentationLow = NULL, @FragmentationMedium = 'INDEX_REBUILD_ONLINE', @FragmentationHigh = 'INDEX_REBUILD_ONLINE', @FragmentationLevel1 = 25, @FragmentationLevel2 = 50, @SortInTempdb = 'Y', @MaxDOP = 2 I have removed 'REORGANIZE' as per Jeff's thread here: https://www.sqlservercentral.com/forums/topic/review-ola-hallengren-indexoptimize-parameters Am I correct in removing the […]
SQL Server 2022 - Development
Query timeout question - I am debugging (sort of) a problematic query, that gives a timeout error (30 seconds) in our company application. I've captured the query + parameters using Extended Events and when I run the exact same query with the same parameters in SSMS, it takes about 1 second. Anyone got any ideas what's happening here?
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. 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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -