SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

The Fourth of July in 2018

The Fourth of July is a historial marker that represents the beginning of the US as an independent country. It's a celebratory day for those of us living in this country that's not much different from similar holidays in many other countries.

This day often results in a long weekend of outdoor summer enjoyment for many people. This year, that's not the case as it's a Wednesday, right in the middle of the week. I actually like midweek holidays as they break up the work week into two short sections. The downside is that any plans to travel and take advantage of the break require taking holiday time from work. As I'm leaving in a few weeks for my own vacation, this is just a day off to spend with family.

In today's busy world, it's not often that my wife, kids, and I can get together to do something. It seems that most weeks one of us has some plans in place on any given day, so it can be difficult to schedule meals, let alone other activities. We did make an effort to go hiking on Memorial Day, which was enjoyable. For this holiday, we're going up to the mountains for more hiking, and hopefully less heat.

We all get busy with life and work, especially in today's far too connected world. It's important to make some time for life and family, hobbies, faith, and other important parts of life. Whether today is a holiday for you or not, ensure that you take advantage of those breaks from work to remember why you spend all week in front of a computer.

Happy Independence Day to everyone in the US.

Steve Jones from SQLServerCentral.com

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

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

Database DevOps

Continuous Delivery for SQL Server Databases

Spend less time managing deployment pain and more time adding value. Find out how with database DevOps

Featured Contents


Stairway to Columnstore Indexes Level 9: Batch Mode Execution

Hugo Kornelis from SQLServerCentral.com

In this level, Hugo explains what batch mode execution is, how it differs from row mode execution, and what its limitations are. 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 »


Missing Data

Additional Articles from SimpleTalk

Missing data is a difficult and common problem to solve. In this article, Joe Celko explains several approaches to deleting or replacing missing data. More »


From the SQLServerCentral Blogs - My Speaking Schedule

Grant Fritchey from SQLServerCentral Blogs

I have quite a few speaking engagements coming up. Rather than an intermittent blog post, I’ve decided to have a... More »


From the SQLServerCentral Blogs - SQL Puzzle – FizzBuzz3d

Kenneth Fisher from SQLServerCentral Blogs

I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case... More »

Question of the Day

Today's Question (by Steve Jones):

I run this code in Python:

>>> a = "Happy"
>>> b = "Independence Day"
>>> a, b = b, a
>>> print( b, a)

What is returned?

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

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-774 Perform Cloud Data Science with Azure Machine Learning

Prepare for Microsoft Exam 70-774 and help demonstrate your real-world mastery of performing key data science activities with Azure Machine Learning services. 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 today from Amazon.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What does this code return? (answers in order of the SELECT).

DECLARE @a INT = 5 ,
        @b INT = 10;
SELECT @a = @b ,
       @b  = @a;

Answer: 10, 10


In this code, we are trying to swap the values of the variables. However, SQL works in order, and @a gets assigned 10 from @b. When we go to assign @b from @a, the value is 10.

Ref: No great references here. Try it and you'll see. There are some good articles on variable assignment:

When to use SET vs SELECT when assigning values to variables in SQL Server - click here

Difference between SET and SELECT - 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 - Administration

SQL alert : 15 SQL errors. - I setup some SQL alerts in SQL out of box alerts.  No 15 is SQL Errors. I got the alert in...

Jobs running indefinitely - Hi, I have an sql server 2017 enterprise and sometimes (not always), when it runs a job (the jobs he...

SQL Server 2017 : SQL Server 2017 - Development

Need to display a column with deleted overlapping dates - I want to get rid of the following overlapping records from the table and display the below output. Also, I...

SQL Server 2016 : SQL Server 2016 - Administration

Insert into increased database size to maximum - Hi, sorry first of all for the  nervous writing and multiple edits, i think i srewed up big time and try...

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

SELECT WHERE produces strange results.... - Hello: If I enter the following, I get data: SELECT TOP (1000)   ,   ,   ,   ,   ,   ,   ,   ,   ,

SQL Server 2012 : SQL 2012 - General

Getting UserDetails from Application - I have to write a procedure where I need to capture some data from application and insert into some tables....

Migrating data from one server to another - Hi Is there any way other than export and import where we can migrate data from one server to another. Thanks

SQL Server 2012 : SQL Server 2012 - T-SQL

Getting two different fields from two different tables - I have a procedure which takes two parameters and I want to get the primary key values of those two...

Phone Number Validation - Greetings, I'm working on a project where we have to take a list of unique phone numbers in our database and...

SQL Server 2008 : SQL Server 2008 - General

Comparing E mail address through SP - Hi All, Noticed a strange issue . When I query data from a table having email address field the where condition that...

Is null performance issues - Dear All, I have a query which has ISNull in my where condition, I'm aware that it henders the performance...

After Insert trigger - Hi All, I'm trying to create an After Insert in SQL Server 2008 R2 with the code below. The user I'm...

SQL Server 2008 : T-SQL (SS2K8)

how can I get uniqueidentifier value as return after insert a record - Hi... how can I get uniqueidentifier value as return after insert a record.

SQL Server 2008 : SQL Server 2008 Administration

Finding culprit for ongoing TempDB growth - A couple of weeks ago, our TempDB size went crazy, claiming more than 100GB of space within about a week....

Reporting Services : Reporting Services

Highlighting of changeable data using a "colour table" - I am a lone, and originally accidental, DBA, so would very much appreciate feedback on a solution I have come...

Programming : Powershell

Move files without moving subfolder files - I have been tasked with building a powershell file mover to move files (which could have any name and possibly...

SQLServerCentral.com : SQLServerCentral.com Website Issues

Older posts - (new to SQLServerCentral, bear with me) I have a situation where a SQL Server reboots itself nightly.  Looking for answers as...

SQL Server 2005 : Working with Oracle

The OLE DB provider "OraOLEDB.Oracle" has not been registered. - Hello I would like to connect oracle database to sql server 2005 and i installed oracle client and also used the...

SQL Server 2005 : SQL Server 2005 General Discussion

Convert a Unix date in SQL to a standard date - Does anyone know who to take a:unsure: date in unix 1220140800 and convert it to a standard date Sept 30...

SQL Server 2005 : SQL Server 2005 Integration Services

I want to use multiple Inputs into one Script Component - I just read the SQL Server Central article called "Error Handling in SSIS" By Jack Corbett, 2009/04/03 (first published: 2008/04/21)....

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