SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Intrinsic or Extrinsic

I was listening to an interview recently that talked about life and why many of us do what we do. It was a piece that also discussed some of the problems with modern US society and some of the potential unexpected consequences of the way that we have evolved in this country. As the discussion between the individuals proceeded, there was one question that stood out to me.

The question was about intrinsic v extrinsic motivators. One example given was playing the piano. If you sit down at home and choose to play because you enjoy it or it relaxes you, that's an intrinsic motivation. There could be all sorts of reasons why, but essentially you've made a choice to participate because you want to do so. If you go play at a bar because you need to make money, or your parents force/push you to play, or something other reason that pressures you, those are extrinsic motivators.

To be clear, one isn't necessarily better or worse than the other, but they both affect you, as a person, differently. There are also likely a variety of different intrinsic and extrinsic motivations that you have for many of your actions. The world and life isn't as simple as choices being the result of one of the other. Often our decisions are a blend of both.

Today, I wanted to ask you to think about the reason you're in your career. I assume most of you are working in technology, and you have various reasons for entering this work, some of which may not be valid anymore. Perhaps you've found new reasons to continue to work with data. You don't have to publicly answer, but think about this.

Why do you work with computers? Because you have to or you want to?

I'm sure this is a blend of factors for you as it is for me. I started with computers because I wanted to. I didn't have to work with them in school because we didn't have them at first. Even through much of my university work, computers were not ubiquitous and certainly were not required for most of my classes. I chose to work with computers and technology because I really enjoyed it. Even later, since I needed a career, I chose to work with technology instead of other industries and picked databases, which weren't my initial choice. I did move to databases primarily for money, though I'd done some development work and enjoyed the database aspect of it.

Today, I do need to work, so I have some extrinsic motivation to continue on this path, but I also do enjoy technology, and I'd like to think that I'd continue to do this type of work even if I could make enough money in another area. My wife is different, and without money pressure, she likely won't ever come back to technology.

Think about your motivations and pressures today. I'd be interested in how you feel if you're willing to share. Whether you are or not, take a moment and consider how you really feel about your career. 

Steve Jones from SQLServerCentral.com

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

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 4.1MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

SQL Compare

The industry standard for comparing and deploying SQL Server database schemas

Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial

SQL Provision

NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps

Create and manage database copies effortless and keeps compliance central to the process. With SQL Provisions virtual cloning technology, databases can be created in seconds using just MB of storage, enabling business to move faster. Sensitive data can be anonymized or replaced with realistic data to ensure data is protected as it moves between environments. Download your free trial

Featured Contents


Navigating Hadoop Resources

Daniel Klionsky from SQLServerCentral.com

Learn where to get the latest installation and learning resources for the ever-evolving components of Hadoop ecosystem and how those components may complement Microsoft SQL Server common everyday tasks. More »


“But I don’t need to back up that database.”

Additional Articles from Brent Ozar Unlimited Blog

Brent Ozar shares four stories of people who thought they could avoid backups - and got burned. More »


Avoid use of the MONEY and SMALLMONEY datatypes

One of SQL Prompt's code analysis recommendations is that you avoid using the MONEY and SMALLMONEY datatypes - this article from Phil Factor explains why. More »


From the SQLServerCentral Blogs - Watching the Sands of Suggestion in #SQLPrompt

Steve Jones from SQLServerCentral Blogs

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes... More »


From the SQLServerCentral Blogs - A rant about presentations

Gail Shaw from SQLServerCentral Blogs

My company’s internal conference is in a couple of weeks, so this seems like a good time to have a... More »

Question of the Day

Today's Question (by Steve Jones):

I have this code:

DECLARE @s VARCHAR(100) = 'the quick brown fox jumped over the lazy dog' ,
        @start INT = 5 ,
        @len INT = 3;

SELECT STUFF(@s, @start, @len, 'xx')


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: STUFF().

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


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

