SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Does Your Work Attire Really Make a Difference?

Today we have a guest editorial as Steve is out of the office.

I have worked for a number of different companies, and they all had different requirements for what you could/should wear to work. In one position I had early on in my career, I was deep inside the depths of the IT department. The people were pretty casual and most people wore jeans. After a few years at this position I started to wear shorts to work. No one said it was okay, but no one said I couldn’t wear them either. I still wore a nicer (polo) type shirt, I never saw clients, I did good work, and nobody bothered me about it. Later, when I did consulting for a few years I had to dress nicer, but even then, with some longer assignments I eventually wore nicer jeans with a polo shirt.

My very first job required business attire, but they had causal Fridays. It was always a little strange seeing co-workers in “normal” clothes at work. It was kind of like seeing a co-worker outside of the workplace in jeans and a tee-shirt.

I have a co-worker, where one of his first jobs was a tech support position on the phone all day long. They required their tech support people to wear ties because they believed people wearing ties would be more professional on the phone. I am not exactly sure how that worked for the women employed there. If you asked him, he would say wearing a tie didn’t help him be any more professional on the phone, although I don’t think he likes wearing ties much.

I have another friend in consulting that has to dress up, and he feels strongly that it helps create a more professional environment. I guess that does make sense in consulting. How disrespectful would it be for a consultant to show up all disheveled to a meeting with their customer?

My current position is in a corporate office. Everyone is required to wear business attire. So, a nice collared shirt, nicer pants (not jeans), and a number of people wear nicer shoes. When I got this job I had to invest some serious money into my work wardrobe.

So the question is: does it matter? I feel like dressing nicer at work on one hand is a pain. I have to launder my work clothes differently to make sure they stay nice and don’t become a wrinkled mess. On the other hand, I do feel a little more professional at work. It seems strange that what I wear could have a positive effect, but it seems like it does. Would I prefer to just be able to wear shorts to work again? Sure, but I think in my current corporate office environment it just wouldn’t work.

Share what you get to wear at your workplace. Do you think dressing in nicer attire would positively affect your work environment?

Ben Kubicek from SQLServerCentral.com

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

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

SQL Prompt

Write, format, and refactor SQL effortlessly with SQL Prompt

Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with tab coloring you’ll never deploy to the wrong environment again. Download your free trial

Featured Contents


Stairway to AlwaysOn Level 3: Infrastructure 101

Perry Whittle from SQLServerCentral.com

In this next level of the Stairway to AlwaysOn, we will look at the components required to implement a Windows Server Failover Cluster. More »


Free eBook: Defensive Database Programming

Press Release from Redgate

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment. More »


Live Query Plans and Blocking

Additional Articles from Brent Ozar Unlimited Blog

Erik Darling looks at how SQL Server 2016's live query plans react when they're blocked. More »


From the SQLServerCentral Blogs - When is it a good idea to consolidate multiple instances?

Kenneth Fisher from SQLServerCentral Blogs

In this age of cost-saving after cost-saving, one way you may be looking at saving money is by combining multiple... More »

Question of the Day

Today's Question (by Steve Jones):

I want to import a file into my R session. The file is loaded in f:\datasets\NFL. However, when I try to read the file, I get this:

> read.file("2016QB.tsv", sep="\t")

Error: could not find function "read.file"

I need to set the working folder of my session. How can I set this to the correct folder?

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: R Language.

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


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

What is the result of adding these two dates?

    @dt1 datetime,
    @dt2  DATETIME
SET @dt1 = '2017-10-31';
SET @dt2 = '2000-01-01';
SELECT @dt1 + @dt2

Answer: 2117-10-31 00:00:00.000


Happy Halloween!

This might not be what you expect. After all, how can you add two dates? You might think simple arithmetic, some logical year + year, month + month, day + day. Or just days.

SQL Server stores these as integers, so the values are converted to integers, added, and then cast back to datetime. 

Strange values for a strange holiday.

» 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

latest timestamp multiple databases - Hi  dbas can you tell me  a quick way to check timestamp on multiple user databases in a SQL Server Instance. For...

SQL Server 2017 : SQL Server 2017 - Development

Sum case nulls and 1900-01-01 00:00:00.000 - Hi Guys. I have the following as part of my statement and it counts the '1900-01-01 00:00:00.000' fine.  However, it does...

Nearest Date value - Product Location

StartDate and EndDate in same column - I have a date column below RunDate , I want to create two column StartDate and EndDate like this StartDate = '2004-08-01' ...

SQL Server 2016 : SQL Server 2016 - Administration

App timing out, but sproc runs in 3 seconds - System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not...

REporting Services: (Bing-) Map shows HTTP Status 403: Forbidden - Hi! we created a Report with the integrated Bing maps. On our development-Server, inside Visual Studio, the Report works, the map...

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

What happens when delete query executed inside sql server engine , process in deleting file , how data page will be managed , how deleted data pages will be free for next use? - Hi Champs, I want to understand what happens when delete query executed in inside sql server engine , how page  de allocation...

SQL Server 2014 : Development - SQL Server 2014

The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode - Around 2am in the morning, certain jobs fails and report fails at the same time. Report (business objects) connects to...

Send email when a field is 0 - Hi, I query that will be part of a store procedure. the store procedure will be loading a table, after a...

SQL Query (Merge Statement) Help - Hi Guys, I need help. I want to use a MERGE statement. The source and target tables are pretty big...

Join on a Substring - I have a proc that runs nightly that moves data into another table.  The procedure joins on multiple tables one of...

SQL Server 2012 : SQL 2012 - General

Where should I save stored procedures and user defined functions for use in all databases? - I have some generic utility stored procedures and user defined functions that I would like to define/save once, and have...

SQL Server 2012 : SQL Server 2012 - T-SQL

Removing Time from Date when adding to Gridview - I am trying to run a SELECT statement and post the results to a Gridview in C#.  Everything works fine...

How to find the first recurring character of a string. - I have a query that finds the first recurring character in a string. For eg : if @str = 'ABCCDA' then i...

PURGING DATA - HI All, I have an assignment, to Purging data, with conditions: 1. Keep the full data 6 months (keep all the records...

SQL Server 2008 : SQL Server 2008 - General

Rank a large table - Hi there, I am trying to figure out the best way to rank a table that has 600 million rows. This...

SQL versus program - Hi all, I'm posting my question in this 2008 forum because we're running SQLServer 2008R2, but it is more a general...

Cloud Computing : SQL Azure - Administration

How to continue our SQL agent scheduled daily backup in Azure? - Hi, we just migrated our SQL database to Azure. However, I have no idea how to continue our SQL agent scheduled...

Data Warehousing : Integration Services

Need to zip files and load into Source Modified Date , Date folder. - Hi, I have to zip files regularly and load them into destination, the destination folder should be in format YYYY_MM. How...

Data Warehousing : Analysis Services

Design considerations for a tabular model - I have a star schema already in existence (SQL Server fact table and numerous dimension tables). For a given tabular...

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