 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | Wasted Work I've been re-reading some of the manufacturing and DevOps books that I've collected over the years. In these texts, there are a number of concepts that stand out, but one that resonates with me is the concept of waste. There's actually a good article on LinkedIn about waste that's worth reading as well. While it's easy to start spinning in circles and thinking everything is waste around you, step back and keep some perspective that some waste is inevitable because the world is messy. Don't get too caught up in waste, but try to reduce waste where you can. One of the areas that I think contains a lot of waste in software development is the effort to build features that won't be used. Like many of you, I have been asked for no shortage of changes to software in the past. Often those changes require both application and database changes, usually to support a new way of conducting business. The interesting thing to me is that often I'll work my through a queue and get changes completed, a percentage of which rarely, or even never, get used. What seemed like a good idea when it was requested, specified, and scheduled may not be a good idea weeks or months later. In other cases the latest request is labeled as important and needing to be completed ASAP. This might displace older work, perhaps even pushing it to the lowest priority level where it may never get completed. That's fine, as if the work isn't important enough to be pushed by someone, perhaps it isn't needed. To me, this is one of the advantages of working in a DevOps style flow, with small changes being developed and released. If clients start to use the feature and need additional development, we can continue to enhance the feature. If the users don't use it, which we know from either future requests or instrumentation (the latter is preferred), then we can put more effort into the areas that are more important to our organization. With less waste. We don't work on large projects to completion, wasting work on the parts of projects that will not be used. Instead, we complete small parts and keep shifting our focus to the areas that are most important to clients. 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 ( 4.7MB) 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 |  | | The 4 pillars of SQL Server Monitoring 5 SQL Server experts; Grant Fritchey, Rodney Landrum, Kathi Kellenberger, Phil Factor and Tony Davis, use their many years of experience working and maintaining data systems to explain the 4 key strategies required for a successful, estate-wide monitoring solution. Download your free copy now |
|  | | Write, format, analyze, and refactor SQL fast with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. Download your free trial |
|
|
|
| | |  | Hugo Kornelis from SQLServerCentral.com This stairway series was started in 2015. As such, the focus was on SQL Server 2012 and SQL Server 2014 only. When SQL Server 2016 was released, with lots of improvements in the columnstore technology, I decided to finish the planned levels with the original focus on SQL Server 2012 and 2014, and add one extra level with a brief overview of the improvements available in SQL Server 2016. More » |
 | Press Release from Redgate Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege. More » |
 | Additional Articles from MSSQLTips.com In this tip we look at a simple way to import a simple XML document into a SQL Server table. More » |
 | Grant Fritchey from SQLServerCentral Blogs I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn’t... More » |
