SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Don’t Underestimate the Importance of Good Co-workers

I think most of us would agree that we want good co-workers over bad ones. I am not just speaking about people who do good work, but people who are enjoyable to work with as well. There are unfortunately a lot of people who do good or even excellent work, but are terrible to work with.

If you think about it, you probably spend more awake time with your co-workers then your own family. I have found that when you have good people to work with, it can make the actual work you are doing more bearable or even enjoyable. Let's be honest, who truly loves all the stuff they have to do at work each day. There are usually some annoying things you are responsible for as well as (hopefully) more fun projects. You might have an old server or old version of SQL Server to maintain, or a legacy system you still have to support. I have found, when I have good co-workers some of the aspects of my job that I don't enjoy very much, just doesn't bother me as much because I enjoy my co-workers.

Clearly, if you currently don't have good co-workers there isn't a lot you can do about it. I suppose if you get to interview new candidates you can try to gage if they are someone who does good work and someone who you would enjoy working with. If you are the one seeking a new position, co-workers are something you should keep in mind. Hopefully, you get to meet some people during the interview, that will become your new co-workers. Perhaps even a few of them will be the ones interviewing you. Once you know you are interested in the position and they are interested in you, it is a good idea to try and discover who you will be working with. Make sure you remember that as much as you might like a position (work you will be doing) if you don't like the people you will be working with, it may end up being a miserable situation.

Recently two of my co-workers that I work with regularly were gone for two weeks. They were travelling to different remote sites. I realized I missed talking with them and bouncing ideas off them. I find that I enjoy my work a lot more when these co-workers are around to work with.

My previous job was a very small shop. I only had a few co-workers and none of them did the same work I did. There was no one to bounce ideas off or to collaborate with. Towards the end of my time at that position I was really quite miserable and part of the reason for that was the lack of good co-workers.

I hope you have some good people to work with at your job. If you do, perhaps you should take them out to lunch. If you don't, maybe it is time to move on to a new position with hopefully better people to work with. Share a story of a good, or terrible co-worker that you have experienced.

Ben Kubicek from SQLServerCentral.com

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

Redgate Hub

Stop your database being a bottleneck

The new Redgate Hub is the shortcut to the latest insights into database development. Constantly updated with invaluable content, it’s the one resource you need to solve problems, share ideas, discover new tool features, and expand your database skills. Discover the Redgate Hub

SQL Clone

SQL Clone: Now supporting databases up to 64TB

Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free

Featured Contents


Introduction to Statistics

Johnny Bieber from SQLServerCentral.com

This article will give a brief overview of how statistics are generated, stored, and used in SQL Server. More »


A Freecon Halloween at the PASS Summit

Press Release from SQLServerCentral.com

If you're attending the PASS Summit in 2017, there's a Freecon day on Tuesday you can attend. More »


A Freecon Halloween at the PASS Summit

Press Release from SQLServerCentral.com

If you're attending the PASS Summit in 2017, there's a Freecon day on Tuesday you can attend. More »


Key Lookups and ColumnStore Indexes

Additional Articles from Brent Ozar Unlimited Blog

Erik figures out why SQL Server really doesn't like combining these two things in a query plan. More »


From the SQLServerCentral Blogs - Power BI Custom Visuals Class (Module 72 – HTML Viewer)

Devin Knight from SQLServerCentral Blogs

In this module you will learn how to use the HTML Viewer.  The HTML Viewer allows you to display the... More »


From the SQLServerCentral Blogs - Small identity columns

Kenneth Fisher from SQLServerCentral Blogs

We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small... More »

Question of the Day

Today's Question (by Steve Jones):

What types of fixes does a GDR release include? Assume this is for a particular branch of code, such as the RTM release.

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: Patches.

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

What is a datetimeoffset?

Answer: The date and time value with an offset value from UTC time


The datetimeoffset value stores a datetime value with an offset from UTC time. For example, Denver is typically 7 hours from UTC. Noon Denver is represented on Jan 1, 2017 as

