Parameter Fluid Optimization
Optimizer Studies I don’t have a real job, which means that if something strikes my fancy, like staring at a spot on the wall for an hour, I can do it. Occasionally things are a bit more inspired, and so I go poking around what SMRT PPL might be …
Avoid use of the MONEY and SMALLMONEY datatypes
One of SQL Prompt’s code analysis recommendations is that you avoid using the MONEY and SMALLMONEY datatypes – this article from Phil Factor explains why.
Navigating Hadoop Resources
Learn where to get the latest installation and learning resources for the ever-evolving components of Hadoop ecosystem and how those components may complement Microsoft SQL Server common everyday tasks.
SQL SERVER – Split Comma Separated Value String in a Column Using STRING_SPLIT
In this blog post, we will learn about STRING_SPLIT function which was earlier introduced in SQL Server 2016 but still not widely adopted in the industry. We will learn today how to Split Comma Separated Value String in a Column Using STRING_ …
Windows Disk Cleanup
One very useful tool for freeing up disk space is the built-in Disk Cleanup application in Windows. You can start this application by simply typing Disk Cleanup at your Windows Start menu. Once it starts, you will need to pick which drive you want to s …
Hey, That’s Not My Sort!
Understand Your Plan Mr. Optimizer does the rock n roll hoochie koo with Mrs. Optimizer, c. 1953. When reading query plans, you may sometimes see a sort when you didn’t explicitly ask for data to be sorted. Sometimes they show up to support order …
Scripting Objects with PowerShell
In the third installment of this series, Steve Jones uses PowerShell to source control code. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the r …
150 SQL Code Smells
Some time ago, Phil Factor wrote his booklet ‘SQL Code Smells’, collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there wer …
The future of database DevOps
In this post, Redgate’s Foundry team reflect on their assessment of the status of DevOps for the database. As well as giving you a behind-the-scenes look at how they’ve arrived at this thinking and setting out their future direction, they also invite y …
SQL SERVER – Fix Error: Invalid object name ‘STRING_SPLIT’
Just the other day one of the readers sent me following email after reading my earlier blog post: STRING_SPLIT Function Performance Comparison. He really liked the new feature of SQL Server 2016 and decided to start using this new feature. However, as …
SQL Server Diagnostic Information Queries for May 2018
This month, there are more minor updates to the SQL Server 2012 and newer versions of the queries, primarily in the comments and documentation. I have added some additional columns to many existing queries, and tried to get the newer versions uniformly …
Book Review: Inside SQL Server 6.5
Books Offline 30 years ago, back in 1988, Microsoft, Ashton-Tate, and Sybase got together to start building SQL Server 1.0 for OS/2. I wanted to take a trip down memory lane to celebrate, but I didn’t wanna go back quite that far. I wanted t …
Preventing Invalid Data Early In An ETL Flow
In this post, Tim Smith will look at some of the considerations for both data rules and logic to prevent invalid data early in the ETRL process.
Installing Machine Learning Services – Level 1 of the Stairway to ML Services
This first installment of the Stairway to Machine Learning Services explains the installation process for this subsystem in SQL Server. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis expl …
21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs – PASS Pre-Con 2018
Today, I am going to talk about my the most anticipated pre-conference 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs scheduled at PASS Summit 2018. This session is going to be amazing fun and very unique. It is full …