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

The Voice of the DBA

Thanksgiving 2018

Today is Thanksgiving in the US, a holiday that most people get away from work.

A reminder for all of you, no matter where you are. Be thankful for something in your life. We're only here for a short time and we need to appreciate and find joy where we can.

Enjoy the day and see you tomorrow.

Steve Jones from SQLServerCentral.com

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

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

Continuous Delivery for SQL Server Databases

Spend less time managing deployment pain and more time adding value. Find out how with database DevOps

Featured Contents

Nasty Fast N-Grams (Part 1): Character-Level Unigrams

Alan Burstein from SQLServerCentral.com

An article about tally tables, N-Grams and the fastest character-level N-Grams function available today for SQL Server. More »

Creating Calculated Columns Using DAX

Additional Articles from SimpleTalk

In this article, Andy Brown shares his knowledge of how to create calculated columns in tables, using Power BI as the host software (all of the formulae shown would work equally well in PowerPivot or SSAS Tabular). This article is designed to be the first in a series of articles which will show you how to master programming in DAX. More »

Use SQL Server? We’d like to hear from you.

We are running a survey to better understand trends in adoption of different technologies and platforms. Completing this survey will take just a few minutes. As a thank you for your time, we will be giving away one $100 Amazon gift card to one randomly selected participant who completes the survey by December 7, 2018. Take part here. More »

From the SQLServerCentral Blogs - Setting Memory–#SQLNewBlogger

Steve Jones from SQLServerCentral Blogs

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as... More »

From the SQLServerCentral Blogs - Learning Better Presentation Skills (T-SQL Tuesday #108)

meaganl from SQLServerCentral Blogs

This month’s T-SQL Tuesday is hosted by Malathi Mahadevan (@SqlMal). The topic is to pick one thing I would like to... More »

Question of the Day

Today's Question (by Steve Jones):

I have a table of places in a US Census survey. I run this:

 select name from census_survey where place_name like 'Turkey%'

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 7 points in this category: humor.

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 Phoenix Project: A Novel about IT, DevOps, and Helping Your Business Win

The company's new IT initiative, code named Phoenix Project, is critical to the future of Parts Unlimited, but the project is massively over budget and very late. The CEO wants Bill to report directly to him and fix the mess in ninety days or else Bill's entire department will be outsourced. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What is returned here in SQL Server 2017:

 SELECT TRANSLATE('I want to have stuffing for dinner', 'stuffing', 'applepie');

Answer: p waip po have appllpie lor dpiier

Explanation:

Each charater in the second parameter is replaced by a character that is in the same position in the third parameter. The replacements occur in the first parameter.

In this case, each time an "s" occurs in the first string, it is replaced by an "a". "t" is replaced by "p", and so on.

Ref: TRANSLATE() - 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 2017 : SQL Server 2017 - Development

CASE Statement - I'm trying to add a new column to some code I have, and I am completely stumped. I was wondering if...

Exif data into a database. - Hello All, With the ExifTool by Phil Harvey I make a number of .CSV files from different media (harddisk, USB-stick, CD-rom's...

Incremental Table Copy - Hi, I have 3 huge table in excess of 100 GB each which need two be copied between two SQL 2017...

SQL Query Delete top 4000 rows when row count > 10K looping to reduce row count to 10K - Need a maintenance query for an alarm logging table to see if the row count is more than 200K rows...

How to study the layout of a database? - Hello friends, Suppose you download a sample database, whether it be AdventureWorks, Northwind, or whatever other database. What steps do you...

SQL Server 2016 : SQL Server 2016 - Administration

Transactional Replication multiple Distributors - My current setup is as follows: Server A = Publisher Server B = Subscriber and Distributor (Push subscription) I need to now also replication to...

SP2 CU4 - I've started getting the following error when installing this patch: Error installing SQL Server Database Engine Services Instance Features File C:\Program Files\Microsoft...

Database upgrade and migration to 2016 SQL Server - I am looking for pointers on what option to take for high availability for a new SQL Server 2016 environment....

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

Obfuscating character columns - Is anyone aware of any resources/websites/T-SQL code that will allow me to obfuscate ALL columns in ALL tables within entire...

Inner joins - Hi all. Our current version is 2008 and we are going to migrate it to 2016 or 2017. In many stored procedures,...

SQL Server 2014 : Administration - SQL Server 2014

SQL 2014 SSIS Dynamic Connection managers issue - I have a strange one here which has me and few others a little bit stumped. We have an SSIS template...

TempDB - Hi, Please i need your advise,to reduce TempDB allocation contention i must add more mdf files.I have a drive allocated for...

SQL Server 2014 : Development - SQL Server 2014

Case when inside of partition by? - Hi, I have the following situation: CREATE TABLE #TAB1( ID INT ,MY_STATE VARCHAR(10) ,EVENT_TS DATETIME ) INSERT INTO #TAB1(ID, MY_STATE, EVENT_TS) VALUES (1, 'STATE_1', GETDATE()) ...

SQL Server 2012 : SQL 2012 - General

Basic Question: Do you have to restart the instance if you change database or log file growth - Hi All, I have changed the default autogrowth to 300000MB. Do I need to restart the server instance in order...

SQL Server 2008 : SQL Server 2008 - General

How to find products commonly purchased together - Hi all, I feel certain this should be a common query, just maybe not using the right search. Here goes: I...

SQL Server 2008 : T-SQL (SS2K8)

Index and Search help - Hi, The belwo is my sample table structure and I will be buildinga sample website to test the search feature. Basically...

Programming : Powershell

parse string and check for valid date - I have a flat file with a bar(|) delimiter. It has no headers, but I want to check columns(11,12,13) for...

Data Warehousing : Integration Services

Cursors are not supported on a table which has a clustered columnstore index - Hello, I'm using OLE DB connection in SSIS, which inserts the data into SQL Server Table. I'm follwing getting error "Cursors...

SQL Server 2005 : SQL Server 2005 Integration Services

Problem using expression in SSIS - Hi, Below is the expression i am trying to make work : substring ("Archive_Full_20120731200002",1, (FINDSTRING( "Archive_Full_20120731200002","Full_", 1)-2)) Whe I use the exact string(Archive_Full_20120731200002)...

SQL Server 7,2000 : T-SQL

Natural Sort Order - Hello. I have a table that has a column of nvarchar that has rows containing both numbers and letters... Ex:...

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.