SQL

SQL Server Machine Learning 2019: Working with Security Changes

  • Article

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

Creating Time-Intelligence Functions in DAX

  • Article

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

Analysis Services : OLEDB Error while processing in SSAS

  • Article

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: […]

5 (3)

2020-02-03

1,588 reads

How to filter non-existing records in SQL

  • Article

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. […]

4 (6)

2019-11-04

6,477 reads

A User-Defined Function returns more rows

  • Article

The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, the row count significantly increased to 826K. There were no other changes made […]

4 (5)

2019-10-14

4,088 reads

Optimize Your SQL by Reformulating the Spec

  • Article

As SQL developers, we tend to think of performance tuning in terms of crafting the best table indices, avoiding scalar and table valued functions, and analyzing query plans (among other things). But sometimes going back to the spec and applying some properties of elementary math can be the best way to begin to improve performance of SQL queries which implement mathematical formulas. This article is a case study of how I used this technique to optimize my SQL implementation of the Inverse Simpson Index.

5 (2)

2019-09-12

2,826 reads

Blogs

Daily Coping 21 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 18 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Optimize for Unknown for Inline Table-Valued Functions

By

I had a curious performance issue today. An inline table-valued function (iTVF) was performing...

Read the latest Blogs

Forums

Searching for orphaned DB files on the SQL server

By martin.tydor@gmail.com

Comments posted to this topic are about the item Searching for orphaned DB files...

DEA

By ramyours2003

What is the use of DEA tool in sql ?  how can we  install...

\'REMOTE ACCESS\' setting flipped back to 0 overnight ??

By Express12

Any reason why our SQL Server 2016 Standard edition instance would have flipped the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers