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

The Voice of the DBA

SQL Crossword #2 SELECT Keywords

Enjoy our latest crossword puzzle and see if you can solve all the clues. These are all keywords and clauses of a SELECT statement. The key will be posted tomorrow.

Across

1. Clause that lists the tables used by the query.

4. Evaluate the right hand source once for each row in the left and only return a row if there is a result.

9. ______.b.c.d

10. Return only the rows that match.

12. Return all rows on both sides of the join.

13. Return all rows on the left, and only the matches on the right.

15. Alias

16. Combine the data from two queries, but only return distinct rows.

17. The only required keyword of a select statement.

Down

2. Creates a group for each combination of column expressions in the GROUP BY and provides subtotals and totals.

3. Join two 100 row tables and get 10,000 rows returned.

5. Return all rows on the right, and only the matches on the left.

6. Combine the data from two queries.

7. Most conditions on a query go here.

8. a.b.______.d

11. Compare the data between two queries and only return matches.

14. Return everything on the left that doesn't exist on the right.

Kenneth Fisher from SQLServerCentral.com

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

Could your SQL coding be more efficient?

Data Platform MVPs and SQL Server experts share their tips on how to standardize formatting whilst stripping out the repetition of coding with SQL Prompt. Over these 20 short videos we will help you write better, shareable SQL faster. Check out the tips

How to track every change to your SQL Server database

See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more

Featured Contents

Stairway to SQL Server Automated Database Testing Level 1: Why You Need TDD

Sebastian Meine from SQLServerCentral.com

The first article in this Stairway Series makes the case for test-driven development. More »

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Additional Articles from Redgate

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions. More »

Monitoring Azure Cloud and Hybrid Environments

Additional Articles from SimpleTalk

Cloud-based services and applications must still be monitored just like the on-premise ones. You still need most of your data center activities that ensure that your planning, budgeting, security and service-level obligations are met wherever the data and services are actually hosted. There is much to be said for an integrated approach to providing a unified view of entire application workloads on-premise. hybrid and cloud using the same tools wherever possible. More »

New permissions features brings access control to SQL Clone

SQL Clone permissions has been high on the wish-list for users and the new feature addresses it in an intuitive way that enables you to allocate and change permissions quickly and easily. More »

From the SQLServerCentral Blogs - SQL Server on Linux Series: Moving TempDB

kleegeek from SQLServerCentral Blogs

In the last blog post, we added additional drives to the SQL Server machine so that we can scale out... More »

From the SQLServerCentral Blogs - Columnstore Indexes – part 109 (“Trivial Plans in SQL Server 2017”)

Niko Neugebauer from SQLServerCentral Blogs

Continuation from the previous 108 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Do you remember one of the major... More »

Question of the Day

Today's Question (by Steve Jones):

I want to build a matrix in R that has 5 rows, 4 columns, and each value in the matrix is 7. How do I do this?

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.

The DevOps Handbook: How to Create World-Class Agility, Reliability, and Security in Technology Organizations

More than ever, the effective management of technology is critical for business competitiveness. For decades, technology leaders have struggled to balance agility, reliability, and security. The consequences of failure have never been greater?whether it's the healthcare.gov debacle, cardholder data breaches, or missing the boat with Big Data in the cloud. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

The EXTRACT expression has three different parts, designed to help you move data from unstructured data into some sort of schema. What comes first in this statement?

Answer: The schema definition to be used

Explanation:

The EXTRACT expression takes a column definition list first, which is the schema. Next the from clause lists the file(s). Last the type of extractor is listed.

Ref: EXTRACT Expression - 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

Unable to connect to SQL 2008 Servers from SSMS 2017 - Servers are running on SQL 2008 on Windows 2003. Client from where I am trying to connect to those servers...

SQL Server Multiple Databases Management Solution - Hi Senior DBA's. Do you know of a way to automate the below requirement to create a daily report ( on a...

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

70-461 exam - I bombed this exam and afterwards discovered the 70-461 Querying Microsoft sql server 2012 book has nearly all the material...

SQL Server 2014 : Administration - SQL Server 2014

Backup size and DB size are different. - I have a DB which is supposed to be close to 250 GB in Size. I have couple of scripts...

Can't open the master key on Always on SQL Server - We have fail-over cluster for one of our production environment. It has two node with SSISDB configured. Someone has configured...

SQL Server 2012 : SQL 2012 - General

Need to remove punctuation characters - Hi, I need to remove any punctuation characters at the end and before new line. Please help.

SET NOCOUNT ON at instance level - not working. - Hello Members, I have configured nocount as default connection property using following command. EXEC sp_configure 'user options', 512. Unfortunately, when I connect...

Transaction log full error - The database is in simple mode and when I try to shrink the log USE db1

Login failed password did not match for SQL loin - Hi , I am getting error when i login SQL Server 2012 ' Login failed password did not match" buit i can...

SQL Server 2012 : SQL Server 2012 - T-SQL

Query performance tuning - Slow execution time - I've been tasked with performance tuning the underlying query. I have attached all the necessary details but if there is...

Query performance tuning - taking more than 9 minutes - Below is one of the reporting query that is taking almost like more than 9 minutes to complete and as...

Time increments - Hi, I want to have a calculated field "TimeIncrements' that will increment 20 minutes starting at 8:00 and ending at 5:00...

SQL Server 2008 : SQL Server 2008 - General

Maintenance Plan mystery - Hello Everybody, A maintenance plan in one old server (running SQL server 2008 R2 SP3) has 'backup' and 'Maintenance Clean up'...

Log file just doesn't shrink - Hi Everybody, Log file of one of our databases grows very high (now over 200 GB) . I have been shrinking it...

determining recommended indexes or indexes that are being used - Hello All, We run 2008R2 enterprise edition of MSSQL server. There is SPID on the server that we plan to monitor (and...

SQL Server 2008 : T-SQL (SS2K8)

Subroutines in TSQL - I am a heavy TSQL coder, I love the many aspects of TSQL but I always wonder why we should...

SQL Server 2008 : SQL Server Newbies

xp_cmdshell works and then doesn't work - A stored procedure intermittently fails, and it appears to be because xp_cmdshell stops working. If I try it manually, here is...

SQL Server 2008 : SQL Server 2008 Performance Tuning

Deducing from Wait Stats - Hi Everybody, The wait stats on the database I am assigned for performance tuning , shows that the PAGEIOLATCH_SH and CXPACKETS share...

Programming : General

Advice please - how to train up on API integrations - Hi all My company has a product which is based on SQL Server 2014, and we're looking to add some integrations...

Data Warehousing : Integration Services

SSIS to Execute SQL Query on Teradata, Return Results to SQL Server Database Table - Hello, I have a single Teradata statement query, in a SSIS package, with a single Execute SQL Task. In that...

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.