SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

To-do list: good, bad or indifferent?

Today we have a guest editorial as Steve is on vacation.

All of us have to organize our efforts at work to get things done. I would guess a number of us use a to-do list. It might exist in Excel, OneNote, Notepad, just a plain piece of paper, or just in our minds. A list helps us to stay focused on what needs to be accomplished. It can also give us a sense of accomplishment when we cross something off the list. It also can make us feel like we are making progress toward a goal. Hopefully, we know what the end goal is and where it is leading us.

There can also be downsides with a to-do list. The list can become overwhelming and unmanageable. Sometimes things never seem to get crossed off. Perhaps it is because nothing seems to get fully completed, or just because we are pulled in so many directions, it can be hard to focus and to get much done. What does it matter if our to-do list gets accomplished since we can’t see above the waves of chaos that is our job?

In some situations, the demands on us are already so overwhelming, we are just dealing with issues and emergencies all day long. In this case, a to-do list is almost meaningless since it is never even looked at. You are just too busy trying to keep the ship afloat to even worry about where things are heading. The current fire that needs to be put out is what you are working on.

Sometimes not having work direction can be a problem. It is hard to create a to-do list if you don’t know what your priorities should be. If you do have a manager that clearly passes down to you what you should be working on, that can be helpful. Still, in some cases, the directives being passed down can be pretty general so it isn’t always easy to get down to the specific steps of what needs to get done.

It seems like the to-do list is only as good as the vision and plan behind them. If you know where you are going, you can figure out the steps to get there. If you don’t know where you are going, then it doesn’t matter what you are working on or in what order you try to accomplish things.

I think planning sessions can help with this. Having a team of people thinking about where, as a company / department / team, you are trying to go and what you are trying to accomplish. What issues are you currently facing? Where you want to be in six months to a year or 5 years from now? Once a plan is decided on, the steps to get there can be formed and directives can be given to groups. Then they can know what they should be working on and what should be their priority. Then it is up to you to use a to-do list or some other method to manage the things you need to accomplish.

How about you? Do you use to-do lists? Do you have clear directions on what you should be working on where you work?

Ben Kubicek from SQLServerCentral.com

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

ADVERTISEMENT
SQL Monitor

New SQL Monitor Reporting Module

SQL Monitor now includes a new Reporting module. It allows you to create customized reports, combining the individual server performance metrics available in SQL Monitor with summary information on your entire SQL Server estate. These reports can then be exported to pdf and emailed to you on a scheduled basis. Download SQL Monitor now and get a 14 day free trial

SQL Prompt

Could your SQL coding be more efficient?

Data Platform MVPs and SQL Server experts share their tips on how to standardize formatting whilst stripping out the repetition of coding with SQL Prompt. Over these 20 short videos we will help you write better, shareable SQL faster. Check out the tips

Featured Contents

 

Using Super Keys to Enforce Database Constraints

Dejan Mladenovic from SQLServerCentral.com

Example of Using Super Keys to Enforce Database Constraints, instead of procedural code More »


 

SQL Server Management Studio Recovery, Reporting, Key Combinations and Efficiency Tips

Additional Articles from MSSQLTips.com

Serget Gigoyan is back with another set of 5 common SSMS tips. More »


 

From the SQLServerCentral Blogs - SQL Server Agent and Daylight Savings time

matthew.mcgiffen 73574 from SQLServerCentral Blogs

There was a bit of chat today on the SQL Community slack about UTC and Daylight Savings Time. It reminded... More »


 

From the SQLServerCentral Blogs - Azure Cloud “Fear” Busting #2 – Seeking for Better Performance

Arun Sirpal from SQLServerCentral Blogs

We all want high performing applications and when you are in the cloud that is no different, if anything it... More »

Question of the Day

Today's Question (by Steve Jones):

What does the result of @@TIMETICKS mean?

Think you know the answer? Click here, and find out if you are right.


We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Timeticks.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

ADVERTISEMENT

Exam Ref 70-761 Querying Data with Transact-SQL

Prepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

When I create a table in an Azure SQL Data Warehouse, I can set the distribution of my data. What are the options I can use in the WITH (DISTRIBUTION = X) clause?

Answer: ROUND_ROBIN or HASH

Explanation:

There are two types of table distributions in ASDW as of July 2017: HASH and ROUND_ROBIN.

Ref: Working with Tables - http://www.sqlservercentral.com/articles/Azure+SQL+Data+Warehouse+(ASDW)/155806/

Distributing Tables - click here


» 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 2016 : SQL Server 2016 - Administration

Full backup size is very high - Hi, Database size is 65.4 gb (including mdf, log file and file stream directory) Full backup size is 341 GB. How to reduce...

Delete a wrong push subscription. - Hello, Recently after a server migration can see that some of the wrong / unwanted subscription still shows up in the repl...


SQL Server 2014 : Administration - SQL Server 2014

An article about Dba - Today I had an email sent from someone from internet, article named disappearing DBA, I read half of it, and...


SQL Server 2014 : Development - SQL Server 2014

Allow Zero Length Contraint - Hi Guys, I have a question about table constraints.  Most of the fields in my primary table allow nulls.  Mostly...


SQL Server 2008 : SQL Server 2008 - General

Difference between shrinking a database and shrinking individual files separately - Hi All, I've planned to free up some space in our database by dropping some tables that are no more required . Weighing between...

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.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com