Sites anglophones


SQL SERVER – Display Rupee Symbol in SSMS

Publié le 27 janvier 2020 sur journey to sqlauthority
 

Recently, I was reached out by one of the my financial technology clients based out of the USA who has just launched their services in India. Their system worked fine in most of the area but the challenge was to display the Indian currency sign. They r …

Basic Concepts of Probability Explained with Examples in SQL Server and R

Publié le 27 janvier 2020 sur sqlservercentral.com
 

The post Basic Concepts of Probability Explained with Examples in SQL Server and R appeared first on SQLServerCentral.

Month-over-Month calculation using DAX in Power BI

Publié le 27 janvier 2020 sur sqlservercentral.com
 

Introduction Period-over-period is an analysis technique in business that measures some value in the present and compares it to the same measurement in a comparable period of time in the past. The goal is to adjust the slice of the past you are viewing …

What are Different Methods to Know the Row Count of Table? – Interview Question of the Week #261

Publié le 26 janvier 2020 sur journey to sqlauthority
 

Question: What are Different Methods to Know the Row Count of Table?Answer: The answer to this question is very simple and many. I have previously blogged about this topic many times. Here are a few sample questions one can on this topic:How many users …

SQL SERVER – Heaps, Scans and RID Lookup

Publié le 25 janvier 2020 sur journey to sqlauthority
 

Today we will discuss a question which I was recently asked by my client during the Comprehensive Database Performance Health Check. The question was do heaps are very bad and always force a table scan? The answer is NOT Always, whenever there is a cas …

Updated First Responder Kit and Consultant Toolkit for January 2020

Publié le 24 janvier 2020 sur brentozar.com
 

A couple of times a year, I disconnect from the Internet to sit down with a planning book, my Epic Life Quest, and my future task list. I spend time making sure my day-to-day tasks are still prioritized right. When I do that, I often find out that I …

SQL SERVER Tools I Use and Recommend (Updated: January 2020)

Publié le 24 janvier 2020 sur journey to sqlauthority
 

One of the most popular questions I often receive during Comprehensive Database Performance Health Check is which are the third-party tools I use in my daily routine and I recommend them. Here is the updated list for January 2020 of all the tools which …

Monitoring SQL Server with Splunk and SQL Monitor

Publié le 24 janvier 2020 sur sqlservercentral.com
 

The post Monitoring SQL Server with Splunk and SQL Monitor appeared first on SQLServerCentral.

Keyset Does Not Exist – Add-ClusterNode

Publié le 23 janvier 2020 sur sqlskills - jonathan kehayas
 

While working on a video recording for Paul this week I ran into an interesting problem with one of my Windows Server 2016 clusters. While attempting to add a new node to the cluster I ran into an exception calling Add-ClusterNode:The server ‘SQL …

Cool Query Hints

Publié le 23 janvier 2020 sur brentozar.com
 

The SQL Server documentation has a pretty cool list of query hints: Yeah, I surf in dark mode. I’m a dark kinda guy. But wait – what’s that colored box? ENHANCE! I could make jokes here, but … every single thing in that caution …

What Events are in a Trace?

Publié le 23 janvier 2020 sur SQLSkills.com - Erin Stellato
 

Yes…I’m writing a post about SQL Trace…specifically events in a trace. There are still lots of folks that use Profiler and run server-side traces, and when I work with those customers I like to understand how the traces are configur …

SQL SERVER – Resolve WAIT_ON_SYNC_STATISTICS_REFRESH Wait Type

Publié le 23 janvier 2020 sur journey to sqlauthority
 

Every new consulting engagement teaches me new learnings. In the recent SQL Server Comprehensive Database Performance Health Check engagement, I had faced a very interesting issue, which I had not faced so far ever in my career before. I recently faced …

Prevent SQL Server Blocking using Lock_Timeout

Publié le 23 janvier 2020 sur sqlservercentral.com
 

The post Prevent SQL Server Blocking using Lock_Timeout appeared first on SQLServerCentral.

Stable Marriages Using SQL Server

Publié le 23 janvier 2020 sur sqlservercentral.com
 

Introduction This article introduces a stored procedure for SQL Server that handles a celebrated matching problem in graph theory. This work formed the basis of a Nobel Prize in 2012 [6], and is currently used by several organizations [4],[5]. In previ …

Comments and More in PowerShell

Publié le 23 janvier 2020 sur sqlservercentral.com
 

The post Comments and More in PowerShell appeared first on SQLServerCentral.


Pages :