SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Introverted vs Extroverted

I have a theory that a majority of database professionals and developers are introverts. When you look up the definition of an introvert, it isn’t particularly helpful. Still, I think it is important in your workplace to realize if you are introverted or extroverted. I have two questions you can ask yourself to help you decide which one you might be.

The first question is: Do people wear you out? I am not talking just about larger crowds, but just people in general. If you feel exhausted or drained after spending time with people, there is a good chance you are an introvert. The opposite is true for extroverts. They get charged up and energized by people.

The second question is: Do people have to ask you specific questions to get you to talk about things? You may have an opinion on something, but you won’t share it unless someone asks you what your opinion might be. An extrovert might be more likely to share their opinion, even if no one asked for it. An introvert may have trouble talking about themselves, where an extrovert talks freely about everything going on in their lives. Of course, this is a generalization, which means it isn’t always true, there will always be exceptions.

So why does this matter? Well first, for all you introverts out there (I am one too), you can still choose to be more extroverted. There is probably nothing you can do about being drained by people, but you can communicate your opinions, when appropriate, even if no one asked. Communication is important and keeping things to yourself really doesn’t help anybody. I suppose if the thoughts you are keeping to yourself are negative ones about why this or that idea won’t work, perhaps you should keep that to yourself. I am talking about positive communication, solutions to issues, ideas that might help. Or potential pit falls being raised in a way to make people aware, but not trying to condemn the project to failure.

For all you extroverts out there, recognize which co-workers are more introverted and don’t dominate your conversations with them. Ask more specific questions realizing that some people need to be asked before they will share what they think. Extroverts might keep in mind; they should sometimes take a moment to think before they speak.

I think it is important for both introverts and extroverts to exists in a workplace. I fear that when introverts are in the majority, communication suffers. I think by understanding your own personality and that of your co-workers you can better communicate and elicit better communication from those around you. Share whether you are an introvert or an extrovert and why you believe that?

Ben Kubicek from SQLServerCentral.com

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

SQL Monitor

Don’t just fix SQL Server problems, prevent them from happening

SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial

Redgate Hub

Register now for SQL in the City Streamed

Redgate’s popular SQL in the City Streamed virtual event takes place again this December. Wherever you are, tune in on Wednesday December 13 to watch some of the best-known speakers from the database world present the latest technologies and tools from Redgate. Register free now

Featured Contents


Change Integer to BigInt on a Very Large Table

Nisarg Upadhyay from SQLServerCentral.com

This article will show how to change the data type of a column when the table contains more than 1 billion records. More »


Can the database be included in DevOps in financial services?

For many DBAs who work in financial services, deploying database changes is the most taxing part of the job. Being required to review thousands of lines of script can take days, depending on how many errors you find. Even when database deployments are better planned, it’s not an easy journey, and DBAs are often regarded as the blocker in the process, the ones who are causing the problem rather than trying to resolve it More »


How to Do a SQL Server Architecture Review

Additional Articles from Brent Ozar Unlimited Blog

How do you get management to help you figure out if a cluster or an AG is right for you? In this post, Brent Ozar explains the steps involved when doing a review of your SQL Server architecture. More »


From the SQLServerCentral Blogs - Drop That Schema

Jason Brimhall from SQLServerCentral Blogs

An often under utilized or maybe even mis-utilized feature of SQL Server is a database object schema. In the event of... More »


From the SQLServerCentral Blogs - Information Measurement with SQL Server, Part 2.3: Thermodynamic and Quantum Entropies

SQLServerSteve from SQLServerCentral Blogs

By Steve Bolton …………When I was about 12 years old, I suddenly discovered football. Many lessons still awaited far in the... More »

Question of the Day

Today's Question (by Steve Jones):

Can I create this table in SQL Server 2016? 

( mychar CHAR(8000)
, morechar CHAR(54)

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: table design.

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


Expert T-SQL Window Functions in SQL Server

Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I ran this in R Studio:

> library(randomForest)

This was the result:

Error in library(randomForest) :

there is no package called ‘randomForest’

What should I do to remove this error?

Answer: install.packages("randomForest")


If the package isn't available, you need to run the install.packages() function with the name of the package. This will download and install the package from your CRAN mirror.

Ref: install.package - 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 - Administration

Reporting service Edition for 2017 - I understand reporting service is a separate download for SQL 2017. I go to the download site there is only...

SQL Server 2017 : SQL Server 2017 - Development

need help - hello all, I have 3 tables. employee , division and empDivMap. The employee table is the master table of employee data. The...

SQL Server 2016 : SQL Server 2016 - Administration

AlwaysOn Diagram - Evening All, I am wanting to create diagrams similar to the following: https://smartbridge.com/wp-content/uploads/sbblog_sqlserverdatabases1.gif What would the best software to recreate that be? Cheers Alex

Planning for a server - Hi, this is a very general question, and I need a baseline idea of where to go. Getting into too...

Backups and AlwaysOn Availability Groups - Hi, I'm sure this is an easy answer for many of you but, when setting up AlwaysOn Availability Groups for the...

t-SQL Solution to backup and restore - Dear all, I was requested by my company to create a solution that is able to backup a database from PROD...

ApexSQL Monitor - Good afternoon, Has anyone ever used or have an opinion on the ApexSQL Monitor tool? I am currently evaluating the product...

Migrate SQL Server to new server - Hello All, I would like to upgrade my SQL Server 2012 to SQL Server 2016. I created new machine and i would...

SQL Server 2014 : Administration - SQL Server 2014

Deny delete for some users - Hi, I have an application that there are mystery deletes occurring (long story). My users would like if there was a...

Database Corruption - Hi All,  I hope that I could had some Help concern to a issue that currently I am facing. So I have...

SQL Server 2014 : Development - SQL Server 2014

load data into 3 separate tables using tsql . - Hi All, I have below table. Basically, I dumped testddata as is to a table. now i want the data...

Dynamic Pivot/Unpivot - Hello,  I have a table like below, where headers of columns and rows are dynamic (this is a result of query)

Understanding of Unique Index - I appreciate it might be a trifling question for most of you, but... I have a primary key on columns A,...

Table Structure of Monthly Data - I'm curious what everyone thinks is the best way to store data where the history of aggregated data for an...

SQL Server 2008 : SQL Server 2008 - General

Changing NVARCHAR to VARCHAR... - Dear Experts, As part of tuning on a database , I want to reduce the high physical reads by reducing the number...

SQL Server 2008 : T-SQL (SS2K8)

Join two tables with complex derived keys that don't match - Guys, I need to join two tables together - Master and Detail Master Table: ID =7000776601*1*6994 Code=P*W*S Instances=6994ý12510ý12874ý13245ý13609ý13973ý14337ý14701ý15009ý15072ý15436ý15800ý16164ý16528ý16899 Details Table

SQL Server 2008 : SQL Server Newbies

Dynamic variables in SQL server for HTML - I am trying to recreate and automated email. The email has gone from having, one column with headers and one...

Reporting Services : Reporting Services 2008/R2 Administration

Reporting Services will not start with a .NET 2.0 Runtime Error - .NET Runtime version 2.0.50727.8762 - Fatal Execution Engine Error (000007FEF983104E) (80131506) Receiving this error as of this morning after Networking did some...

SQL Server 2005 : Business Intelligence

SSIS: Insufficient disk space - Hi All, I am getting below error while executing SSIS package through job: There may be error messages posted before this with...

SQL Server 2005 : Data Corruption

Data row does not have a matching index row in the index - Hello, I have this problem. At monday found this, so drop and recreate index, then execute dbcc check and without problem. Today...

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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com