SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

How Long Before You Upgrade?

This editorial was originally published on Apr 11, 2014. It is being re-published as Steve is out of town, with a few minor changes to dates and values.

It's 2017. SQL Server 2000 is 17 years old, but there are still quite of you managing instances. SQL Server 2005 is 12 years old, and I'm sure more of you still deal with that version. I know because I work for a software vendor and I'm constantly asked if our software will run against those two versions of SQL Server. Most of our software is no longer supported on those versions, as they're too far out of date.

For many of you, however, if you're managing a SQL Server 2000 instance, it might only be 10 or 12 years old. Your company might still have been installing SQL Server 2000 in the year 2005. The same is true for SQL Server 2005. I wouldn't be surprised to find companies still installing 2005 instances in 2008 or even 2009.

Companies don't care much about versions. They tend to mostly care about databases getting the job done, and sometimes, support. Many organizations don't see value in upgrading too often because of the overhead. I suspect many managers would prefer to get many years usage out of a platform before they change in order to minimize work that doesn't add value to their business.

The question this week asks you about the longevity of your database instances. Think about the average instance, or even the majority of your applications and how long they will remain on a particular version.

How many years will you run a platform before you upgrade it?

Years ago I heard someone at a large Fortune 100 company say their stated policy was to get 10 years of service out of a database server. At the time I thought that was a long time, but the more I think about it, the more I think that might be a minimum amount of time I'd want from a platform.

Let us know this week what you experience, and perhaps what you'd prefer.

Steve Jones from SQLServerCentral.com

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

ADVERTISEMENT
Redgate Hub

Register now for SQL in the City Streamed

Redgate’s popular SQL in the City Streamed virtual event takes place again this December. Wherever you are, tune in on Wednesday December 13 to watch some of the best-known speakers from the database world present the latest technologies and tools from Redgate. Register free now

SQL Compare

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

Featured Contents

 

Advanced Analytics with R & SQL: Part I - R Distributions

Frank A. Banin from SQLServerCentral.com

Build and Operationalize scalable Predictive models and intelligent applications using SQL and R. More »


 

Mixing MongoDB and Relational Databases in the Enterprise

Additional Articles from SimpleTalk

Your Agile developers want MongoDB, or a similar document database: your Ops people are concerned about security and backup, and Governance are muttering about transactionality and data transfer between systems. Do you restrict your developers from rapidly-evolving the data design for their domain or do you embrace the joys of NoSQL unconditionally? If you accept a polyglot database environment, where the NoSQL lambs coexist with the relational lions, how do you provide tools and common database concepts that everyone can use and understand? More »


 

From the SQLServerCentral Blogs - SQL Server 2017: Making Backups Great Again!

jsterrett from SQLServerCentral Blogs

In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database... More »


 

From the SQLServerCentral Blogs - Configuring Azure Data Sync

David Postlethwaite from SQLServerCentral Blogs

In this video David demonstrates how to configure Azure Data Sync 2.0 to synchronise an Azure SQL database with an... More »

Question of the Day

Today's Question (by Steve Jones):

What's wrong with this code?

DECLARE @Numbers TABLE
(   message_id INT
  , C1 AS CHAR(2000))
;
WITH myTally(n)
AS
(SELECT n = ROW_NUMBER() OVER (ORDER BY (SELECT null))
 FROM (VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)) a(n)
  CROSS JOIN (VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10)) b(n)
)
INSERT INTO @Numbers
    (
        message_id
      , C1
    )
SELECT n, REPLICATE( 'a', n)
 FROM myTally
;
 

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: T-SQL.

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

ADVERTISEMENT

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):

Can I create this table in SQL Server 2016? 

CREATE TABLE AVeryWideTable
( mychar CHAR(8000)
, morechar CHAR(54)
)
GO

Answer: No

Explanation:

While the row size limit is 8060, there is overhead internally that is needed for each row. 7 bytes are added, so this table would result in a row size of 8061.


» 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 - Administration

When someone comes to you wanting to learn T-SQL? - I'm not sure where to put this thread, so apologies if it's in the wrong place. I'm wondering what other people...

standalone instances - 300 DBs 2 TB worth - how to sync - Hi DBA Gurus, I've been assigned a task first to propose a plan including scripts and Time for the below scenario....


SQL Server 2017 : SQL Server 2017 - Development

need help - hello all, I have 3 tables. employee , division and empDivMap. The employee table is the master table of employee data. The...

Shared stored procedure with very complicated input - So, the basics of what I want to accomplish is simple...I have a stored procedure that has some really complex...


SQL Server 2016 : SQL Server 2016 - Administration

Restoring 2005 dbs to 2016 - I have a few question about migrating databases from 2008 RTto 2016. The databases were originally created in 2005 and then...

Planning for a server - Hi, this is a very general question, and I need a baseline idea of where to go. Getting into too...

t-SQL Solution to backup and restore - Dear all, I was requested by my company to create a solution that is able to backup a database from PROD...

ApexSQL Monitor - Good afternoon, Has anyone ever used or have an opinion on the ApexSQL Monitor tool? I am currently evaluating the product...


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

Create Table with appropriate Data Types based on flat file - I have been asked to help another team load some data into a new SQL Database to help them analyze...


SQL Server 2014 : Administration - SQL Server 2014

Using Extended Events to alert on long running queries - Hi Is there a way with Extended Events, where I can set up something; should a user/developer run a query via...

Database Corruption - Hi All,  I hope that I could had some Help concern to a issue that currently I am facing. So I have...


SQL Server 2014 : Development - SQL Server 2014

Table Structure of Monthly Data - I'm curious what everyone thinks is the best way to store data where the history of aggregated data for an...

Trying to speed up this 'GetWorkingDays' function. - I'm trying to redesign one of our working days functions. The idea is to calculate weekends (easy enough) but holidays...


SQL Server 2012 : SQL 2012 - General

TransactionLog. VLF Fragmentation. - Hi Guys!! ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->8 During the tests, I set the true size for my transaction log file (its a size after maintenance plan,...

What is use of pre-defined Schemas in SQL SERVER ? - Hi All,  I am having confusion and really don't know the purpose / Use of below pre-defined schema in SQL Server db_accessadmin db_backupoperator  db_datareader db_datawriter db_ddladmin db_denydatareader db_denydatawriter db_owner db_securityadmin can anyone...


SQL Server 2008 : SQL Server 2008 - General

Find patients ages 13 - 21 as of calendar year - I need to find patients who will be between the ages of 12 and 21 within a given calendar year....


Data Warehousing : Integration Services

Importing Variable length text files into SQL - Hi I regularly import a set of Windows text files into SQL. These files are a fixed length and the...


Database Design : Design Ideas and Questions

Is it a duplicate Index? - Dear Experts, Have a question about duplicate indexes . Is an Index considered duplicate if the two column keys (Index A with...

Column Length declaration - Dear Experts, On starting to design for a new project , I would like to know if its better to allocate double...


Career : Events

The SQL Saturday Thread - As popular as SQL Saturday is, I'm surprised that nobody created a thread dedicated to SQL Saturday, so I created...

This email has been sent to {user_email}. 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.
This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com