Filegroup Restoring and Join Elimination (SQLServerCentral 8/10/2017)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Filegroup Restoring and Join Elimination]( - [SQL Server R Services: The Basics]( - [Automatically restarting Docker containers]( (From the SQLServerCentral Blogs) - [DevOPs is not just about the latest & greatest tools]( (From the SQLServerCentral Blogs) The Voice of the DBA Accelerating Your Career This post was originally published on Apr 23, 2013. It is being re-run as Steve is on vacation. I ran across [an article on ways to accelerate your career]( and for the most part I think these are good ideas and suggestions. Networking, finding a mentor, and more will help you no matter what business or field you are working. Some of the advice is geared towards those people looking to climb the corporate ladder and move into management, which is not necessarily what many of us want. If that's the case, ignore those items. There was one item, however, that I thought was particularly interesting for data professionals. The seventh item on the list notes that you should spend 10-15% of your time working on a project that's outside of the scope of your job or team. That might sound crazy, and even dangerous, but it's a good idea if your boss isn't opposed to it. Having knowledge about the way your business works, the way they use data, or solve a problem, could be valuable in your existing job. You might notice a pattern or way in which you could improve either your job or someone else's. Over time, helping in a variety of departments builds friendships, increases your networking, and might show your boss you deserve a raise. Many of us end up working with data as a widget. The job of a developer or DBA is writing code or managing data, and sometimes don't often think much about the actual industry in which we are working. Gaining deeper knowledge of the way your particular business works means you can better understand why you are asked to solve a particular problem. That knowledge can lead to a better solution. It might also make your job just a little more interesting. For the typical US worker, that's 4-6 hours a week. For the IT person, that might be a little more time, but I think it's worth the investment. I wouldn't be overly driven in this area, and if I were working on extra projects at work, I'd eliminate (or cut down) on the time I was spending learning new technologies. Life requires balance, and if you tackle something new in one area, make sure you know what you can give up. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( ADVERTISEMENT [SQL Compare]( The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. [Download your free trial]( [Database DevOps](www.red-gate.com/dlmdemo?utm_source=ssc&utm_medium=pubemailad&utm_content=devops-webinar&utm_campaign=databasedevops&utm_term=20170810-slot2) Database DevOps Demo Webinar Learn how to automate your database deployments alongside your app code in this free demo webinar. [Register now](www.red-gate.com/dlmdemo?utm_source=ssc&utm_medium=pubemailad&utm_content=devops-webinar&utm_campaign=databasedevops&utm_term=20170810-slot2) Featured Contents  [] [Filegroup Restoring and Join Elimination]( Bogdan SAHLEAN from [SQLServerCentral.com]() This article is just a short follow up of previous article on filegroup restoring that describes one issue with join elimination optimization.[More »]( ---------------------------------------------------------------  [] [SQL Server R Services: The Basics]( Additional Articles from [SimpleTalk]() It is possible to do a great deal with R within SQL Server, but it is best to start by doing analysis in R on numeric data from SQL Server and returning the results to SQL Server. There is great value to be gained even with this basic foundation. Robert Sheldon is on hand to give you a kick start with the first in his series on beginning with R in SQL Server.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Automatically restarting Docker containers]( Andrew Pruski from [SQLServerCentral Blogs]( One of the problems that I’ve encountered since moving my Dev/QA departments to using SQL Server within containers is that...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [DevOPs is not just about the latest & greatest tools]( hamish.watson8 from [SQLServerCentral Blogs]( I’m a technical guy. Thus – I love tools. They make stuff go. Tools are great. Except – as I wrote in my other post...[More »]( Question of the Day Today's Question (by Steve Jones): I want to create a new LocalDB instance on my machine called "SQLCI". What command should I use? 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: LocalDB. 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 [Exam Ref 70-768 Developing SQL Data Models]( tag=redgatsof-20 linkCode=as2 camp=1789 creative=9325 creativeASIN=1509305157) Prepare for Microsoft Exam 70-768–and help demonstrate your real-world mastery of Business Intelligence (BI) solutions development with SQL Server 2016 Analysis Services (SSAS), including modeling and queries. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. [Get your copy today from Amazon]( tag=redgatsof-20 linkCode=as2 camp=1789 creative=9325 creativeASIN=1509305157). tag=redgatsof-20 linkCode=as2 camp=1789 creative=9325 creativeASIN=1509305157 Yesterday's Question of the Day Yesterday's Question (by Steve Jones): I have this R code creating a vector. x However, I want a sum of these values and get this: > sum(x) [1] NA What can I do? Answer: Use "sum(x, na.rm = TRUE)" Explanation: There is a second parameter for the sum() function that is the na.rm parameter, and it defaults to false. This means include the NA values. If you set this to TRUE, it removes the NA values. Ref: SUM() - [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](. --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [Evaluating use of InMemory tables... Why is it slower than temp tables?]( - I created a table like this CREATE TABLE blahblahblah(  LeafLevelDatasetId INT NOT NULL IDENTITY(1, 1),  DateKey  INT NOT NULL,  SafeRegionKey ... [INFORMATION_SCHEMA views]( - Just curious, how many of you use the INFORMATION_SCHEMA views? Personally I prefer to use the DMVs like sys.tables, sys.columns,... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [SQL 2014 FAIL_PAGE_ALLOCATION 129]( - Hi, I migrated by DBs from SQL2008R2 to SQL2014 on a same server model: Phyiscal with 128 GB RAM. Since the migration,... [Stop SSMS providing the server name]( - Hello All, Can someone please advise if there is a way to stop SSMS providing the server name automatically in the... [Give access to users for certain data in the table or move that set of data to new table]( - Hi All, I have a question for the senior members to get a solution forthe below issue. Issue:  We have a database, and... --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [Getting rid of duplicate records]( - Hi All, I have a table that stores schedule events. One event can be scheduled more than one time in one... [Converting Hour and Minute to Decimal]( - Hello, I am having some issues converting time to decimal from one of my column which display it as 2014-07- 08:16:31.000 (datetimecreated) A... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [Transaction log full error]( - The database is in simple mode and when I try to shrink the log USE db1 [encryption key - always on failover]( - We have always on environment. Every time that we fail over one of the database, the encryption key must be open manually. The following... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Stored Procedure help]( - Hi guys, I have been asked to amend a stored procedure created by another colleague as it is not sending out... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 - General]( [Rolling back after Committing]( - Hi All, Is there a way to recover previous values after committing an update on a table , apart from recovery from... [Introduce rows for ROW_NUMBER Solution]( - Hi All, Thanks for any help I may receive as this is complex for me and am really struggle a best... [Need to setup a sql alert on “waiting tasks” - similar to “waiting tasks” in Activity Monitor]( - My manager has asked me to work upon a request. I am not sure if it is reasonable or weird... --------------------------------------------------------------- [Reporting Services]( : [Reporting Services]( [Allow Multple Values parameter - how to send an empty array]( - Hi, When adding a new parameter to report, there is an option Allow multiple values. If this option is checked, then the... --------------------------------------------------------------- [Programming]( : [General]( [How to convert varbinary to date]( - How to convert varbinary to date with time? I tried like this SELECT CONVERT(datetime2, 0xB490E37742DFD408); It doesn’t work [Anyone using Python?]( - This was brought up in the automate everything article, so I figured I start a new thread on the topic. Anyone... --------------------------------------------------------------- [Data Warehousing]( : [Integration Services]( [Using parameters in Execute SQL Task]( - Hmmm...how to best summarize this... I'm writing an SSDT package that: 1) Clones the table schema of a source table query to... --------------------------------------------------------------- [Data Warehousing]( : [Analysis Services]( [Create Dim from Existing Column of Single DSV into Tab Cube]( - Hello, I've got an SSIS pkg that loads data to SQL Server database from a single summarized table from Teradata,... --------------------------------------------------------------- [SQL Server 2005]( : [Administering]( [sql script to get a column count for every column in a table]( - I'm looking for a script that will do a count for every column in a table including the number of... --------------------------------------------------------------- [SQL Server and other platforms]( : [Oracle]( [sp_fkeys -- Oracle equivalent?]( - Does anyone know if Oracle has an equivalent of sp_fkeys? This email has been sent to {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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com