 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | Burnout This editorial was originally published on Oct 29, 2015. It is being republished as Steve is on vacation. Kind of a funny one to schedule for my vacation I'm sure that many people end going through burnout at some point in their career. While most of us might enjoy technology, and we get a kick out of working with data, at some point you're not going to like your job. This could be because you're overworked, or it could be that you don't have enough to do. Either way, I would bet that many people flow through the phases of burnout that Kendra Little documented in this post. Burnout isn't necessarily the end of a job, but it is a state that most of us wouldn't want to remain in. Apart from disliking your own situation, and perhaps annoying your fellow employees, you certainly aren't helping your career. Especially if you are in stages 1 or 2. I've seen stage 3 be positive or negative, but it doesn't really work out well to try and outwork the job. Most of the time this leads to unhealthy levels of work for you, and unrealistic future expectations for your employer. When things aren't going well, do as Kendra suggests and address the issues. Make those small changes that adjust your attitude and help you cope better. Smile, try to view the things that bother you from the perspective of others, and look to keep perspective with what you do. Most of us aren't in life-threatening or hazardous jobs, and we should remember that. If you think you're burned out and really need to switch jobs, make a plan to move on. Looking for another job is stressful, and it's hard, but the best time to do it is while you have another job. Take your time and make a good decision for your future. Perhaps the project of looking for a new job will help ease the troubles you face at this one. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT |  | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
|  | | The single question to predict success for DevOps, and what it means for change control In this 30 minute session, Microsoft MVP Kendra Little will share and discuss her three key insights from the 'Gene Kim joins Redgate to discuss The 2018 Accelerate State of DevOps Report' webinar, and show why these insights make a compelling argument for rethinking your organization's change control process.
Register now |
|
|
|
| | |  | Karthik K from SQLServerCentral.com This article will show how you can get the column name for error rows in an SSIS 2016 Data Flow task. More » |
 | Find out what plans Redgate has for SQL Census and leave your comments to have your own input in the future of the tool. More » |
 | Additional Articles from SimpleTalk The Extended Events (or XEvents) feature has been part of SQL Server since 2008, but many database professionals struggle to get started using it. In this article, Phil Factor demonstrates several useful Extended Event sessions that measure just one thing in each. He then provides the code necessary to parse the resulting XML into something you can use. More » |
 | Additional Articles from SQLServerCentral.com On Monday, November 5th, 2018, the 5th annual “Seattle Freecon” (a FreeCon in Seattle for those that might not be attending a pre-con before the PASS Summit) will be held. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of 6 sessions you can attend for free that day. That’s right, absolutely FREE. More » |
 | Bert Wagner from SQLServerCentral Blogs While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can’t get around adding some... More » |
