SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Change and the ability to adapt

Today we have a guest editorial as Steve is on vacation.

I live in Saint Paul, Minnesota. The state of Minnesota is in the mid-west on the northern border of U.S. and Canada. It is a beautiful place to live, but there is a lot of changes from season to season. The summers are hot and humid, but there are a lot of trees with lush green leaves. Fall (autumn) is a beautiful time of year, with the blazing yellow and orange leaves. Winter is nice with a white blanket of snow, but it is a stark difference with no leaves on the trees. In the spring, it is amazing to see all the green grow back, as everything comes back to life.

The temperatures vary wildly as well. In the summer the temp can get over 100F (38C). In the winter the temps can get down to -15F (-26C) and with the wind chill it feels even colder. Change is a constant here and we constantly need to adapt to it. How do we adapt? Well, we wear more clothes in the winter than in the summer. We spend more time outside when it is nice and sometimes not as much when it is cold. We do fun things in the winter like ski, snowmobile, hunt, etc.

Change happens in our personal lives as well. We get married, have children. We change jobs. We move, or get divorced. A loved one passes away. Some of these changes are good. Others are bad and they are things we would rather not experience. It is often hard to have a good attitude when we are going through some of these experiences.

Change often happens in our workplace as well. We can move our desk or office. We can change departments. Co-workers come and go. We can get new team leads or new manager. New technology comes out. A new version of SQL Server gets released. Some of these changes cause more work to fall on our plate. That can be a good or a bad thing.

Sometimes we have a hard time with change. We miss old co-workers that have left. We don’t appreciate getting more work dumped on us. We don’t get along as well with a new manager. We don’t understand why we need to learn new technology when the old works just fine. Change isn’t always good, but it does always seem to happen.

I think it is important to realize that in life change is going to come. I think we need to just embrace the truth that: change happens, whether we want it to or not. We cannot control the change we experience, but we can manage our attitudes. The ability to adapt our attitude can be paramount when we experience change. We should recognize when we are in a good situation and have a thankful attitude for it. In the same way when our situation isn’t the best we can still be hopeful, knowing that the change we that we desire, may not be that far away. Share some changes in your life / work place and how you adapted to them.

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

SQL Compare

The industry standard for comparing and deploying SQL Server database schemas

Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial

Featured Contents


Adaptive Query Processing – Batch Mode Memory Grant Feedback

Wayne Sheffield from SQLServerCentral.com

Explore Batch Mode Memory Grant Feedback that was introduced in SQL Server 2017 More »


Has Your Database Been Backed up in the Last 24 Hours?

As a DBA your #1 responsibility is to make sure that each of your SQL Server databases are backed up. This tip provides a couple of TSQL scripts that will identify the last backup of each database. More »


Free webinar: Change your SQL Server troubleshooting from reactive to proactive with a monitoring tool

Redgate’s James King and Ben Emmett will demonstrate how to troubleshoot your SQL Server estate, and discuss how it shouldn’t be about reacting to problems when they occur, but rather having the tools to make proactive decisions to plan ahead, identify potential disruptions, fix common problems and make improvements. More »


From the SQLServerCentral Blogs - Server Audit Mystery: Filtering class_type gets Error Msg 25713

Solomon Rutzky from SQLServerCentral Blogs

The other day I ran into an odd problem trying to answer the following question on DBA.StackExchange: How to filter out... More »


From the SQLServerCentral Blogs - Configuring Persistent Storage for SQL Server in Azure Container Services

Andrew Pruski from SQLServerCentral Blogs

I’ve been playing around with SQL Server running in Kubernetes in Azure Container Services (AKS) for a while now and... More »

Question of the Day

Today's Question (by Steve Jones):

I've got a developer that is working on a query that contains a view. The developer tries to get the actual execution plan for the query, but receives a permission error. What permission needs to be granted to the JoeDev user in the development database for the ActiveCustomer view to allow him to view the execution plan?

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

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

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I have these two sets of data in R:

> First.Names <- c("Steve", "Andy", "Brian")
> Last.Names <- c("Jones", "Warren", "Knight") 