| | Rayis Imayev from SQLServerCentral Blogs (2018-Oct-29) There are only a few sentences in the official Microsoft web page that describe newly introduced activity task (Append Variable)... More » |
|
|
| | | Today's Question (by ben.brown 83879): I have created a few tables: CREATE TABLE table_a (id CHAR(1)) ; GO INSERT Table_a (id) VALUES ('A'), ('B'), ('C') ; GO CREATE TABLE table_b (id CHAR(1)) ; GO INSERT Table_b (id) VALUES ('A'), ('B') ; GO CREATE TABLE table_c (id CHAR(1)) ; GO INSERT Table_c (id) VALUES ('A') ; GO I then run this query: SELECT RCOUNT = COUNT(*) FROM TABLE_A LEFT JOIN TABLE_B ON TABLE_A.ID = TABLE_B.ID INNER JOIN TABLE_C ON TABLE_B.ID = TABLE_C.ID ; What is returned for RCOUNT? |
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 2 points in this category: T-SQL. 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-765 Provisioning SQL Databases Prepare for Microsoft Exam 70-765–and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. 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 from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have some data in a SQL Server 2016 database and table that was compressed with the COMPRESS() function. What function will return the original text to me from the table if I use it instead of the xxx below? select xxx(LogMessage) from dbo.Logger
Answer: DECOMPRESS Explanation: The opposite function from COMPRES is DECOMPRESS. Ref: DECOMPRESS() - click here
» Discuss this question and answer on the forums |
|
|
| | | Bernabe Diaz from SQLServerCentral.com "The Invoice Report and Confirmation of Payment Report contain monetary fields formatted with over-punch characters, or Extended Binary Coded Decimal Interchange Code (EBCDIC)." "00000000035A (In the example to the left the A converts to the number one (1) making the number 351. Because this is a monetary field and the decimal is implied the true monetary value is $3.51. The number is considered positive because the letter A falls under the “Signed Positive” column (see chart below). " -- INTERNAL REPRESENTATION OF OVERPUNCH SIGNS -- POSITIVE A B C D E F G H I { -- Numeric value 1 2 3 4 5 6 7 8 9 0 -- NEGATIVE J K L M N O P Q R } SELECT CAST([dbo].[udf_OverPunchConversion]('00000000035A') AS MONEY) Result: 3.51 SELECT CAST([dbo].[udf_OverPunchConversion]('06-000000000{') AS MONEY) Result: 0.00 Enjoy! 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.
conversion of a varchar data type to a datetime data type resulted in an out-of-range value - So my query looks like this below. When i put @month as 11 it works fine and gives 2019-01. but... Using SUM() In CASE Statement / Best Practices - All, I'm working on building a semantic layer within an ETL database so as to improve our end to end performance.... how to get rows from two datetime fields with hours on morning time. - I have this problem How can I get rows in this example. We are looking for crimes in our database... get qtr,month and year from start date - I have start date column. how can i get rest of 4 columns of attached file. financial year begins from... Insert Date from integer month and year columns in the same table - Hi, Please consider the following tables. Invoices are issued when products are sent to customer. for each customer could be one... Speed of SSIS execution much slower in package execution as step( "Execute Package Tasks") compare to single package execution - Hi, I am creating data migration scenario for SQL 2017 I need to load 160 GB from ~250 tables Server A database...
log shipping got broken - Good Morning Experts, a quick question: I have log shipping set up. Junior dba took log backups and now log shipping... copy missing files from sub-folders - Hello, I have a procedure that copy files from server to another server. Source - \\ServerSource\u Destination - Z:\output\ All the relevant files at the source...
While Loop Stored Procedure - Hi, Can help me with an issue I am facing. I need to create a single stored procedure that uses the... Purchase Order query help - Hello Experts, Needed some help with a query, the requirement is to identify an Item that is getting ordered but not... File could not be opened - So I am a bit baffled. We have a process that we're moving from one SQL Server instance to another,... Execute a Stored Procedure against every row insert in Table - I have around 200 tables and we have insert in each table with in each seconds. so there are around 90...
Recursive CTE for Supervisor Hierarchy WITH Effective Date of Reporting Relationship - Updated with DDL and Sample Data - Okay, I'm editing my request per Lynn's suggestion. Below, in the comments, I'm posting the DDL to generate the sample...
Aggregate without self join - I am fetching the number of clicks and first click from number of devices using event table and click table. [code...
Converting delimiter - Is there a way to change a comma delimited file to pipe delimited using a script? Thanks. Write Conflict - Hi all, So this issue is driving me bat guano insane. I have MS Access linked to SQL tables. 1. There is... How can I get a set Date and Time Range between Yesterday and Today? - Hello, I am looking to create a query that will get data between Yesterday at 6AM until 1AM today. Is there...
Set Maxdop = 8 and cost threshold for paralelism = 15 - Hi all, I recently changed CTFP=15 on my producion server. Why I use that number and not the 50 rule of...
AzCopy how to impove speed ? - Hi, I need to transfer file ~40 GB backup file with maximum speed from office to azure blob AzCopy /Source:F:\BACKUP\SQL_backup_2018_10_26_23.bak /Dest:https://myblob01.blob.core.windows.net/sqltest/SQL_backup_2018_10_26_23.bak /DestSAS:"?sv=2017-11-09&ss=somevalues" Finished...
Script out permissions - Azure SQL database - Hi Folks, Any one has a script to script out user permissions from Azure SQL database? I was not able to... |
|
| 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] |
|
|