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

The Voice of the DBA

Byte Me: Christmas Contingency

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

SQL Monitor - Always have the answers to SQL performance issues

SQL Monitor keeps an eye on your SQL Servers 24/7, so you don't have to. It helps you proactively monitor the performance of your SQL Servers, saving you time, and makes sure you always have the answers to tough performance problems. Find out more.

DLM Demo Webinar

Learn how to automate your database deployments alongside your app code in this free demo webinar. Register now.

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 Exploring Database Metadata Level 6: Idempotent DDL scripts that always achieve the same result: Making changes only once

Phil Factor from SQLServerCentral.com

Idempotence is the property of certain operations in mathematics and computer science, that can be applied multiple times without changing the result beyond the first time they are run. When you are making changes to a database to deploy a new version, you need to be sure that certain changes aren’t made twice, or in the wrong order. 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 »

What is Azure SQL Data Warehouse?

Additional Articles from Microsoft MSDN

Azure SQL Data Warehouse is a cloud-based, scale-out database capable of processing massive volumes of data, both relational and non-relational. Built on our massively parallel processing (MPP) architecture, SQL Data Warehouse can handle your enterprise workload. More »

Disconnecting SQL Server connections after query execution

Additional Articles from MSSQLTips.com

One way to improve SQL Server performance is to use as few resources as possible. In this post Rahul Mehta demonstrates how you can do this by disconnecting queries post-execution with a simple change in SSMS. More »

From the SQLServerCentral Blogs - Optimize For Unknown

SQLBalls from SQLServerCentral Blogs

Hello Dear Reader! It's been a while. I was working with a friend and we came across an interesting problem.... More »

Question of the Day

Today's Question (by Steve Jones):

In SQL Server 2016, what is the string input size limit for the HASHBYTES function?

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: SQL Server 2016.

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

Tabular Modeling in Microsoft SQL Server Analysis Services

With SQL Server Analysis Services 2016, Microsoft has dramatically upgraded its Tabular approach to business intelligence data modeling, making Tabular the easiest and best solution for most new projects. In this book, two world-renowned experts in Microsoft data modeling and analysis cover all you need to know to create complete BI solutions with these powerful new tools. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Grant Fritchey):

Looking at a table within SSMS you spot views with the following naming structure:

_MPStats_Sys___

Where did that view come from?

Answer: System generated views in support of Correlated Datetime Columns

Explanation:

Correlated Datetime Columns were initially available in SQL Server 2005. If you have tables that are related through foreign key constraints on the DATETIME data type, you can modify your database to enable DATE_CORRELATION_OPTIMIZATION which is disabled by default. This only works between an equi-join on two tables with the DATE or DATETIME data types, a foreign key, and clustered indexes. You can read more about it in this MSDN article.

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

Stored Procedure with optional parameters - Hi, I have a table create table StudentBankDetails (AccountID nvarchar(10) not null , Name nvarchar(255) not null , [Address] nvarchar(255), CurrentBalance Money , BankStatus nvarchar(10)) and...

Calling a Insert/Update Stored Procedure from a Result set of Query - Hi, I have created a stored procedure(1) to do an insert / update when a parameter is passed. i have a table...

Data file growth events and clustered index - Hello Guys, I a table of around 10 GB size. Recovery model of database (SQL Server 2005) is simple. For some...

SQL Server 2014 : Administration - SQL Server 2014

How to modify query to only use base tables - I'm new to SQL so I'm not really sure what to do. Also not sure if I'm on the right forum...

Table copy - hI all, how can i copy a table with an specific amount a data. example: myTable has 5 millions rows. I will create myNewTable...

moving sql2005 database to sql2014 - Hi, Can we directly restore sql2005 database backup on sql2014 instance ? thanks.

Options for auditing SQL logins - We're running SQL 2014 SP1. We're needing to audit who is logging into SQL to check if SQL users are...

SQL Server 2014 : Development - SQL Server 2014

Query help filling in dates and data - I have a data table and a calendar table. I need to fill in the gaps to have a row...

Query help - Maybe my skull is a little too thick today but I cannot figure out why this is not grouping correctly: SELECT...

GROUP BY in SQL Server 2014 - Hello all, The same query with a group by clause I try to run on SQL Server 2005 and on SQl...

How to extract overlapping date ranges from a table of date ranges - Would appreciate help and or hints to the following scenario:: Magazine subscriptions are registered on a per subscriber basis with subscription...

SQL Server 2012 : SQL 2012 - General

Help with Query to Look at the list and return repeated value if condition is met - Hi Everyone I asked a similar question in my previous post but didn't get the right result , although it is nearly...

SQL Server 2012 : SQL Server 2012 - T-SQL

When Your Primary Key is Not the Clustered Index - Hi, We have tables that have primary keys that are not the clustered index. The primary key still gets used...

SQL Server 2008 : SQL Server 2008 - General

How to imbed an image into an email sent by dbmail - Hello all and thank you in advance for your time and expertise. I am sending out customer statements in email using...

SQL Server 2008 : SQL Server Newbies

SQL Reproting Failed to query - Hi Good Day, Kindly please help me on my problem regarding the reporting services of SQL server. I have a...

Reporting Services : Reporting Services

Reporting Services From a Data warehouse - Bottleneck On Every Month - Hi All, I am a Software Engineer working in an MNC on MSBI Platform. I have been working in Reporting services project...

Reporting Services : SSRS 2014

Warning 1 [rsInvalidColor] The value of the BackgroundColor property for the page ‘Page’ is “Light Green”, which is not a valid BackgroundColor. - I am following examples/exercises in this book: https://drive.google.com/open?id=0ByFnKe4djAO-d29ZTUJrbExhbzQ page 238. I am getting an error: Warning 1 [rsInvalidColor] The value of the...

Data Warehousing : Integration Services

IF Exist Delete file and copy a Template File VB.NET Script Task - I'm trying to remember how I would check for the existence of a file and Delete it in a VB...

Importing Excel file - Overriding the ACE driver's field type - Hi All, I know this is an age old problem, however, does anyone know how to get around the ACE driver...

Change the Language for SSIS Script Task - How can I change the OOP language that SSIS uses for things like the Script task? Mine comes up to...

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.