Sites anglophones


Gap Analysis Using Algebra

Publié le 10 mars 2020 sur sqlservercentral.com
 

Introduction This article shows how to solve a gaps and islands problem using simple algebra. No SQL Server loops or cursors are required for this solution. Problem Scheduling constraints occasionally require the presence of some “feature …

Analyze SQL Server Results in Excel with Conditional Formatting

Publié le 10 mars 2020 sur sqlservercentral.com
 

The post Analyze SQL Server Results in Excel with Conditional Formatting appeared first on SQLServerCentral.

SQL SERVER – Msg 17177 – This Instance of SQL Server Has Been Using a Process ID of %s since %s (local) %s (UTC)

Publié le 9 mars 2020 sur journey to sqlauthority
 

Recently I was looking at SQL Server ERRORLOG of one of my instances on my Azure VM. It was interesting to see and research the message mentioned in the subject. In this blog, I would share my understanding of the message “This instance of SQL Se …

Implementing Drill Through Actions in SSAS

Publié le 9 mars 2020 sur sqlservercentral.com
 

Introduction As a Data Analyst, it is often essential that you dive deep into the visual metrics that are being summarized and displayed on the dashboards or reports to perform your analysis. To aid such an analysis, we need to be able to know all the …

How to Do Case Insensitive Search? – Interview Question of the Week #267

Publié le 8 mars 2020 sur journey to sqlauthority
 

Question: How to Do Case Insensitive Search?Answer: This is a very interesting question. Most of the time, I receive a question about how to do case sensitive search and I have already previously blogged that in the following blog posts:How to Do Case …

SQL SERVER – Remove All Query Cached Plans Not Used In Certain Period

Publié le 7 mars 2020 sur journey to sqlauthority
 

One of the reasons, I love my job of SQL Server Performance Tuning Expert is that I get to learn every single day something new while working with my client on Comprehensive Database Performance Health Check. Recently I got a very unique situation wher …

SQL SERVER Management Studio – Rebuild All Indexes on Table

Publié le 6 mars 2020 sur journey to sqlauthority
 

Today, we are going to see a very simple trick about SQL SERVER Management Studio (SSMS), where we will learn how to rebuild all indexes on the table with a single click. While I considered this as a very simple trick while demonstrating this to my e-c …

Meeting your CCPA needs with Data Classification and Masking

Publié le 6 mars 2020 sur sqlservercentral.com
 

The post Meeting your CCPA needs with Data Classification and Masking appeared first on SQLServerCentral.

Making TRY_CAST and TRY_CONVERT Queries Faster with Indexed Computed Columns

Publié le 5 mars 2020 sur brentozar.com
 

I know this is gonna sound crazy, but let’s say you had a table where people stored all kinds of things in one column: dates, integers, file names, sale prices, file names, you name it. And let’s say your application frequently ran a query …

SQL SERVER – Count NULL Values From Column

Publié le 5 mars 2020 sur journey to sqlauthority
 

The other day, I have received a very simple but interesting question by one of my earlier clients of Comprehensive Database Performance Health Check via email. The question was about how to count NULL values from the column.Honestly, this is a very si …

SQL Server on VMWare Performance Optimization

Publié le 5 mars 2020 sur sqlservercentral.com
 

The post SQL Server on VMWare Performance Optimization appeared first on SQLServerCentral.

Implementing Date Calculations in SQL

Publié le 5 mars 2020 sur sqlservercentral.com
 

Problem A few weeks back, I was working on a report for one of my clients who were using a desktop application as a client tool with SQL as the database. The module on which I was working had a reporting functionality that displayed the Sales Amount by …

Build your DevOps business case with industry insights

Publié le 5 mars 2020 sur sqlservercentral.com
 

The post Build your DevOps business case with industry insights appeared first on SQLServerCentral.

How to Find Cool Questions and Answers on DBA.StackExchange.com

Publié le 4 mars 2020 sur brentozar.com
 

DBA.StackExchange.com is a Stack Overflow site that’s specifically targeted at database administrators. There tend to be some pretty interesting questions in there – not just for SQL Server, but all kinds of databases – but at the sam …

SQL SERVER – Install Error – The Account Running SQL Server Setup Does Not Have Administrator Rights On the Computer. To Continue, Use an Account With Administrator Rights

Publié le 4 mars 2020 sur journey to sqlauthority
 

As a part of my work, I also provide consultancy to fix the issues. In my recent engagement with a client, they were getting an error while installing SQL Server 2019. In this blog, I would share the steps to identify and fix error – The acc …


Pages :