2017-01-01 12:00 -7:00

Ref: Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

Datetimeoffset - 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

Delete syntax not working - hi, Here is the delete syntax but it is not working even though all the conditions satisfy. What is the issue? DELETE...

SQL Server 2016 : SQL Server 2016 - Administration

Get the SSIS Package names from database - Dear all, Can you please let me know how can I get the names of all the SSIS packages that I...

The cluster IP address is already in use error while installing SQL 2016 Failover Cluster - We have 2 nodes, both were running SQL 2014 cluster. We had to upgrade the windows OS to 2016, the...

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

Very challenging TSQL Query - Hi Experts, I have a table (test) with the following data :

T-SQL Help on same table join - Hi  SQL View   SELECT  a.Name , Q0.Value, Q.1.Value,Q2.Value FROM A with (nolock)  Left Outer join B AS Q0 ON Q0.FK_ID = A.ID   AND Q0.Type...

SQL Server 2014 : Administration - SQL Server 2014

Integration Services Catalogue (SSISDB) - Cannot return free space to operating system. - We have the SSISDB database which stores log information of jobs that are run. It was initially set to retain...

SQL Server 2014 : Development - SQL Server 2014

Why is my T-SQL code so slow with its output? - Select Invoice_Exceptions.Invoice_Number as Invoice#, FORMAT(Invoice_Exceptions.DateTime, 'MM-dd-yyyy') as Void_Date, Invoice_Exceptions.ItemNum as Item_#_Removed, Inventory.ItemName, '$'+CONVERT(varchar(10), CAST(Invoice_Exceptions.Amount as money)) as Amount, CONVERT(varchar(10),...

could some one help me with the query below - ExecuteSql"(varchar(max),"USE MASTER declare     @isql varchar(2000),     @dbname varchar(64),     @logfile varchar(128)     declare c1 cursor for     SELECT d.name, mf.name as logfile--, physical_name AS current_file_location, size     FROM sys.maste

TRUNCATE and INSERT INTO slower than TRUNCATE GO INSERT INTO - Hi guys, i wonder why executing  a TRUNCATE and INSERT INTO Command is mutch slower than  executing these commands separately ? Conditions: recovery...

SQL Server 2012 : SQL 2012 - General

Using a case statement to determine join - I have a query that uses several left outer joins. I am attempting to alter the join to include a...

SQL server service account is locking out - Hi, we are seeing one of our service account getting locked out for every fifteen minutes, we have two domains(ex. A and...

SQL Server 2012 : SQL Server 2012 - T-SQL

Local Variable table Update values not coming correct while passing two Name in the query - Hi Experts  I am trying to use local variable table  , the code works fine , if   the  NAME IN ( 'NAME1')  is only...

Query Help - I have been look at this all day and need some other eyes, when I run the query below I...

Help with Trigger - I need to create a Trigger that creates a new quote no everytime a new opportunity is created. The quote no...

Reporting Services : Reporting Services 2005 Administration

Unable to access Reporting services reports from application - We have configured the reporting services to view the application reports. Report server is hosted in one system and application...

Data Warehousing : Integration Services

Incremental load solution to track the changes - Loading the data 70 Million records from IBM DB2 to SQL Server Problem – 1.       Need to have incremental data solution 2.      ...

Script Task to check file existance is OK in Visual Studio but fails when Deployed - Hi, Within a Foreach loop, I have a simple Script Task to check if a file exists. If it exists, then FTP...

SQLServerCentral.com : Articles Requested

Writing Test Cases for T-SQL Code - I'd love some articles that look at a piece of code you've written (query/batch/proc) and then what test cases or...

SQL Server 2005 : T-SQL (SS2K5)

Identify the Column for 'String or binary data would be truncated' - Hi, Has anyone got a way to identify which column is to blame when encountering error 'String or binary data would...

SQL Server 7,2000 : In The Enterprise

Project Plan - I'm looking for a decent Project Plan (in any format) for moving from SQL Server 2000 to a SQL Server...

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