SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

Featured Script

The Voice of the DBA

Get What You Pay For?

Many items that we choose to buy have some relation between the price and the quality of the item. We often find that a more expensive appliance or automobile has better quality than a cheaper one. There's certainly a point at which spending more doesn't necessarily get you better quality or even value. This seems especially true today with many "over the top" products that have added features or design that don't seem to be worth the additional cost. At the other end, there are times many of us pay less for less quality, consciously making that tradeoff. I also think that the base level of quality has risen for so many products that it might not be worth spending more than some amount for an item. They're all close in value and performance.

I ran across a piece that looks at the value of consumer and enterprise SSDs. This isn't a scientific analysis, but rather a short discussion of why enterprise SSDs might be more than twice as expensive as consumer ones. There are some details, such as the architecture and spare capacity, but ultimately the author notes that people purchasing drives also worry about the perception that they might have saved money with a cheaper drive, but lost data because the warranty and support are lower. Even if the same hardware were being sold by the vendor, which I'm sure happens, having enterprise support is a crutch that can provide the employee some protection if there are issues.

There certainly are hardware differences for most devices, though the buyer should beware and verify that they are actually buying enterprise level gear. The big difference for me is that the large over provisioning of enterprise devices offers more predictable performance sustained over longer periods of time. This is important, especially for databases that might get quite a bit of transaction log or tempdb activity. In those cases, we need sustained high rates of I/O.

There are no shortage of white papers, articles, reviews, and vendor claims about their particular hardware. This is a very competitive and also highly profitably space. If you've had to purchase a new SAN device at any point, you know these are expensive and complex. Making the decision is stressful as it can take lots of time ot evalute, lots of resources to get things installed, and so it's not easy to go back on the purchase. In addition, many of us that have to make a recommendation are usually asking management to spend 6 or 7 figures on a device. If it doesn't perform, we will take the blame and may find our choice to be career limiting.

I don't envy anyone that needs to make hardware decisions for their database or organization. There are so many companies in the storage space now that it's a large project just to evaluate the various products and try to make a decision. It's complex enough these days that I can see why moving to the cloud is attractive for some. While we can't control everything and we may have large monthly bills, we typically don't ever have to face that extremely large capital purchase decision.

Steve Jones from SQLServerCentral.com

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

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 4.5MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

SQL Prompt

Become a more efficient SQL developer with SQL Prompt

Learn how to write SQL faster and more efficiently with these exclusive short videos from Data Platform MVPs and SQL Server experts. With SQL Prompt you can strip out the repetition of coding and write SQL 50% faster. Check out the tips

SQL Source Control

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


Docker SQL Server 2017 Linux Containers with database cloning

Paul Stanton from SQLServerCentral.com

Learn how containers can help with database development. More »


Script triggers from any database in SQL Server

Additional Articles from MSSQLTips.com

In this tip Aaron Bertrand looks at how to generate scripts for triggers using simple T-SQL statements. This tip shows how to easily build scripts for disabling, enabling, dropping and creating. More »


From the SQLServerCentral Blogs - dbachecks – Dark Mode Historical Validation PowerBi

Rob Sewell from SQLServerCentral Blogs

in my last post I showed how you can save the results of dbachecks to a database and created a... More »


From the SQLServerCentral Blogs - Azure PowerShell – List Virtual Machine Sizes

Bradley Schacht from SQLServerCentral Blogs

For those who use PowerShell to do things in Azure you will know that occasionally there is a parameter that... More »

Question of the Day

Today's Question (by Evgeny Garaev):

How can I use a Windows shared folder on a Linux server?

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 on Linux.

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


T-SQL Querying (Developer Reference)

Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

