 | A community of more than 1,600,000 database professionals and growing |
| | | 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.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT |  | | 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 |
| |
|
|
| | |  | 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 » |
 | 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 » |
 | 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 » |
 | 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 » |
| | 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 » |
|
|
| | | 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. |
|
|
| |
| | 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; SELECT @a , @b;
Answer: 10, 10 Explanation: 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 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...
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...
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...
SELECT WHERE produces strange results.... - Hello: If I enter the following, I get data: SELECT TOP (1000) , , , , , , , , ,
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
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...
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...
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.
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....
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...
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...
Older posts - (new to SQLServerCentral, bear with me) I have a situation where a SQL Server reboots itself nightly. Looking for answers as...
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...
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...
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 newsletter@newslettercollector.com. 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 |
|
|