I have a full, stable columnstore index on my SalesTotals table. I add a single new row to the table. What happens with the columnstore index?

Answer: The columnstore index remains the same and the row is added in B-tree structure to the deltastore


When you add data to a table with a columnstore index, it is not immediately converted to a column oriented format. Instead, a deltastore will put the data in a b-tree structure and use this to query the data along with the columnstore index data. Once there has been enough data added, SQL Server will automatically convert the data in the b-tree structure to a column oriented format.

Ref: Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes - http://www.sqlservercentral.com/articles/Stairway+Series/133133/

Columnstore Indexes - 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 2017 : SQL Server 2017 - Development

SSIS Buffer Error - Hi, I am trying to execute a package and I am getting the following error messages: Error: A buffer failed while allocating...

Help with a simple TSQL script to open and save an Excel file. - I have an SSRS report that exports to a specific folder on a scheduled basis.  There's a problem with the...

Proxy account not working in stored procedure - I have a stored procedure that uses xp_cmdshell to copy a file from one folder to another (right now just...

SQL Server 2016 : SQL Server 2016 - Administration

SELECT query is blocking UPDATE query in SQL Server 2016 - Hi, I'm running a data warehouse load and a select statement from table DBO"."DIM_BILL_INV_ITEM" is blocking the UPDATE query forever on the...

Restoring backup to AlwaysOn Availability Group primary server. - I'm a bit of a novice when it comes to AlwaysOn, so I was hoping some of you that have...

sql server cluster and ag node - Looking at building solution for our 2016 claims dept.  Was considering one of two options below (all of this on...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Most efficient way of not selecting data - CREATE

Updating Rows - I have three tables with user data in them. The formatting might be off but hopefully below should give you...

SQL Server 2014 : Administration - SQL Server 2014

Log Shipping Secondary Didn't Work When Using the No, the database has already been initalized option - I am experimenting with log shipping in sql server 2014, and am log shipping to 2 secondaries. I synchronized all...

error during backup veem - Hello everyone I have a pb to snapshot the VM that contains two instances sql server I have an error during the...

SQL Server 2014 : Development - SQL Server 2014

How can I insert in a single table from different SQL Servers - I am trying to create MSX ans TSX relationship  MSX is SQL1 TSX is SQL2  and SQL3 created a job in SQL1 that will...

SQL Server 2012 : SQL 2012 - General

How to set/change permissions on server side trace files? - I created a couple of "light weight" server side traces but the files seem created with very unfriendly permissions. In order...

Shrinking mdf file in SQL Server 2012 AlwaysOn cluster database - Hi, I am cleaning  one of our production databases by getting rid of the old temporary tables that creates a lot...

Users are experiencing slow connections trying to log into the application - Dear Everyone I have a custom build application running on .Net and its trying to access the company's SQL Server...

Deleting AG. Some questions - Good Morning Experts, If i delete the Availability Group(AG) in primary replica, what will be the status of databases in primary...

SQL Server 2012 : SQL Server 2012 - T-SQL

Upper Case Lower Case - Hello, I have a field that contains all capital letters.  For example, "SQL SERVER CENTRAL".  Is there a way I can...

SQL Server 2008 : T-SQL (SS2K8)

Number of Days between two Day Names - I have a table with a Start Day and a End Day Column ID StartDay EndDay 1 Monday Friday 2 Tuesday Wednesday 3 Friday...

SQL Server 2008 : SQL Server Newbies

Log backup chain - Good Morning Experts, We have backup jobs scheduled(full, differential and tlog) using Idera SQLSafe and they are running as per their...

Log file R drive- What is consuming it - Good Morning Experts. We have a SQL Server instance. All the user databases log files are on R drive. We have...

SQL Server 2005 : T-SQL (SS2K5)

Backup remote database with TSQL - Hi, I want to backup a database on a remote sql server (Server B) with a TSQL script. I've already added a linked...

This email has been sent to {user_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.
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