| A community of more than 1,600,000 database professionals and growing |
| | | Super Nerds I enjoy the game of baseball, playing as a kid and then for a decade as a 40 year old adult. I gave it up a few years ago, worried about the wear and tear of sporadic play. I'm happy now coaching kids and participating in individual sports for exercise, but I still love the game. A few years back I read the book, Moneyball. The book is about the use of metrics and analysis in addition to the human scouting evaluation in the Oakland As organization. There was a movie made as well, and both are worth consuming. Since that time, other baseball teams have adopted some of the ideas, and I've been hearing that both basketball, NFL football, and other sports in the US are using more metrics. There's even a Revisionist History episode that talks about football/soccer and the way that makes the most sense to improve your team. Recently I ran across an article with a great headline: Jayson Werth rails against 'super nerds' that are 'killing the game'. In the article, a player rants about the way in which data and statistics are being used to make decisions. Instead of allowing players to just play, analytics become a part of the decision to play a certain way. For example, bunting and stealing have dramatically declined, mainly do to the analytics that show these are lower percentage actions compared to other choices. It's interesting to hear players rant against the user of statistics. I completely get the annoyance at losing control of your choices, and certainly appreciate that the game becomes less exciting at times. However, I also know that players, and even coaches, may make emotional decisions, or base decisions on poor information. Most of us humans can't remember all the tendencies and likelihoods. In a modern world where skill levels have dramatically increased in many ways, there are often better ways to build a strategy. Data is valuable, and certainly can help in sports. It isn't the end-all be-all, and it can be misleading when applied to individual humans. At the professional level, where more data is available, I think it makes sense to use data more as a significant part of your decisions, though not the only factors. For me, as a coach of younger kids where I have relatively little data, I still use the eye-test for most things, relying on data to double check my thoughts. The world moves fast, and it can be easy to forget how individual players have performed across an event, especially when I'm trying to manage the game as well. Data helps me remember how the day is going. 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 ( 5.1MB) 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 | | | | CI/CD for your SQL Server database Feeling the pain of managing and deploying database changes manually? Redgate SQL Change Automation completes your database delivery process by building, testing, and deploying the database changes you and your team check into version control.
Try it free |
| |
|
|
| | | | | Additional Articles from Database Journal When you are setting up a new SQL Server machine you need to determine how big you should make tempdb. To make sure you size tempdb appropriately you should monitor the tempdb space usage. If there are autogrowth events occurring after you have recycled SQL Server than you might want to increase the size of your tempdb data files. If tempdb never uses most of the tempdb space, then you might want to consider decreasing the size of tempdb. More » |
| | Our all-star speaker line-up of Microsoft MVPs and Redgate team members will be running sessions on the theme ‘Adapt and thrive as a data professional’. More » |
| | James Serra from SQLServerCentral Blogs Dataflows, previously called Common Data Service for Analytics as well as Datapools, will be in preview soon and I wanted... More » |
| | Devin Knight from SQLServerCentral Blogs In this module you will learn how to use the Overview by CloudScope. The Overview by CloudScope show a list... More » |
|
|
| | | Today's Question (by Steve Jones): What is returned from this code: DECLARE @SomeVar DECIMAL(10,4) = -2.5 SELECT ROUND(@SomeVar,0,1) |
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: ROUND(). 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 | Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload. Pick up your copy of this great book today at Amazon today. |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have some input strings that I want to use to create SQL Server columns. I want to be sure these are valid identifier strings, so I decide to use the QUOTENAME() function. With this function. By default, when I run this as shown below, what are the changes to my input string? SELECT QUOTENAME(@SomeVar)
Answer: The value of @Somevar is returned, surrounded by brackets Explanation: By default, if I use QUOTENAME() with a single parameter, the value of the input parameter is surrounded by brackets. You can see this in this code: DECLARE @SomeVar VARCHAR(20) = 'This is a test'; SELECT QUOTENAME(@SomeVar) Ref: QUOTENAME - 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. ADDING FIELDS WITH A SELECT STATEMENT - Can someone kindly help me with the query below: SELECT 1 AS ID, '1 Field, COALESCE(SUM(Field1)/1000,'0.0') AS Field FROM Table WHERE Condition='Money' and SecondCondition... Double Hop - Again - Morning Guys, I am trying to solve the dreaded double-hop issue, whereby I have an SSIS Package on one server that... SQL Server 2016 - Catching Up Since SQL Server 2008R2 - We are moving from SQL 2008R2 to 2016 and needless to say I'm not up to date with the changes... How much RAM required to server - How much RAM required to server having 15-20 Million records, on which insert and update operations are executed. How to calculate... Import MIllion rows into Excel - Hi Team, I am trying to copy 2 million + rows from sql server Grid view to Excel spreadsheet.Its not allowing me... Invalid Metadata/Precision error - I'm writing a query and getting this error. I've written other queries on the same database but not his specific... Joins clarification - Let's say I have Table A and Table B. Table A can join onto Table B because both tables have a... Transactional Replication - Inserting Duplicate Keys - Hi All This seems like a strange one to me. We added a few new articles into a publication yesterday, and... Need Help -- Views - SQL Server 2014 Enterprise Edition 64 bit Windows Server 2012 R2 Enterprise Edition 64 bit There are two databases A and B.... Procedure Result taking more time - Below stored procedure taking more time(1 minute 56 seconds) for completing the execution.First table PDF_MSDS only having more records compare... Copy all objects (tables, views, functions, stored procedures) from one DB to another DB - I need to copy some selected objects (tables, views, functions, stored procedures) from one DB (Order) to another DB (OrderHistory) Which... Select a value based on sequence number - There is a table in which there are two columns, sequesenum and color. The data like below Seq---Color 1-------Red 2-------Yellow ... 120----Green How to code to always... Enable Logging of both failed and successful logins on Linux - Anyone seen how you do this? On a Windows Environment you can just do this via the Server Properties Window,... Prevent duplicates in a table - I am entering 'salaries' information into a sql server table called 'salaries'. Fields are : id (pk,identity),c_id (int),month,year,salary. I use a stored procedure... Non Clustered Index on Phone column - Dear All, I have a Lead table with below fields. LeadId int (Not a primary key) Telephone ... ...Table have 4 millions records Client always search the... conditional update query syntax - I have a question about the syntax of an update query. Here is my layout and what I need to... Annoying error message 'Cannot drop table because table does not exist' in ExecuteSQL Task BIDS 2008. - It happens even though I include IF EXISTS statement before before Drop Table. IF EXISTS (SELECT Name from sys.objects WHERE object_id... How to a use a temp table as a destination for a dataflow in SSIS - I need to use data from one server to update a table on another server. For reasons of GDPR compliance... Backup failuer with error 3132. - has anyone come across this error and any solution : Msg 3132, Level 16, State 1, Line 1 The media set has... I/O error 170(The requested resource is in use.) - Hi all I have some problems with one environment.. It was a virtual cluster active/passive with 2 virtual nodes and virtual disk... |
|
| 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. | This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
