When the optimizer doesn’t estimate the correct amount of memory for a query, either memory is wasted that could be used for other processes or some operations will spill to disk. Microsoft has added Memory Grant Feedback to help overcome this issue. In this article, Greg Larsen explains what you need to know about this new feature.
2020-06-10
n SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. Read on to explores the concept behind and learn how to declare cursors, open, retrieve data from them, and then close them.
2020-06-09
Learn a bit about concurrency problems in SQL Server, the issues they create, and the different isolation levels that help you solve them.
2020-05-12
35,263 reads
SQL Server Machine Learning allows you to run R and Python scripts from SQL Server. When SQL Server 2019 was released, Microsoft enhanced the security for this functionality, but it caused some existing code writing to the file system to to break. In this article, Dennes Torres explains the security enhancement and describes three ways to work with it.
2020-03-11
In this article in the series, Robert Sheldon provides a deep dive into HDDs.
2020-03-09
DAX contains a host of time-intelligence functions with exotic names such as SAMEPERIODLASTYEAR and PARALLELPERIOD. In the last article in this series, Andy Brown explains how to write measures using the range of date functions in DAX, and also explains how time-intelligence functions work behind the scenes.
2020-03-06
This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.
2020-02-25
15,577 reads
Problem This is one of the errors that I frequently encounter while deploying or processing SSAS OLAP cubes on the client's computers or on a remote server. Recently, one of my team members also faced the same issue and so I thought to write a resolution for the issue. The error is something like this: […]
2020-02-03
7,853 reads
Learn how you can modify an SSIS package to dynamically process SSAS cubes.
2020-01-13
9,874 reads
Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]
2021-11-26 (first published: 2019-11-04)
13,694 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers