SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

What do you do to relax after work?

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

I would guess most of us have demanding jobs, which can be stressful at least some of the time. Perhaps for some of you, the strain of job stress rarely leaves you. I have been in situations like that, I am thankful my current position has much less stress then my previous one. Still, even if you aren’t under much stress it is still nice to relax after work.

So what do you find relaxing? I imagine a number of you enjoy going to the local watering hole to enjoy a beverage with some friends. Perhaps some of you find exercising relaxing. Personally, I don’t. Exercising causes me to feel tired, which perhaps helps me sleep better, but I don’t find the time during or after exercising particularly relaxing.

Others, might enjoy streaming a movie or watching a show on TV, or playing a video game. I confess I have spent way too much time playing Agar.io much to the irritation of my wife. I am sure many of you enjoy social media like Facebook etc. It is interesting as I consider these different avenues to “relax” it seems that they are sort of fun and they certainly take up time, but do I truly feel more relaxed afterwards?

This caused me to ponder what is something that really helps me feel more relaxed? I realized for me, I really enjoy reading. When I have a good book or the latest issue of popular mechanic, after 20 or 30 minutes reading I feel quite refreshed. Now I realize you may not enjoy reading, or reading just doesn’t relax you. I guess my challenge to you is to spend some time considering what you are doing during your off hours and decide if those activities are actually refreshing you and causing you to relax.

Perhaps that stressful show is not the best thing to watch when you are trying to unwind after work. Maybe social media is causing more irritation then doing any good. Winning one more round of a game or reaching that next level can be fun, but also stressful, which is the opposite of relaxing.

I would encourage you to spend sometime today or in the near future thinking about how you can better relax in your off hours. Let me know what you come up with. Perhaps your idea of a good way to relax will inspire someone else to do the same.

Ben Kubicek from SQLServerCentral.com

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

ADVERTISEMENT
SQL Clone

NEW SQL Clone - version 1 now available!

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

 

A Single-Parameter Date Range in SQL Server Reporting Services

John F. Tamburo from SQLServerCentral.com

Many reports you will generate in SSRS will need to report within date ranges, and most of those will need a date range parameter. Here's an way to make an easy-to-use date range parameter. More »


 

Working with Windows Containers and Docker: The Basics

Additional Articles from SimpleTalk

When you begin to work with containers, you will notice many similarities between a container and a virtual machine; but, in fact, these are two quite different concepts. Containers are going to change the way that we do Windows-based development work in the coming year, and they already underpin much of the devops work of speeding the delivery process. Nicolas Prigent explains how to use the Windows Containers feature. More »


 

Webinar: how to get started with DevOps

More and more teams are turning to DevOps as way to improve the efficiency and quality of software delivery but it’s not always clear what's the best way to get started. Redgate have invited Steve Thair, CTO of the DevOpsGuys, to share some practical tips on how you can start implementing DevOps in your organization. Register for the free webinar. More »


 

From the SQLServerCentral Blogs - SQL 2016 – Clone Database with Query Store

matthew.mcgiffen 73574 from SQLServerCentral Blogs

This is a quickie post to introduce the new DBCC command CLONEDATABASE. Okay so this isn’t technically a SQL Server 2016... More »


 

From the SQLServerCentral Blogs - Global v Session Trace Flags

Steve Jones from SQLServerCentral Blogs

I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss... More »

Question of the Day

Today's Question (by Steve Jones):

Why are spatial methods faster in SQL Server 2016 than previous versions?

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: Spatial Data.

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

Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud

With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. In this ebook, we introduce new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TemDB configuration, query store, and Stretch Database Get your copy from Amazon today.

e

Yesterday's Question of the Day

Yesterday's Question (by Igor Micev):

What is true about stored procedure parameters? (choose 2)

Answer:

  • Parameters can be input only
  • Parameters can be input and output in the same procedure

Explanation:

Output-only parameters do not exist in the T-SQL procedures. They are all either input-only or input/output.

The OUTPUT keyword in the procedure’s definition or its invocation, designates the input/output type of a parameter.

Reference:

click here

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 2016 : SQL Server 2016 - Administration

Statistics with NORECOMPUTE - Evening All, When would one typically specify NORECOMPUTE  on Statistics? Presumably when the data is changing dramatically in a way could skew...

2016 Cluster Questions For Always On but also with other services - I'm trying to build up my clustering skills in my Lab, which is an all virtualbox environment. I wanted to create...

Database Architecture Question - Hi, I know there's always 100 different ways to skin a cat, so I thought I'd see what you recommend... My organization...


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

SSIS Project Deployment - Hi there, We are about to deploy a third party SSIS DWH project which contains over 100 packages on SQL Server...


SQL Server 2014 : Administration - SQL Server 2014

Starting with Full Text Search: Suggested links ... - Hi, I am starting with Full Text Search. Am reading a chapter on that in a book by well known authors,...


SQL Server 2014 : Development - SQL Server 2014

Deadlocks When Expiring SSRS Dataset Cache - We are currently on SQL Server 2014, V12.0.5203.0. We use SSRS as our core reporting tool. Most of our report...


SQL Server 2012 : SQL 2012 - General

SSIS Failure Workflow not getting triggered upon OLAP processing task failure - Hi, I have a SSIS package which contains a For Loop container that will execute at max 100 times. Within this container...


SQL Server 2012 : SQL Server 2012 - T-SQL

How to join these tables together - How to join Employee and Student tables with HR table, - using ID and date columns to join with effective dates...

fill factor with clustered PK on identity PLUS another column - Most of our tables have a clustered PK on an integer identity column.   These have a fill factor of 100...


SQL Server 2008 : SQL Server 2008 - General

sql query - From the tables given below i need to know the values of  'ThPr_name'  from TheoryPractical table and  'ETPA_name' from EndtermProgressive...

Cancelled Full Backup -- What of Differential Backup Now? - Morning All, I had to cancel a full backup that was underway as it was started in error. As a result the...


SQL Server 2008 : T-SQL (SS2K8)

'Spell check' a string-valued field - Hello all, We have a field in a table that's a string-valued field. In this field are (mainly) what I'll call...


SQL Server 2008 : SQL Server Newbies

Instance is under memory pressure. How to relieve from pressure - Instance is under memory pressure. How to relieve it from pressure

DBCC is running from 5 days - We have a huge database in TB size.We have a  job that reorganizes/rebuilds indexes on all dbs and then does...

Convert DATETIME, trim leading zeros - Hello All, How can I alter this convert statement to return 1/25/2012 rather than 01/25/2012. Or return 1/1/2012 rather than 01/01/2012 SELECT CONVERT(varchar(10),getdate(),101) Thanks...


SQL Server 2008 : SQL Server 2008 Administration

Page File location and Size - I found out there is a huge (33GB) pagefile on the database data drive on one SQL Server box. The page...


Reporting Services : Reporting Services

Dynamic report header based on condition - I have a requirement to show the company name in the report header based on the login user id. User...


Data Warehousing : Integration Services

Instances of 2008R2 and up to 2016 - I have a database on isntances of 2008R2 and upwards. I would like to produce some SISS packages that would hopefully...


Data Warehousing : Strategies and Ideas

How to load and in what order warehouse tables - Hi, I am somewhat new to were housing but not new to SQL. I  have been looking all over the net and...


SQL Server 2005 : Administering

SQL Server DBA Certification - Hi All: I want to become a certified DBA, i'm not sure what path is the right one. I have exprience...

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]