 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | The Upgrade Storm The Perfect Storm is a movie about the confluence of three weather events that combined to create a situation the resulted in the loss of all life on a fishing boat. It's a good movie, and certainly one that might make anyone think twice about sailing off into the North Atlantic in bad weather. I certainly wouldn't want to be traveling on the water when any type of hurricane might present. Glen Berry writes about a perfect storm of a different sort. The perfect storm to upgrade, with the confluence of three events he sees taking place soon. We have quite a few performance related changes coming in Windows 2019 Server, in CPU hardware, and storage technology. Those three changes could dramatically improve the performance you might see from your SQL Server licenses. If you were planning on updating a legacy system with a new version of SQL Server, you might do well to consider some of these hardware and software improvements. I don't know what the costs might be, but that's certainly something you will have to consider for your environment. The argument likely would be that if you're updating the database server, why skimp? This is a limited resource and one that can affect your entire system. Spending some money here might make a significant difference to the way in which your system performs. This might be a perfect storm of a different sort for your budget and your accounting department as upgrades for SQL Server are likely to be pricey. The improvements could dramatically improve workloads by lowering the time users spend waiting or increasing the throughput of queries. Those might negate the cost of any hardware and software costs involved since time is a valuable resource and saving time is worth something. The problem for many people is that if you aren't writing good code, then you might not get the benefits you want from the upgrade. Certainly the performance improvements might be lost under poor query performance. Upgrade to take advantage of improvements if they are something you need, but please, learn to write better code, and ensure your developers are regularly looking for better ways to use your expensive SQL Server licenses by writing more efficient code. 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.2MB) 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 |  | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
|  | | 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 |
|
|
|
| | |  | Deepak Prasad Sahu from SQLServerCentral.com Determining the number of DTUs which will help in deciding the service tier for Azure SQL. More » |
 | In this article Phil Factor shows us how to surgically alter data from an entire database that can identify individuals but leave everything else intact. More » |
 | Additional Articles from SimpleTalk Testing your PowerShell scripts is just as important as testing any code. In this article, Robert Cain demonstrates how to use the testing tool, Pester, to perform unit, integration, and acceptance testing. More » |
 | Klaus Aschenbrenner from SQLServerCentral Blogs (Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the... More » |
| | Grant Fritchey from SQLServerCentral Blogs While all plans are estimated plans, there is still a difference between capturing an estimated plan and looking at a... More » |
|
|
| | | Today's Question (by Steve Jones): The first SELECT statement below returns 10 rows. What is returned by the second SELECT? SELECT top 10 * FROM dbo.UserConfig AS uc go SET IMPLICIT_TRANSACTIONS ON GO TRUNCATE TABLE dbo.UserConfig GO SELECT top 10 * FROM dbo.UserConfig AS uc |
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: SET Options. 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 |  Extract, Transform, and Load with SQL Server Integration Services: With Microsoft SQL Server, Oracle, and IBM DB2 Readers will learn by example how to use Microsoft SQL Server 2016 Integration Services (SSIS) as they design and implement extract, transform, and load (ETL) solutions to support a business application that integrates with a data warehouse and an online Web store across a heterogeneous system. This volume describes proven methods to support common ETL needs, such as databases communicating directly with each other, using files to exchange data, or performing database operations using Web services. 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 this code inside of the sample.py file. def TwiceThePrice(Price): Twice = Price * 2 print(Twice) I open a Python 3.5 REPL and import this file with this code: from sample import TwiceThePrice Now I edit the sample.py file in a text editor to add look like this: def TwiceThePrice(Price): Twice = Price * 2 print("$%d" % Twice) In the same REPL, I want to get the updated function definition with the dollar sign in the output. What should I do?
Answer: You need to type "from importlib import reload" and can then type "reload(sample)" to get the new function definition Explanation: The importlib module contains a function called reload() that will reload a module for you. Ref: Importlib - click here
» Discuss this question and answer on the forums |
|
|
| | | Damir Sprecic from SQLServerCentral.com This Procedure can compare two tables in different Databases on the same server. It supports the exclusion of unwanted columns with the @ExcludeColumn Option aswell as a SortOrder for the Output, if @Target* Parameters are not supplied, they're taken from the corresponding @Source* Parameter. Tested on SQL Server 2014 but should work from 2008 onwards. 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.
Has anyone seen this or have a link about it? (DBCC CHECKIDENT anomaly) - We have a busy table that I ran the following code against... DBCC CHECKIDENT
Error opening Visual Studio SQL Server Solution - Another user and I have the same exact version of Visual Studio but when they try to open a Solution... Changing SQL Server Service Account - Hi, Several of our SQL Server instances were installed and set up to run with a local account (NT Service\MSSQLSERVER). If... Maintenance Plan Backups - Ok, I have to ask a stupid question since I can't find it otherwise. The two database that SSRS uses,... SQL Server Availability Group - Adding Database to a Group - Hi All Quick question, we're migrating onto an infrastructure with SQL Server Availability groups, and we have one large database we'd... Question: Recover database with minimal data loss example question - Recover database with minimal data loss question Hope someone can help a bit. I've been going through some practice questions online for...
Converting XML in ntext field to columns/rows - Hi All, I've been working on this a few days and I'm stuck. I have field (I can't change) that is... Segregate data based on current and New Year - CREATE TABLE #TEMP( ID INT, S_DATE DATE NULL, E_DATE DATE NULL) INSERT INTO #TEMP VALUES (1,'01/01/2018','12/31/2018'), (1,'01/01/2019',NULL), (2,'01/01/2018','12/31/2018'), (2,'01/01/2019',NULL), (3,'01/01/2018','12/31/2018'), (4,'01/01/2019',NULL)
Audit In SQL Server - I need to save an audit trail of changes made to some tables. Could not find stored Procedure error - Hello, Using SQL Server 2014, Visual Studio 2015 and IIS 8.0.9, using Windows Authentication I'm at my wit's end with this issue... On-premises SQL server - adding secondary node to azure VM - Hi all, Am trying to figure out how to add a secondary replica always on to my on-premises SQL server, the...
Is there a better way to write a simple query? - This is pretty typical SQL Code for me: -- SET NOCOUNT ON added to prevent extra result sets from -- interfering...
Lots of ASYNC_NETWORK_IO for SQL Server 2012 - Dear Everyone I am not a performance expert so i needed help in resolving the following item. I ran the... Analytics/Reporting Software - Hello, Just wondering what Reporting/Analytics software everyone uses? I am looking to switched to Power BI but thought I 'd check...
Combine data from two tables - How can I combine all the dates from #VISITS to each provider in #PROVIDER? createtable #VISITS Insert trigger to run an ASPX script passing record columns as parameters - Hello! I am using SQL Server 2012 and my database is set to 'SQL Server 2000 (80)' compatibility level. I have a... HOW TO GET FIRST DATE - Dear all, I have data like: NAME SPONSOR_NAME DATE_OF_CALL A FI Multiple Join Behaviour - Hi guys, I've read 2 or 3 articles on Multiple Joins but I'm still failing to understand exactly what's happening...
Restore backup from SQL 2017 to SQL 2008 - Hi. There is a lot of post about my question, but I have little different problem. We have an SQL...
Tracking use of measures/dimensions - Hi, I have a SSAS multi-dim cube used by around 100 people. It's a legacy cube that I'm re-developing on SQL2016, has... |
|
| 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 |
|
|