UNION ALL Optimization
Paul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL queries in SQL Server.
2017-06-13
5,896 reads
Additional Articles
Guide to enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform
A new whitepaper published today gives Microsoft SQL customers technical guidance for how to approach GDPR compliance with Microsoft SQL technologies.
2017-06-12
5,192 reads
Scala and Apache Spark in Tandem as a Next-Generation ETL Framework
Scala and Apache Spark might seem an unlikely medium for implementing an ETL process, but there are reasons for considering it as an alternative. After all, many Big Data solutions are ideally suited to the preparation of data for input into a relational database, and Scala is a well thought-out and expressive language. Krzysztof Stanaszek describes some of the advantages and disadvantages of a scala-based approach to implementing and testing an ETL solution.
2017-06-12
4,658 reads
Statistics in SQL: Pearson’s Correlation
Some people will assure you that you can't do any serious statistical calculations in SQL. In the first of a series of articles, Phil factor aims to prove them wrong by explaining how easy it is to calculate Pearson's Product Moment Correlation.
2017-06-09
4,713 reads
How to partition data in Tabular SSAS
Partitioning data is a standard SQL Server administration practice. Partitions enable independent administration of different slices of data. When a SQL Server Analysis Services (SSAS) tabular data model is developed and processed, data is read from the source system and loaded into the tabular data model configured in In-Memory processing mode. Every time the model is processed, the entire data set may not require re-processing. Only certain slices of data containing changes may require re-processing which can be achieved by partitioning data into logical slices. In this post, Siddharth Mehta looks at how to partition tables in Tabular SSAS.
2017-06-08
2,832 reads
Comparing SSIS Catalog Contents Using DBFit Framework
When you are doing the rapid deployment of an updated SSIS project, there are a number of things you have to check to make sure that the deployment will be successful. These will include such settings as the values in environment variables, Package parameters and project parameters. The DbFit test framework turns out to be ideal for the purpose of doing final checks as part of a deployment process, as Nat Sundar demonstrates.
2017-06-07
3,586 reads
How to style your SQL using SQL Prompt’s new formatting options
Prefer tabs but your teammates use spaces? That's not a problem with the brand new formatting options in SQL Prompt. It's now possible to customize, save, and share multiple styles that you can then quickly switch between when working. Here's how it works, and how to get set up.
2017-06-06
4,008 reads
SQL Server Temporary Object Caching
Paul White describes temporary object caching in SQL Server – what it is, why it exists, and how to use it to your advantage.
2017-06-06
3,591 reads
Where is my SQL Server Configuration Manager?
If you are running Windows 8 and above, you might have found out that you can’t find SQL Server Configuration Manager in the list of installed applications. Read on to learn how to locate it.
2017-06-05
4,227 reads
Free ebook: Stairway to SQL Server XML
Free download to all Simple Talk users. XML has been part of the SQL Standard since 2003, and is essential for any DBA because so many of the dynamic management views return XML data. Now that the industry is more used to data defined by document markup, it is becoming more important than ever for Database Developers and DBAs to understand the technology and to know where it makes sense to use XML.
2017-06-02
6,152 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers