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

Featured Script

Get Blocking Details

The Voice of the DBA

Byte Me: DeleteDeleteDelete

Bob Lang from SQLServerCentral.com

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

The industry standard tools for comparing SQL Server schemas and data

How do you save time comparing and deploying SQL Server database schemas, create error free deployment scripts in minutes, and fix errors caused by differences between databases? Find out with a free trial.

Track schema changes for free

DLM Dashboard tracks SQL Server databases to show you exactly what schema changes have been made, by who, and when. You get a full history, with line-by-line differences, and a clear audit trail of your database moving from development to production. Download free tool.

Want to include your database in your ALM processes?

With Database Lifecycle Management, you can add your database to your source control, continuous integration, and release management processes, to reduce risk and improve efficiency. See how with this free whitepaper.

Featured Contents

Stairway to U-SQL Level 3: Processing Multiple Files With U-SQL

Mike McQuillan from SQLServerCentral.com

In part 3 of the U-SQL Stairway, we look at how multiple files can be processed with a single U-SQL statement. More »

Free eBook: SQL Server Internals: In-Memory OLTP

Press Release from Redgate

In this free eBook, Kalen Delaney explains how Microsoft's new 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 »

Introduction to the Azure SQL Database Advisor

Additional Articles from Database Journal

One of the challenges associated with running your workloads in Azure SQL Database is the limited level of management oversight. Fortunately, there is an alternative approach that leverages the functionality incorporated into the recently introduced Azure SQL Database Advisor - Marcin Policht provides a brief overview. More »

From the SQLServerCentral Blogs - CASE Statement in GROUP BY

Grant Fritchey from SQLServerCentral Blogs

Set based operations means you should put everything into a single statement, right? Well, not really. People seem to think that... More »

Question of the Day

Today's Question (by Steve Jones):

What are the defaults for the number of tempdb data files in a new SQL Server 2016 instance installation? (choose 2)

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

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

Professional Microsoft SQL Server 2014 Integration Services

The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What is the default path mode for querying JSON documents in SQL Server with OPENJSON?

Answer: lax

Explanation:

There are two path modes in SQL Server (As of SQL Server 2016) for querying JSON documents. There is the lax mode, which returns NULLs for an invalid path. This is the default.

THe other mode is strict, which returns an error for invalid paths.

Ref: JSON Path Expressions - https://msdn.microsoft.com/en-us/library/mt577087.aspx#PATHMODE

» Discuss this question and answer on the forums

Featured Script

Get Blocking Details

Rahul Biswas from SQLServerCentral.com

Run the script to get blocking details from the various DMVs.

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 - Development and T-SQL

Decreasing a value across multiple rows until 0 - If I have several records in a table such as this: 100 50 50 20 And I want to subtract 175, I want a result...

Finding a substring and extracting a number associated with it - Hi, I have a text string that appears in files as below: 'There were 6 discharges and 3 admission since reporting 21/04/2016' However...

SQL Server 2014 : Administration - SQL Server 2014

Job doesn't run as per schedule at 1:05a, but runs when triggered manually. - Hi, I am not sure if this is a unique issue for me or is it a known issue for others...

Stored Procedure execution - Hi Team, In one of our prod server one stored procedure is taking long time to execute than normal execution. It is...

Somewhat urgent issue related to AG - All, I have this error in a logfile "Unable to access availability database because the database replica is not in...

SQL Server 2014 : Development - SQL Server 2014

TSQL Select specific records and child records from same table - Hi guys. I'm fairly new to SQL, but learning quickly. I've got a situation where I need to query a...

CTE Script Needed for delete statement - Hi, we are using below script for delete records.but it is taking time USE AdventureWorks2008R2; GO DELETE * FROM Purchasing.PurchaseOrderDetail WHERE DueDate = '20020701'; GO is there any possibility...

query performance tuning - Hello! I am running a query which is taking 23 mins to run in my dev server. I need your...

SQL Server 2012 : SQL 2012 - General

Using SSIS to copy rows from SQL server 2008R2 to MySQL - I'm hoping that someone might have some good advice on this one. Basically I have a table with 3.5M rows...

Single database attached to two instance - how to take backups from each instance - This is venu, i am learning SQL Server DBA.... while practice i got a doubt. 1. I have attached "AdventureWorks2012' in...

How to practice SQL server at home - Hello everyone. I would like to know if it is possible to use SQL Server Management Studio at home so...

SQL Server 2012 : SQL Server 2012 - T-SQL

Query - Hi I have 1 query which returns record order by ID like this. Now i want that in addition to the...

not able to find why/where this error is comming. - hi, i am getting this error"The current transaction cannot be committed and cannot support operations that write to the log file....

HTML Backup Report Design Considerations & T-SQL script - I'll be quick on this one. Basically, I have a requirement to develop a script that would provide the client...

SQL Server 2008 : SQL Server 2008 - General

Help creating a dynamic table of numbers - Hello all, I'm trying to dynamically create a table of days spanned for a aging report. I would like the end...

SQL Server 2008 : T-SQL (SS2K8)

Date Range overlaps - hi I have the sample data:Insert Into @Table (Id,Code, StartDate, EndDate, TimeDiff) [code="sql"]SELECT 1, 'DA6310', '2016-06-20 09:25:00.000', '2016-06-20 11:15:00.000', 110 Union...

Cloud Computing : SQL Azure - Administration

What are the different database types? - I will be celebration the USA's Independence, have some bar-b-que and go hiking with my family. :-D But I also intend...

Reporting Services : Reporting Services

SSRS show trend chart by up and down arrow over column chart per series groups - chart data Values- No of Itemsold Group-Product(ProductA,ProductB,ProductC...) Series -Year(2013,2014,2015,2016) I have to show the trend of the item sold for each group by a...

SSRS report manager not rendering charts - We have built out a new report server using SQL 2012. After deploying our new and old reports to this...

SQL Server 2005 : SQL Server 2005 Integration Services

Rename file - prefix with file date - I receive three versions of a file each day, which I then import. But the file names are such that...

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.