A data transformation problem in SQL and Scala: Dovetailing declarative solutions Part II
In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.
2021-04-20
Development
A data transformation problem in SQL and Scala: Dovetailing declarative solutions
This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a SQL execution plan for software design.
2021-03-18
Heaps in SQL Server: Part 4 PFS contention
When inserting rows into a heap, SQL Server must sometimes update the PFS page which can PFS contention and affect performance. In this article, Uwe Ricken demonstrates how to measure PFS contention.
2021-01-25
Normal Forms
To prevent data change anomalies, a database should be normalized. Did you know that there are 10 normal forms? In this article, Joe Celko reviews normalizing databases including commonly used normal forms.
2020-12-15
Hands-On with Columnstore Indexes: Part 4 Query Patterns
All queries run fast against columnstore indexes, right? In this article, Edward Pollack demonstrates some query patterns that don’t perform well and how to get around the issues.
2020-09-24
Heaps in SQL Server: Part 3 Nonclustered Indexes
Uwe Ricken continues his series on heaps. This time he demonstrates a common scenario where the query against a heap is faster than a clustered index.
2020-09-17
Heaps in SQL Server: Part 2 Optimizing Reads
In the second article of this series, Uwe Ricken discusses ways to affect the performance of queries involving heaps, including the TOP operator, compression, and partitioning.
2020-07-15
Beginner Guide to In-Memory Optimized Tables in SQL Server
Microsoft added the In-Memory OLTP (aka memory optimized tables) feature to SQL Server 2014. Operations to this type of table do not need locks, therefore eliminating blocking and deadlocking. In this Article, Monica Rathbun demonstrates how to get started using memory optimized tables.
2020-03-04
9 Tips for Faster SQL Server Applications
Wanna make your SQL Server applications go faster? Here are 9 simple tips that will give you a better chance for success. They’re not carved in stone, but they’re a good place to start.
2019-05-31
Automating the Setup of the Local Developer Machine
On both Windows and Linux, the chore of setting up a development workstation can take several days, and there always seem to be a few configuration settings that get missed. You can reduce the time and tedium dramatically by automating the process by using Vagrant to set up the operating system, followed by your choice of provisioning, configuration management and orchestration applications such as Puppet, Chef, Ansible, Salt, Docker, Chocolatey and Boxstarter. Vishwas shows how to make it easy to do with Vagrant, Chocolatey and Boxstarter.
2017-01-24
3,844 reads
Blogs
Daily Coping 21 Sep 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Bulk insert.
In my last post I talked about invoke-sqlcmd. It’s a nice easy way to...
Lambda Architecture in data systems and possible meaning of this name
By Rayis Imayev
(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...
Forums
Can't attach MDF and LDF files
Hi All When I tried to attach my mdf and ldf file , I...
Social Media Link Aggrigator
Need a way to put all of your social media links and profiles into...
Issue with the format of calculation
Hello friends, This issue is a little hard to explain, but I hope you...
Ask SSC