SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

Featured Script

The Voice of the DBA

Valentines Day for Data Professionals

It's Valentine's Day today, and if you've forgotten, you still have time to do a little shopping or show your partner that you value them. While this isn't a public holiday in any country that I know of, many people do want to celebrate with someone special to them. In fact, if you forget about this day, chances are the next few might not be so pleasant.

For many of us, we'll spend nearly as much time at work each week as we might spend with our families. Between a few extra hours here and there at work, commuting, and sleep, it may often feel like we spend more time at work. Hopefully that's not the case, and if it is, you should re-evaluate your current position.

Most of us do have a relationship with our career. We've chosen it for some reason and are often locked into doing certain work in the short term. With today being a relationship holiday, I wanted to ask you to think about if you really love your career?

I'm not speaking about your current job and employer. You might enjoy being a developer, DBA, or other data professional while not being enamored with the position and place you work now. I'm asking for the long term, are you happy with your career choice and looking to continue moving on this path.

If you are, good for you, and I hope you find a great position that suits your life. If not, it doesn't matter what you've done in the past. You can start moving forward in another direction today.

I love my job, and I've enjoyed the last 25 years of working with SQL Server. I don't know if I want to do another 25, but I certainly am still in love with my choice today.

Steve Jones from SQLServerCentral.com

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

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 2.5MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

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 Prompt

Become a more efficient SQL developer with SQL Prompt

Learn how to write SQL faster and more efficiently with these exclusive short videos from Data Platform MVPs and SQL Server experts. With SQL Prompt you can strip out the repetition of coding and write SQL 50% faster. Check out the tips

Featured Contents


Calculating DTU's for Azure SQL Database

Ganapathi varma Chekuri from SQLServerCentral.com

This calculator will help you determine the number of DTUs for your existing SQL Server database(s) as well as a recommendation of the minimum performance level and service tier that you need before you migrate to Azure SQL Database. More »


Free eBook: SQL Server Internals: In-Memory OLTP

Press Release from Redgate

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton. More »


SQL Server Machine Learning Services – Part 4: Finding Data Anomalies with Python

Additional Articles from SimpleTalk

Python is widely used to analyze data. One such use is to find anomalies or outliers. In this article, Robert Sheldon demonstrates how to create a support vector machine (SVM) to score test data so that outliers can be viewed on a scatter plot. More »


From the SQLServerCentral Blogs - Wait Statistics on a Query

Grant Fritchey from SQLServerCentral Blogs

Wait statistics are a vital part of understanding what is causing your system to run slowly. Capturing them can be... More »


From the SQLServerCentral Blogs - Waiting Tasks Reveal Pain Points

MarlonRibunal from SQLServerCentral Blogs

Waiting tasks quickly shows you where to look for the bottlenecks. This is only one of the many times that I... More »

Question of the Day

Today's Question (by Steve Jones):

I have two data frames that I want to compare. The first is passing.2017, and contains this data:

  rank        player.name year2017 yards2017
1    1          Tom Brady     2017      4577
2    2      Philip Rivers     2017      4515
3    3   Matthew Stafford     2017      4446
4    4         Drew Brees     2017      4334
5    5 Ben Roethlisberger     2017      4251

The second is passing.2016, with this data:

  rank   player.name year yards2016
1    1    Drew Brees 2016      5208
2    2     Matt Ryan 2016      4944
3    3  Kirk Cousins 2016      4917
4    4 Aaron Rodgers 2016      4428
5    5 Philip Rivers 2016      4386 

If I want to combine these so that my final data set has 5 rows and compares the top ranked passers, which function should I use?

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.


T-SQL Querying (Developer Reference)

Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

On SQL Server 2016, what is the data type of a parameter for SET CONTEXT_INFO?

Answer: binary data


SET CONTEXT_INFO needs varbinary(128) data passed in. Other data types need to be implicitly CASTed or CONVERTed to this type. The implicit conversions occur with numeric types

Ref: SET CONTEXT_INFO - click here

CAST and CONVERT - click here

» Discuss this question and answer on the forums

Featured Script


Patrick Slesicki from SQLServerCentral.com

Select the appropriate database and run.

This query creates a data dictionary for all joinable objects in the databases, i.e. tables, views, and table valued functions.

Let me know what you think.

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.

SQL Server 2016 : SQL Server 2016 - Administration

SQL Server Browser missing - Hi We have installed SSRS 2012 and upgraded to 2016. The SQL Server Browser is not installed on the machine. The setup...

Data Copy for reporting purposes - Hi! @ present we have a reporting server which is for internal and external users..they run regular reports. - we keep the...

Access users can't use SQL 2016 (?) - I'm migrating several Access backends from SQL Server 2005 to SQL Server 2016. I have successfully gotten the ODBC connections...

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

Rewrite SQL code to perform better and be in line with best practice. - Is there a better way or a more efficient way to write the attached stored proc that leans on to...

Performance improvement following a disable indexes, shrink, enable indexes - but why? - I'm stumped and need the assistance of the wider community to understand what is going on. The database in question has...

Help me with the SELECT statement please ? - Good Day  For the sake of simplicity, I just added one members records. What you see is this member had enrollment...

SQL Server 2014 : Development - SQL Server 2014

Need a SQL Query to find numeric values - Hi Experts, Can you all help me out to find a query in which i can find all the tables in...

SQL Server 2012 : SQL 2012 - General

Grouping dates and IDs together - I have what at first (and second and fifth) glance appears to be an impossible task. I have to take...

Running total with reset condition - hi all, i would like a running total with a restart after a certain limit.  Let set the condition to be...

The queue %d in database %d has activation enabled and contains unlocked messages but no RECEIVE has been executed for %u seconds - I am getting below the message in error log every 1000 seconds on one of my instances where I have...

How to uninstall SSAS - I've been tasked with uninstalling SSAS from our SQL Server 2012 instance and re-installing it with the Multidimensional mode rather...

SQL Server 2012 : SQL Server 2012 - T-SQL

SqlException :- incorrect syntax near the keyword as,incorrect syntax near t2 - Hi All, I'm trying to run this code in my asp.net app below  but getting error  SqlException :- incorrect syntax near the keyword as,incorrect...

Query - Performance between dates - Im running a query and it has numerous linked tables. I have entered a date parameter of one week (28/01/2018...

SQL Server 2008 : SQL Server 2008 - General

Index operation fails with below - Hi All, Index operation is failing on SQL 2008 R2 Enterprise with below message. Any idea what's happening? It used to...

sql server database size and recovery model script. - Hi everyone. Can i get T-SQL script for SQL 2008R2/2012, which include database name, DB size & recovery model in single...

SQL Server 2008 : T-SQL (SS2K8)

Count from joins - Hi, Is there a better way of doing this? I'm joining back to the same table 4 times and counting from...

Reporting Services : Reporting Services

Stored Procedure for Data Driven Subscription? - I've found that the T-SQL I want to use for a data driven subscription isn't considered valid by the RS...

Programming : TFS/Data Dude/DBPro

Visual Studio Data Tools 2017 - TFS lock icons missing and other issues - Hi all We've just installed a test instance of Microsoft SQL Server Data Tools for Visual Studio 2017 (Version 15.3.5) and...

SQLServerCentral.com : SQLServerCentral.com Website Issues

Why can't I paste SQL code into a post??? - I've just spent 20 minutes preparing a new post in the SQL 2008 forum. It took me that long to...

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