In Python, how are comments denoted?


  • Inline comments use # and comment to the end of the line
  • Multi-line comments start and end with ''' (triple quotes)


Inline comments use a hash mark, #, and will treat everything after this mark as a comment to the end of the line

Multiline comments use triple quotes at the start and end. Both single (''') and double (""") quotes work.

Ref: Python Comments - click here

» Discuss this question and answer on the forums

Featured Script

SQL Server All Indexes Script

Yusuf Kahveci from SQLServerCentral.com

With the script I have prepared, you will see the b-tree in our tables and the new index types where the ColumStore Indexes are and how much they are.
Most of your improvement work will also benefit your work.





More »

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

Fairly straightforward IF question - I do not do too much in the way of creating SQL code so please bear with this 20 year+...

Inner Joins - Hi Friends, I was wondering is there a Rule  of Thumb when I am  joining my tables as it relates...

SQL Server 2016 : SQL Server 2016 - Administration

restore/Attach not working as expected - To All, I have done many restores or attaches of db's and yet this particular one is not working as it...

SQL Server 2016 SP2 Issue with Analysis Services - All, please be aware that installing SQL Server 2016 SP2 may cause a problem with Analysis Services functions, most notably...

SQLOLEDB vs SQLNCLI11 - I am little confused. When i query sys.syservers i see provider name as 'SQLOLEDB' for some and 'SQLNCLI11' for some....

Regulary delete and rebuild of table influences perfomance? - Ahoi, Situation: i have a table with around 40 million rows and a clustered primary key set by IDENTITY(1,1). Theres regulary deletes and...

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

Lookups on remote database - SQL is not my primary language and I could use some insights into how to accomplish a task I need...

SQL Server 2012 : SQL 2012 - General

T-SQl, Help with the WHERE CLAUSE ( I want the entire records set as output or just the ones marked in 2 cols ) - My question is listed in the code. Declare @C CHAR(1); Select @C='1' IF OBJECT_ID('tempdb..#t') IS NOT NULL DROP TABLE #t; CREATE TABLE #t(...

SQL Server 2012 : SQL Server 2012 - T-SQL

Breaking up huge audit table (1.1B rows) into smaller tables - The AuditTable contains data from October, 2013 through current. We want to create: Audit2014Table Audit2015Table Audit2016Table Audit2017Table The field Transaction_time contains a date/time string YYYYMMDDHHMMSSSSS. We...

SQL Server 2008 : SQL Server 2008 - General

I need help getting last day of prior month in a view statement - so this is my code   CONVERT

SQL Server 2008 : SQL Server Newbies

detect if previous record is higher or lower ? - In it's simplest form if I had a table that stored a persons name, date that the record was entered,...

SQL Server 2008 : SQL Server 2008 High Availability

Replication - Missing Data in Subscribers - I have a strange issue going on intermittently with one of our SQL servers. The setup we have is: 1. 1...

Reporting Services : Reporting Services

Playing a sound from an SSRS Report - I have been tasked with trying to get a dashboard style SSRS report to play a sound. We have a report...

Programming : Powershell

How Do You Connect to a Central Management Server If Your Server is a Named Instance - I have the following code that worked on a default instance.  Now I am trying to get it to work...

Data Warehousing : Integration Services

Object variables, ADO Recordsets, & decrypting column - Ihope someone can help me out. My C# skills are nill, so I need a lot ofinformation. A bit of background:...

SQLServerCentral.com : SQLServerCentral.com Website Issues

Need simpler way to see a list of my posts and possible replies to them - Please excuse what might be an elementary question/suggestion but I am new to this forum.  After I log in,  there...

SQL Server 2005 : Administering

Cannot open tables in Database - Hello, I have SQL 2005 SP4 and cannot open the table on a specific database. When I execute: DBCC CHECKDB ('WSS_Content')...

SQL Server 2005 : SQL Server 2005 General Discussion

Ordinal Dates - Hi all, can someone show me how I can get the ordinal number of a date? If I am on...

SQL Server 7,2000 : General

QuickBooks to SQL Server - Does anyone have any ideas of ways to communicate between SQL Server and Quickbooks?  I have found a couple of...

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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com