| A community of more than 1,600,000 database professionals and growing |
| | | Hard Drive Reliability Do any of you still use hard drives? I'm sure some of you do, and I'm also sure plenty of you aren't sure if you're using HDDs or SSDs. For some of us, the hardware is just a set of resources with a certain quantity, capacity and performance. While we used to spec, purchase, and assemble database servers in the past, these days may of us just specify cores, RAM, and IOPs or some storage capacity, not worrying about how our resources are actually implemented. I know that I assume SQLServerCentral is using SSDs in our hosted systems, but I honestly don't know, much less care about the type of drives in use. I saw Backblaze release their 2018 hard drive stats recently, looking at the reliability of their storage. Since BackBlaze is in the business of storing data, they need to ensure that they have quality storage. I'm a customer, and I appreciate that they're not just buying and using devices, but also tracking how well the different brands and models work. Since they have over 100,000 drives, this means they can provide some interesting information on reliability. As our storage needs grow, many of us won't use SSDs for all our data. Even all the data in our database servers might not be SSD as the cost is high. I'm sure HDDs are well suited for backups, and potentially even still useful in many servers for data storage when workloads might not be as high. Even at home, I like to use SSDs as much as possible, but for some types of storage, especially pictures, audio, and video, HDDs are much more cost effective with their higher density. The Backblaze stats are interesting in a few ways. Certainly it's amazing to see how larger and smaller drives perform. It seems that most drives have a very low failure rate, though there is an order of magnitude difference between different models of similar sizes. It doesn't seem that the 10-14TB drives are worse than the 4TB drives, which makes me think that vendors are doing a great job with quality control in manufacturing. I used to worry about larger sizes being released and having lower reliability, but this doesn't seem to be the case. Some drives have very low failures, but these are averages, so I'm not sure they're necessarily better, but worth keeping an eye on. I also think that since many of these drives fail at < 1% annualized rate, they're good choices for your data center. Certainly the HGST ones seem to have very low failure rates. I know I may pick up a couple of these for more photo storage as I'm running out. It seems that I never have enough space for all the pictures I take. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.6MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps With SQL Provisions virtual cloning technology, databases can be created in seconds using just 1MB of storage, and sensitive data can be anonymized or replaced with realistic data to ensure it is protected as it moves between environments. Download your free trial |
| | | | The importance of monitoring your Azure SQL Database Wednesday March 6, 15.00-16.00 GMT / 10.00-11.00 CDT - Monitoring Azure SQL Database is still a necessary part of understanding how your system is behaving and ensures that you have the information needed to make necessary decisions about your databases in a timely and accurate manner.
Register now |
|
|
|
| | | | | Luis Martin from SQLServerCentral.com Although computed columns are from the beginning of SQL Server, not everyone knows how to use them. This article will help you better understand how it works. More » |
| | Phil Factor explains what causes this issue, the problems it will cause and how to avoid the problem More » |
| | Additional Articles from MSSQLTips.com In this tip we look at some things you should think about when planning for a SQL Server data warehouse. More » |
| | Justin Figg from SQLServerCentral Blogs With the release of SQL Server Always on came the ability to query replica’s and offload read only requests. This... More » |
| | Kenneth Fisher from SQLServerCentral Blogs Of the different basic types of backups (full, differential and log) I find the differential the most interesting, and frequently... More » |
|
|
| | | Today's Question (by Steve Jones): What types of indexes can be on a memory-optimized table? |
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: Memory Optimized Tables. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| | Yesterday's Question of the Day |
| Yesterday's Question (by Thomas Franz): What will the last select return in the column [i] for txt in ('e', 'f')? CREATE TABLE dbo.ident (i int IDENTITY, txt VARCHAR(100)); go INSERT INTO dbo.ident (txt) VALUES ('a'), ('b') go SELECT * FROM dbo.ident AS i -- returns 1 a / 2 b GO SET IDENTITY_INSERT dbo.ident ON GO INSERT INTO dbo.ident (i, txt) VALUES (103, 'c'), (104, 'd') GO SELECT * FROM dbo.ident AS i -- returns 1 a / 2 b / 103 c / 104 d GO DELETE dbo.ident WHERE i = 104 GO SET IDENTITY_INSERT dbo.ident OFF GO INSERT INTO dbo.ident (txt) VALUES ('e'), ('f') GO SELECT * FROM dbo.ident AS i GO DROP TABLE IF EXISTS dbo.ident
Answer: 105 / 106 Explanation: While IDENTITY_INSERT is ON the SQL Server "tracks" the inserted values and sets the seed to the highest inserted value. So although we deleted the row with i = 104 (while IDENTITY_INSERT is still ON) it does not reuse this value nor does it use / fill the gap between 3 and 102. Ref: Identity Property - 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. Current Date to Week Start Date - I need the the start date if the week given a date and which day starts a week. Here is... SQL Script - Hi All, Could you please help me in get the script for below scenario: Table Creation and Insertion: CREATE TABLE .( (50) NULL, ... Multilayer Hierarchy - I have a need to store hierarchy data where the nodes are punctuated with fixed data. As an example I... How should I reserve a set of "next numbers"? - I'm working with a 3rd party database where rows in each table are given a surrogate key (integer) by calling... Generate SQL-script that creates all logins with appropriate permissions - Hi, colleges. How can I create a script that contains information for creation all SQL-logins including database users with all permissions? It'll... Bulk Insert - tracking - How can I query for when a bulk insert was started, ended and record count inserted ? I have searched the... Columnstore Indexes - do we need to perform any maintenance on them? - Hi all Our devs are about to implement columnstore indexes on a couple of their DBs. I've been thinking about what... How to execute sql agent job using wildcard? - Hi experts, How to execute an sql angent job using wildcard? From this: EXEC MSDB.dbo.sp_start_job @Job_Name = 'JobName' To This: EXEC MSDB.dbo.sp_start_job... Odd issue, DBA says due to parameter sniffing, could use advice, please... - I manage this 1 data warehouse company (an Active Directory snapshot data warehouse), approx. 40M rows of data total, 1 app that... Multiple Filegroups vs. Multiple Databases for better Performance - Hi, I need to add some new tables to an existing database which will have: 1 - much more read/write operations than the... Updates and not requiring a parameter - CREATE PROCEDURE . @TableId int, @StartDttm datetime = NULL, as UPDATE Sort already comma separated list - Hi I have values like this in a column which basically is the exact same thing if sorted . ORM; Database Corruption - Got the below error on our database on day 1 Msg 8992, Level 16, State 1, Line 1 Check Catalog Msg 3851,... Copy Backup File - Hi Experts, We have backup job taken every 20 mins(trn) every 1 hour(diff) and weekly full. These backups are taken to... FOR XML - Remove attributes from FOR XML EXPLICIT - My SQL outputs the following XML with attributes: <Order_Notification Level="x"> <Order_Company Level="y2"> <Order Level="z3" /> </Order_Company> </Order_Notification> However I need to output it... control order of execution within a stored procedure? - I have problem where a stored procedure is daily executed as part of an SSRS subscription, but the last of... How to unpivot columns dynamically using SQL server 2014 - Data in SQL table is SSIS Expressions Question - Syntax help - Take a look at the attached pic @ + @ The value in the variable @ = "MEDICIAD_YYYYMMDD_HHMM.txt" What I need from you is... Find and replace third occurrence of the string - I want to find the third occurrence of the 'o' and replace with 'A' create table store ( productid int, productdescription... How to read list of files in folder using T-SQL? - Does anyone know how to read files from spesific folder/path using T-SQL? Regards, Eko Indriyawan |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | 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: [email protected] |
|
|
