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

Featured Script

Script out EXISTING database mail profile's settings

The Voice of the DBA

Stairway to Advanced T-SQL Crossword

See if you can solve this crossword puzzle based on the contents of the Stairway to Advanced T-SQL articles.

Across

7. At the same time.

8. day, month, quarter, millisecond, etc.

10. SELECT returns a

13. It's not real, but it should be real sized.

14. Rows and columns switch

17. Pass in a value get back rows.

18. Greenwich

20. (?°?°)?? ???

21. A query within a query

23. Frankenstein's date

24. CROSS or OUTER but not JOIN

25. 30 days hath Sept, April, June and Nov, All the rest have 31, Except Feb that has 28.

Down

1. Windowed identity

2. CROSS APPLY is an easy way to do this.

3. The loop everyone loves to hate.

4. Get

5. Sphere + AL

6. Anchor required

9. One from many.

11. Determines the partitioning and ordering of a rowset before the associated window function is applied.

12. Typically found in a development or test database.

15. 1,2,2,3,4,5,6,6,7

16. Inline View

19. How deep can you go?

22. High precision getdate()

Kenneth Fisher from SQLServerCentral.com

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

Benchmark your Database DevOps maturity level

Get a better understanding of how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers. Complete the Database DevOps Maturity Assessment

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

Featured Contents

Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell

Ben Miller from SQLServerCentral.com

In this level we will look at ways of getting data into and out of SQL Server. We will specifically look at the Database object and a cmdlet Invoke-Sqlcmd or Invoke-SqlCmd2. To get data in, we are going to leverage a PowerShell script that uses SMO to put data into a predefined table in SQL Server. 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 Graph Databases – Part 3: Modifying Data in a Graph Database

Additional Articles from SimpleTalk

Modifying data in Graph Database tables is similar to working with traditional tables, but there are several things to consider. Robert Sheldon explains how to insert, update, and delete rows of Graph Database tables and explains how to use several new helper functions. More »

Shift LEFT magazine: Issue 3

The latest issue of Redgate’s Database DevOps magazine explores the benefits of DevOps for CEOs, CIOs, and IT Managers, and takes a comprehensive look at the new General Data Protection Regulation, providing a valuable insight into how organizations can meet its demands. More »

From the SQLServerCentral Blogs - Exploring the Caves of Code Analysis in #SQLPrompt

Steve Jones from SQLServerCentral Blogs

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes... More »

From the SQLServerCentral Blogs - In-Memory OLTP: A Case Study

Bert Wagner from SQLServerCentral Blogs

Watch this week’s episode on YouTube. When In-Memory OLTP was first released in SQL Server 2014, I was excited to start... More »

Question of the Day

Today's Question (by Steve Jones):

I have this code in Python:

 >>> i = [1,2,3] >>> j = 1

If I now do this, what is returned?

 >>> i[1] = 4 >>> print(j)

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-761 Querying Data with Transact-SQL

Prepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. 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 from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I have an Extended Event (XE) session called "QueryTuning". How do I start this session on my instance in T-SQL?

Answer: ALTER EVENT SESSION QueryTuning ON SERVER STATE = START

Explanation:

The ALTER EVENT SESSION DDL is needed here. The ON SERVER is required and the STATE = START will begin the session.

Ref: ALTER EVENT SESSION - click here

» Discuss this question and answer on the forums

Featured Script

Script out EXISTING database mail profile's settings

Subhash Chandra from SQLServerCentral.com

Script which will script out your present SQL Server 2016 Database Mail profiler Setup and Configuration Scripts. It will give you the script to Drop and create Settings For DatabaseMail profiles.

Note: Tested on SQL 2005, to SQL Server 2016 Versions.

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

Find dialog box too small - Hi, does anybody know how to change the size of this dialogo box?

SQL Server 2016 : SQL Server 2016 - Administration

Upgrade SQL failover cluster from 2012 to 2016 - Hello, We are planning to upgrade our SQL server from 2012 (failover cluster) to SQL 2016 with Alwayson. I research a...

Publisher performance - transactional replication - We have setup push transactional replication, with the same server acting a both the subcriber and distributer. There are 28 Publications...

error in backup encryption - Hello everyone I need to encrypt my backup sql If I start the operation of the backup I come to have...

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

SQL 511 error on a SELECT statement - I am receiving the message while doing a SELECT statement. Msg 511, Level 16, State 1, Line 1 Cannot create a row...

Text data type - Is it still supported by SS 2016? Thanks

PowerShell Sql job - Hi, I 'm working to launch with a Sql Agent Job a powershell script. (the script is saved into network share because...

SQL Server 2014 : Administration - SQL Server 2014

SQLCMD Error ODBC Driver 11 - SQL Server 2014 Enterprise Cluster Windows 2012 R2 Servers On the Node1 SQL Cluster server I am running SQLCMD scripts to...

SQL 2014 Cluster Setup on VMware - VMware ESXi 6.5 Windows 2012 R2 Cluster Servers SQL 2014 Enterprise My Windows Server Clusters validation ran with just two warnings...

SQL Server 2014 : Development - SQL Server 2014

Remove duplicate substrings from string - Hello experts, I have a problem I'd appreciate advice on please. I'm asked to determine distinct combinations of sequences of values...

Need to add MMM-yyyy to end of file in exp.builder-SSIS - Hello, I've built a basic ETL ssis package that drops an Excel file from on network share to another network share....

Prepared Statement Running Exponentially Longer - Hello All, I've seen this behavior now on 2 different queries on different databases, but still can't figure out anything on...

SQL Server 2012 : SQL Server 2012 - T-SQL

Calculating Date Difference - I have eight dates and these are in ascending order. But all or some of them can be null. Is there...

SQL Server 2008 : SQL Server 2008 - General

Synonyms and performance - How does the use of synonyms effect performance? More specifically, are synonyms replaced with fully qualified names in execution plans? It...

SQL Server 2008 : SQL Server Newbies

Using CASE in a View - I have created an employee View to which I need to add a calculated field called Calendar. All my internet...

Reporting Services : Reporting Services

Calcultion done in query not showing in ssrs report. - I'm doing all my calculations in the query, and showing them on ssrs. However, the following calculated field's value is not...

SSRS vs Crystal Reports - Does anyone know of a good article (link) out there on the pros & cons of SSRS versus Crystal? I need...

Reporting Services : SSRS 2016

SSRS Counting Rows based on Date - Hello Everyone, I have a dataset that's bringing back 3 months of data, including a date. What I would like...

Visual Studio report designer and report parts - Hi all We've been using Report Builder from the SSRS web-page to produce reports and using Report Parts for standard items...

Data Warehousing : Integration Services

Creating derived columns from column of variable length components - Hi All, I'm hoping to get your guidance on this. I have a column, consisting of variable length sections that needs to be...

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.