| A community of more than 1,600,000 database professionals and growing |
| | | Too Much Information for Sports Many of us deal with lots of data and information, sometimes conflating the two when they are really separate things. Our jobs usually revolve around somehow helping others to extract useful value from the data we store in some way. This could be with reports, or with transfers to another system, or even a simple explanation of what data in a column means from a business perspective. Like many industries, pro sports have been using more and more data to help them better manage their business. This was popularized with Moneyball, a book (and movie) about baseball. Since this time, plenty of other teams across many sports have started think about data analytics. The NBA gathers lots of data for each team, even making some available publicly (including spatial shot data). The NFL uses lots of sensors, and more sports, especially Olympic sports, are gathering data to help athletes perform better and learn more about the impact of their decisions. However, more data isn't necessarily what makes decisions on the field of play. There was a great quote from Doug Baldwin, an American Football player for the Seattle Seahawks. In looking at all the data collected, he noted this: “Yes, the data and information is useful, and give it all to me. But at the end of the day, the user has to use it the right way.” That's a great quote, especially considering the owner of his team is Paul Allen, founder of Microsoft. More data doesn't necessarily solve a problem, tell you what to do, or how to do it. Instead, data analytics and analysis is still a bit of an art with some science behind it. Data matters, but when we reduce a problem to a simple set of statistics, we can be missing the subtleties of the actual situation. I wouldn't think most industries could do without data gathering and analysis, but people still need to be involved and work with the bits and bytes. Whether you're in sports or business or some other area, it's important to use data, but don't discount the human factor in applying experience and understanding to extracting information from that data. 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.5MB) podcast or subscribe to the feed at iTunes and Mevio . The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com. |
|
|
|
| | ADVERTISEMENT | | | | Join SQL Clone early access program Redgate’s building a new tool to enable rapid SQL Server provisioning, while safeguarding your data and making efficient use of disk space. SQL Clone takes the pain out of creating and managing multiple copies of production databases, helping you and your team deliver new features and upgrades fast. Join the early access program to try the latest release. Join now. |
| | | | Want a SQL comparison tool you can trust? 71% of Fortune 100 companies use SQL Compare. They save time comparing and deploying SQL Server database schemas, create error-free deployment scripts in minutes, and fix errors caused by database differences with ease. Find out how with a free trial. |
| | | | Track schema changes for free DLM Dashboard tracks SQL Server databases to show you exactly what schema changes have been made, by who, and when. You get a full history, with line-by-line differences, and a clear audit trail of your database moving from development to production. Download free tool. |
|
|
|
| | | | | David Poole from SQLServerCentral.com Producing a crib sheet for data quality drives a shared understanding of the data used to power the business. More » |
| | Additional Articles from SimpleTalk React is a front-end user interface library developed by Facebook, originally to help them improve their own site. Since then it has grown into somewhat of a phenomenon, with many active users. In this article, Jon Smith provides multiple examples of how to use React with recently released ASP.NET Core MVC, and the existing ASP.NET MVC5 framework. More » |
| | Hemantgiri S. Goswami from SQLServerCentral Blogs SQL Server 2016 comes up with the new release of Master Data Services (MDS). In it, some new features have... More » |
| | Grant Fritchey from SQLServerCentral Blogs Blog post #7 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here. Sooner or later when you’re working... More » |
|
|
| | | Today's Question (by Steve Jones): What are the initial default size and growth for tempdb data files in a new SQL Server 2016 instance installation? (choose 2) |
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: tempdb. 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 Kenneth Fisher): What is the result of the following code? BEGIN TRAN INSERT INTO tbl VALUES ( REPLICATE('a',5000) ) GO 100 COMMIT GO Answer: 100 rows in tbl, 99 open transactions Explanation: The first thing to look at is the GO statement. GO is a batch separator, it's not actually part of T-SQL. You can specify a number after the word GO and that is how many times the batch will run. The important part here is what is considered a "batch". A batch is all of the lines of code run, up to the previous "GO" statement or the beginning of the code run if no previous GO exists. So in this case both the BEGIN TRANSACTION and the INSERT statement will be run 100 times. Because the BEGIN TRAN statement is run 100 times we are dealing with Nested Transactions. At the end of the 100 runs of the batch we have 100 rows in the table and 100 transactions. The COMMIT statement however only commits the innermost transaction. Leaving us with 100 rows in the table, but 99 open transactions. You can add SELECT @@trancount at the end to confirm this. Ref: See links in the explanation. » Discuss this question and answer on the forums |
|
|
| | | | Gaby Abed from SQLServerCentral.com Lovingly modified from example D in the world famous dm_db_index_physical_stats books online entry. By putting the script in an query that can be executed, it lets me pass database names to it, without having to create the proc in each DB. Feel free to play with the defaults, but these seem to work for us. Because these are very critical online systems, I have decided to keep the ONLINE=ON setting by default. But because there are tables that may have column types that can't be built online, such as text or XML, then a TRY/CATCH block switches it to OFF. 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. I nedd code to purge or clear sql server logs (current) not database logs - I nedd code to purge or clear sql server logs (current) not database logs T-SQL formatting tool - Does anyone know of a t-sql formatting tool that is compatible with SSMS 2016 and will format BACKUP/RESTORE statements? I've got... 64KB disk formatted vs 4KB disk formatted - Hi everyone ! Here is an interesting test I would like to share with you. I was given the SQL Servers few... HeartBeat Failure - Hi Experts, We are observing frequent heartbeat failure in cluster logs and the RCA is found to be network issue. 1.When this... I nEED backup query to backup to disk but - no for all. only for speicifiec db . and remove old bak until 14 days thanks SQL SERVER 2012 NDF, delete - Hola estimados, les comento el problema que tengo, tengo una base de datos en la cual la separaron en archivos... GET MAX VALUE - Hello, I need some assistance with a code. I am trying to return the APPL_CURRENT_STATUS where the APPL_CURRENT_STATUS_DATE is the... Checking if a string value includes a value from a field - Morning all, Please could someone advise me on the correct syntax for highlighting if an email address includes a year of... Using variables with the LIKE operator - PcsAssmntDataID is part of a clustered index and is made up of a "VisitID" and a mnemonic. The VisitID are... Very generic question - Hi all, I have a very generic question which may sound stupid but very important to me. I'm going to... CXPacket Wait on long running query - Hi, i'm noticing, what I believe is, an interesting issue on one of my SQL Server. I am running stored proc... Stored procedures and Creating tables. (Problem). - Hello All, In a single store procedure I often have a number of functions: Initialize, Prepare something (for example the creation of a... How to calculate YTD from Given From date ? - Hi Friends, I have a table like Custmer bill Date location Bill_value 102 01-04-2011 A 12 102 05-04-2011 A 16 102... upgrading from 2008r2 to 22014 questions - Hi, How do you determine of SQL Server 2008 I am on so I can get the same level at 20014... Missing Parameter - Hi, I am having a problem with SSRS giving me the following error. The 'startdate' parameter is missing a value This param in... Easy piece of code just doesnt bloody work. - Sounds like a headline from the onion. All I want to do is add a new database role to a database... SSIS 2012 loading date in format YYYYDDD from file - Hi I am trying to load a file into a table and can not get my head around this one. The File... Conversion failed when converting from a character string to uniqueidentifier - The more I read about this the more confused I get. We keep getting the following error: Error Executing the query "exec Ins_activity_table... Temp Table 'vs' Table Variable 'vs' CTE. - Hi All, I wants to clear my concept about Temp Table, Table Variable & Common Table Expression Concept. Can anybody please clear me... 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 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 ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
