I used to read about technology to allow computers to track a single person's movements from video footage. We've seen this shown in Hollywood movies, where casinos can take a picture of a person and backtrack all their previous movements throughout the day. I have no idea if this is possible, but if it is, it's a scary proposition.
However in specialized, controlled circumstances, we can track people very well. The NBA (SportVU) is tracking all player's movements and gathering more data that can be analyzed to better evaluate player's performances. I expect in the next year or two, players will start to review this analysis and learn how to better adapt to the situations on the court.
The NFL is also starting to use sensors to track their players, but with different goals. They are monitoring workloads, trying to ensure the health and peak performance of players. It remains to be seen how else they might use this data, but in the linked article, there are perhaps more implications for us as data professionals.
Can you imagine more tracking data, for any movable object available? People, machinery, who knows what else will be tracked, and what else we might need to analyze. I thought spatial data had tremendous possibilities when I first saw it introduced in SQL Server 2005. However across the last decade I think we've barely scratched the surface of what location data might mean for applications, using it mostly for mapping locations and routes. If this data does become useful, that means that learning to aggregate, trace, and analyze location might just need to be a valuable, if not core, skill set for the DBA and developer in the future. If you want to get started, maybe run through this article on your system and see what you think.
SQL Doc quickly documents your entire database schema so that you can easily present it to others. "This tool is embarrassingly easy to use." David Hayden, DavidHayden.com. Download a free trial now.
26 free helpful monitoring ideas for SQL Server
Protect yourself from the most common causes of SQL Server pain, with this series of 26 free tips. Covers the hows and whys of monitoring, with practical advice and worked examples. Sign up now.
Want to use Git with your SQL Server database?
SQL Source Control now has built-in support for Git. Inside SQL Server Management Studio, you can commit to Git, push & pull changes from remote repositories, and get an object-level history for your database. Learn more.
The TL;DR on this is simple:
"BECAUSE IT'S SUPPOSED TO!"
A frequent complaint we receive comes from a client that has an... More »
Question of the Day
Today's Question (by Uwe Ricken):
You have a database with two tables. The table [dbo].[Customers] contain 75.000 records and the table [dbo].[Orders] has 1.000.000 orders stored. Both tables have a clustered index on the [ID] attribute and the table [dbo].[Orders] has a nonclustered index on the [customer_id] attribute. The indexes are definied as follows:
CREATE UNIQUE CLUSTERED INDEX ix_Customers_Id ON dbo.Customers (Id);
CREATE UNIQUE CLUSTERED INDEX ix_CustomerOrders_Id ON dbo.CustomerOrders (Id);
CREATE INDEX ix_CustomerOrderes_Customer_Id ON dbo.CustomerOrders (Customer_Id);
The following query will be executed and the execution plan comes out with a MERGE JOIN!
FROM dbo.CustomerOrders AS CO INNER JOIN dbo.Customers AS C
ON (CO.Customer_Id = C.Id);
The developer of the database has heard about QUERY HINTS and tries to manipulate the query by usage of these hints. The code changes to the following statement:
FROM dbo.CustomerOrders AS CO INNER MERGE JOIN dbo.Customers AS C
ON (CO.Customer_Id = C.Id)
What will happen to the query? How will the query performance react to the query hint?
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
3 points in this category: Query Optimization.
We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the
Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. The update's enhanced support of large-scale enterprise databases and significant price advantage mean that SQL Server 2014 will become even more widely adopted across the industry. The update includes new backup and recovery tools, new AlwaysOn features, and enhanced cloud capabilities. In-memory OLTP, Buffer Pool Extensions for SSDs, and a new Cardinality Estimator can improve functionality and smooth out the workflow, but only if you understand their full capabilities. Professional Microsoft SQL Server 2014 is your comprehensive guide to working with the new environment. Get your copy from Amazon today.
For APPLY operations, we are told that "The right input is evaluated for each row from the left input and the rows produced are combined for the final output. The list of columns produced by the APPLY operator is the set of columns in the left input followed by the list of columns returned by the right input."
Thus the left input must first be resolved. If you change the statements to reflect this , for example the following:
Database Administrators can sometimes have one of the most stressful jobs in the company.Hard work, dedication and commitment is the real key to success. In this article, I would like to demonstrate a simple way to minimize your stressful day when DBAs have a frequent deadline pressure with numerous projects in progress at given time and you need to build and maintain a SQL server in real world to meet your client commitments as client comes first. In our client environment we are using mount point (SAN LUNs).Our disk layout for SQL system databases and data (Primary and Secondary) files is RAID-5 and for user database Log files and System Temp database is RAID-1.SQL server quick quality check script works from version of SQL server 2005 to SQL server 2016 and can help you to check below 14 items when you build a SQL server in real world. SQL server name, Instance name, Current Date Time ,SQL version ,Error Log file location, server authenticaton,login auditing. Names of Members in SysAdmin role, Names of members in ServerAdmin, Temp DB File Location (mdf, ldf and ndf), Physical location of your system databases and application database(s). Also, It can give you information about SQL server instance Max server Memory(GB), Min server memory (GB) and Lock Pages in Memory. Our previous DBA's were spending around two hours to peer review the SQL server build manually. The script contributed to decrease the number of hours to minutes to peer review SQL server instances and helps to improve the overall quality of our SQL server builds.
SSIS Balanced Data Distributor Data Flow Component (Table Locking)
- I have a question regarding the Microsoft Balanced Data Distributor.
Does anyone have any insight into how SQL Server handles...
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.