I want to combine them so that I have a single vector with 1 row and three elements. Which code do I run?

Answer: paste(first.names, last.names)


The PASTE() function is used. This will combine the elements from each vector into a single vector. The results will be:

> paste(First.Names, Last.Names)
[1] "Steve Jones"  "Andy Warren"  "Brian Knight" 

Ref: paste() - 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

Self Join Question - I've got a table with the following fields in it: UniqueID Sequence BeforeStatus AfterStatus HistoryStatusDate Sample data looks like : 08-40089445, 1, '','BNT',10/17/17 08-40089445, 2, 'BNT','VFD',1/18/18

Calendar table - I have been trying to find out the best way to design a Normalized table for

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

how to do Intermediate calculations for partial rows based on a particular field - I have a data table which has RowNo, EntityName, Value, KeyYear. RowNo is Unique.  EntityName and KeyYear combination is unique...

Remove duplicate record based on criteria - Hi All, EDIT: I was convinced I was connecting to a 2016 instance but just now found out it's in-fact a 2008...

Result truncation bug - Here's an interesting riddle.  I'm building a code generator, so the SELECT clause is just one great big concatenation of...

SQL Server 2014 : Administration - SQL Server 2014

Does denormalizing the data enhance performance? - We have a sales tracker report which uses a view and that view was created from 15+ tables. I have...

Background blocking process - I have sql server 2014 has a system process that is blocking another systems process every 15 mins and then...

SQL Probe Bitmap 1008 high CPU - We have a very simple query and appropriate index has been created on both tables. But both tables are doing...

SQL Server 2014 : Development - SQL Server 2014

Looking to sort two queries by Date, Time - SELECT LTRIM(RIGHT(CONVERT(varchar(6), .,100),7)) AS --, FORMAT(., 'MM-dd-yyyy')       AS , CONVERT(varchar(10),REPLACE(CONVERT(varchar(10), .,101),'/','-')) AS , LTRIM(RIGHT(CONVERT(varchar(20),

SQL Server 2012 : SQL 2012 - General

Replication Issue - Cannot see SUBSCRIBER DATABASE - Hi.   I'm having a replication issue on a simple Transactional Repl setup for 2012 PUBLISHER to 2008 SUBSCRIBER. When I get to...

SQL Server 2008 : SQL Server 2008 - General

Query performs poorly on prod server, works well when run against a restored copy of DB - Hi all,  I have an query that has been set up and running as part of a sql job in prod...

Restrict resource comsumption for user - I have a user who I granted with read only access to our DW and I wanted to know if...

Creating record from multiple records pt 2 - Hi I have the following table which I need to do the following to: 1. Create a single record for each user. 2....

SSMS connect to another server => How to ? - Hello all, before where i worked, it's was possible in sql server management studio to connect to a sql server by...

Data migration from one database to multiple databases - Hello, There are millions of records in one database and expecting to migrate records from two or more tables to other database...

SQL Server 2008 : SQL Server Newbies

INSERT running slow in SQL 2016 - Good Morning Experts, We had a database on SQL Server 2012. INSERTS were running fine. We migrated this database to 2016...

Reporting Services : Reporting Services

Getting SSRS 2016 installed properly (so all the pieces work) - I'm trying to install SSRS on my laptop (Win 10, if it matters), but if I customize at all, things...

Programming : Powershell

email with attachment powershell - This code runs successfully but does not send an email.Any help is appreciated. Add-PSSnapin Microsoft.Exchange.Management.Powershell.Admin -erroraction silentlyContinue function sendmail_withAttachment { Param ( # $smtpServer...

Data Warehousing : Integration Services

New destination column not saving - Hello SSC, I have a simple SSIS package with a Source and Destination. The Source is a SQL Server view, the...

Microsoft Access : Microsoft Access

Migrated DB to 2016, having ODBC Access problem - Thanks in advance for any clues on this problem. I'm migrating several SQL Server databases from SQL2005 to SQL2016. One...

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