| A community of more than 1,600,000 database professionals and growing |
| | Holiday parties: Do you love them or hate them? Today we have a guest editorial as Steve is out of the office. It is getting to be that time of year when many places of work have some sort of get together. I remember at one time, long ago, they were labeled Christmas parties. Now, I think they have to be labeled Holiday parties so no one is offended. Sometimes people are too easily offended. I have stated in a previous article that I believe a majority of database professionals and developers are introverts. That often means they don’t attend company parties. At the company that I work for, last year’s company party had five developer / dba / database type people that attended (including me). There are over fifteen people in my department that are in that group. Sure some of those people didn’t come because of scheduling conflicts, but I am pretty sure a bunch of them just don’t like company parties. In fact, some of them told me outright that there was no way they would go to the company party. So, why should someone go to a company holiday party? I can think of a few reasons. First, they can be fun. There is often good food and drink to enjoy. If you have a spouse / significant other, this party might be the nicest place you have taken them in a while. You get to know your co-workers a bit better. Getting to know your co-workers better often leads to better communication and interactions at work. Some companies have giveaways and free prizes at their year end parties. So why don’t people go? Starting or having conversations is hard and can be awkward. Maybe you don’t have a spouse or significant other to go with you. Perhaps, you really don’t like your co-workers and can’t imagine spending more time with them would be fun. Some people, just feel awkward in social settings. Well, let me let you in on a little secret. I am not sure that anyone is totally comfortable at a company party. Everyone is pretty much in the same boat. Most people aren’t great at starting or holding a conversation, so go prepared. Think about potential questions you could ask people. Things like, do you have kids (assuming they have a spouse)? Be ready to answer your own questions even if they don’t ask you the same question back. It is surprising how often you can ask someone a question and they don’t even have the presence of mind to ask you the same question back. You can talk about how the local sports team is doing. You can ask what their hobbies are and share with them some of your hobbies. Before you know it you might be enjoying yourself. Have a plan. Don’t end up just sitting/standing by yourself, or following around the one person you have a decent relationship with. Push yourself to talk with new people. Be interested in other people and what they have to say. The only other advice I have is don’t drink too much. A little bit to drink can make you feel more comfortable, but you don’t want to be the person that got wasted and made a complete fool out of themselves. Does your company have a holiday party? Why or why not are you going to attend? Ben Kubicek from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | 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 |
| | 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 |
|
|
|
| | | David Poole from SQLServerCentral.com Vagrant provides a mechanism to build and configure a virtual Linux box running SQL Server 2017 More » |
| Additional Articles from Brent Ozar Unlimited Blog Brent Ozar shares a free script that that you can run to quickly produce a health check of your SQL Server. More » |
| Devin Knight from SQLServerCentral Blogs In this module you will learn how to use the Enlighten Stack Shuffle Custom Visual. The Enlighten Stack Shuffle is... More » |
| lokesh sharma from SQLServerCentral Blogs Sometimes the mistakes you make in the coding lead you to a better understanding of a particular concept. This happened recently... More » |
|
|
| | Today's Question (by Steve Jones): What's the datename return value? My instance default language is US English DECLARE @RunDate DATE = '10/02/17' SET LANGUAGE British SELECT DATENAME(dd, @RunDate) |
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. 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 | SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): What happens when I execute this code? CREATE TABLE CompressionTest ( mychar CHAR(8000) , morechar CHAR(49) ) GO ALTER TABLE [dbo].[CompressionTest] REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE ) Answer: The table is created, but it is not compressed. Explanation: In this case, the table is created, but it is not compressed. This isn't a partition error, rather, this is a problem with row size. Compression takes 10 bytes of internal overhead here, which means the resulting row size would be 8061, which is too large. The maximum row size is 8060. The error returned is: Msg 1701, Level 16, State 1, Line 15 Creating or altering table 'CompressionTest' failed because the minimum row size would be 8061, including 10 bytes of internal overhead. This exceeds the maximum allowable table row size of 8060 bytes. Ref: Data Compression - click here » Discuss this question and answer on the forums |
|
|
| | Harikumar Mindi from SQLServerCentral.com This script helps in monitoring logshipping status of secondary databases and how far behind they are their respective primaries. You can have this run as a scheduled job to monitor the "Minutes_Behind_Primary" parameter. 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. 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... How OVER clause works ? - Hi All, Today, I came across tsql code which is been used in our environment (Sql 2014). Its an enhancements... Using Extended Events to alert on long running queries - Hi Is there a way with Extended Events, where I can set up something; should a user/developer run a query via... Date format check - Hello all, I have few records in a table. And I want to check if one of the string column starts... Modifying my parameterized query to select * an entire column - This working code lets the user use a click event in Excel/VBA to separately insert values into the same field... CASE statement and inner join giving duplicates - Dear DBAs I am using a CTE to get terminal locations from one table and then joining this CTE with... Move user database - Why is detach/attach not recommended for moving a user database? Merge Replication Error - Hi All, Running : SQL 2008 Standard I could really do with some help on this problem. I accidentally changed a data type... Query - Hi I have query which returns Location , Vendor , Amount. Query is grouped by Location & Vendor Suppose 3 records are returned... Query - Hi I have 1 Table with field Document Type . I want those records of Customer whose Sum(Amount) of Document Type... Fill Factor - Dear Experts, Regarding the Fill Factor on indexes, Does SQL apply the Fill Factor value of an index to the... Sorting of Alphanumeric data - Dear Experts, Can anybody help understand how SQL server does sorting of the alphanumeric data in a character column types while referencing... Clearing/deleting/resetting asynchronous file target - Extended events - Does anyone have any suggestions on how to clear/delete/reset the asynchronous file target files for extended events? Rounding to the nearest 15 seconds - Hi I've imported perfmon data from 100 SQL servers into a central database to analyse the results. The time field has imported... S?QL Server using 97% of RAM. - Good Morning Experts, SQL Server is using 97% of RAM. Could you please advise what needs to be done. what is causing tempdb to become full - Good Morning Experts Application team is doing something that is causing tempdb to become full. We shrank tempdb log file. Again... Date Search - Hi, I have in a data row: column 2017-11-06 01:17:34.000 I only want to search for values if the year is... CPU spike when executing a query in SQL - Hi, Our production environment recently have been witnessing spike in CPU utilization of more than 90% when executing some queries in... Difference in value - I have a simple audit table: PersonID Date Value 01 1/1/17 Faulkner 01 1/2/17 Hemingway Which shows me where a person's surname has changed and the date... ws_ftp pro & SSIS execute process task - We are facing few issues running the batch command to initiate the ws_ftp process .I am using execute process task... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. | 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: [email protected] |
|
|