| | Matthew McGiffen from SQLServerCentral Blogs When I’m using Profiler to analyse performance issues I often save the results to a table, or upload a trace... More » |
|
|
| | | Today's Question (by Steve Jones): If I want to use the COMPRESS() function in SQL Server 2016, what options do I have for the algorithm? |
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: COMPRESS(). 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 | | T-SQL Querying (Developer Reference) Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): In one of my SQL Server 2017 instances, I have a database that contains multiple filegroups, each with multiple files. One of these filegroups is the Logger filegroup, which contains a table that grows often with auditing information. I have spent some time trying get ensure all the files are roughly the same percentage full of data. My goal is to alter the database so that when there is a need for a file to grow to accomodate new information, all files in this filegroup grow. What option do I add to the ALTER DATABASE MODIFY FILEGROUP syntax?
Answer: Use the AUTOGROW_ALL_FILES option Explanation: Starting in SQL Server 2016, there is an option to allow either one file to grow (the default) or have all files in a filegroup autogrow. Ref: Database file and filegroup options - click here
» Discuss this question and answer on the forums |
|
|
| | | Joe Chang from SQLServerCentral.com create as a system procedure, or in specific database use: same as sp_helpindex modify as desired More »
|
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums.
Does anybody know whats new in SSMS 2018 preview compared to SSMS 2017? - Does anybody know whats new in SSMS 2018 preview compared to SSMS 2017?
Data modelling: how do you handle child records when doing a soft-delete? - I'm facing an dilemma in something similar to a sales database with parent-child relationships between the tables "Country", "Region" and... Speed of SSIS execution much slower in package execution as step( "Execute Package Tasks") compare to single package execution - Hi, I am creating data migration scenario for SQL 2017 I need to load 160 GB from ~250 tables Server A database... How to build an app with GUI that works with SQL Server? - I have to create a project which should have a GUI because people who gonna use it don't know TSQL....
Where is the Performance Bottleneck? - Evening Guys, I am back with another performance enigma (at least for me!). I have a couple of queries (altering the collation... Tables using ANSI_NULLS - Hi, I have a database that's comprised of over 10,000 tables. Approximately 250 tables were created with ansi_nulls set to "on"...
Compare top 2 transactions from 12 months from the current transaction date -
SBU???,+??695640122 SBU???,?????????????,SBU?????offer,SBU???,SBU???????? - ?QQ-??:695640122 ??(????????)???SBU???,?????????????,??,??,???,?????????: ??????????(????1:1?????) ??????(????????,???????,?????) ???????????? ???????(????????) ???????,??,??,??,???,??????? ??????: 1?????????; 2????????; 3???????????????; 4???????????????; 5??????(????,??DHL)? ??????????,????!??????,??????? NEU???,+??695640122 NEU???,???????,NEU?????offer,NEU???,NEU???????? - ?QQ-??:695640122 ??(????????)???NEU???,?????????????,??,??,???,?????????: ??????????(????1:1?????) ??????(????????,???????,?????) ???????????? ???????(????????) ???????,??,??,??,???,??????? ??????: 1?????????; 2????????; 3???????????????; 4???????????????; 5??????(????,??DHL)? ??????????,????!??????,??????? Rutgers???,+??695640122 Rutgers???,????????,Rutgers?????offer,Rutgers???,Rutgers???????? - ?QQ-??:695640122 ??(????????)???Rutgers???,?????????????,??,??,???,?????????: ??????????(????1:1?????) ??????(????????,???????,?????) ???????????? ???????(????????) ???????,??,??,??,???,??????? ??????: 1?????????; 2????????; 3???????????????; 4???????????????; 5??????(????,??DHL)? ??????????,????!??????,??????? UCR???,+??695640122 UCR???,???????????,UCR?????offer,UCR???,UCR???????? - ?QQ-??:695640122 ??(????????)???UCR???,?????????????,??,??,???,?????????: ??????????(????1:1?????) ??????(????????,???????,?????) ???????????? ???????(????????) ???????,??,??,??,???,??????? ??????: 1?????????; 2????????; 3???????????????; 4???????????????; 5??????(????,??DHL)? ??????????,????!??????,??????? TU???,+??695640122 TU???,????????,TU?????offer,TU???,TU???????? - ?QQ-??:695640122 ??(????????)???TU???,?????????????,??,??,???,?????????: ??????????(????1:1?????) ??????(????????,???????,?????) ???????????? ???????(????????) ???????,??,??,??,???,??????? ??????: 1?????????; 2????????; 3???????????????; 4???????????????; 5??????(????,??DHL)? ??????????,????!??????,??????? UH???,+??695640122 UH???,????????,UH?????offer,UH???,UH???????? - ?QQ-??:695640122 ??(????????)???UH???,?????????????,??,??,???,?????????: ??????????(????1:1?????) ??????(????????,???????,?????) ???????????? ???????(????????) ???????,??,??,??,???,??????? ??????: 1?????????; 2????????; 3???????????????; 4???????????????; 5??????(????,??DHL)? ??????????,????!??????,???????
Record with Max Date from Table T2 - Hi I have below code and i want record with Max Date from Table 2 SELECT * FROM dbo.Employee T1 Left join... Update Statement - Hi Can the below 2 Update statements be executed with 1 Update statement Update set DTemp = A.Category from as A where... SQL Server 2008 R2 installation error "a mof syntax error occurred " - Hi; Team; at the time of installation MS SQL Server 2008 R2 on windows server 2003 I am facing following error Error...
Identify Deals Sold by W2 Employees Only - For this example assume a company has both W2 and commission employees. What I'm trying to identify is sales record...
How many clustered indexes can a table have? - The obvious answer is one, but there is something more fundamental in this. This question is even discussed at PASS... |
|
| 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|