Sites anglophones


What’s Better, CTEs or Temp Tables?

Publié le 6 juin 2019 sur brentozar.com
 

I get this question a lot, so let’s set up an example with the Stack Overflow database. My query’s goal is to: Find the top 5 Locations List the users who live in those top 5 Locations, alphabetized by their DisplayName There are a LOT of w …

SQL SERVER – Detecting Database Isolation Level MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT

Publié le 6 juin 2019 sur journey to sqlauthority
 

Yesterday one of my previous customer with whom I worked on Comprehensive Database Performance Health Check reached out me with a very simple but very interesting question related to Detecting Database Isolation Level MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSH …

SQL Server function to convert integer date to datetime format

Publié le 6 juin 2019 sur sqlservercentral.com
 

The post SQL Server function to convert integer date to datetime format appeared first on SQLServerCentral.

Coffee Mug – Indexes and SELECT Queries

Publié le 5 juin 2019 sur journey to sqlauthority
 

Sometimes I feel like I have become a kid again when I do a blog post such as today but it is indeed the best part of running a blog tirelessly for over 13 years. This morning I received a coffee mug with printed quotes of Indexes and SELECT Queries.Ha …

Monitor SQL Server Integration Services Packages Stuck in Running Status

Publié le 5 juin 2019 sur sqlservercentral.com
 

The post Monitor SQL Server Integration Services Packages Stuck in Running Status appeared first on SQLServerCentral.

Tips for Better Presentations

Publié le 4 juin 2019 sur brentozar.com
 

Today’s post is for those of you who give presentations to user groups and conferences. Upload your resources before the session starts. When you say “I’ll upload the resources later,” the attendee hears you saying, “I …

SQL SERVER – 3 Questions: An Index Reduces Performance of SELECT Queries

Publié le 4 juin 2019 sur journey to sqlauthority
 

Earlier last week I have published a blog which received very much positive reviews. Lots of people had no idea that even index can also reduce the performance of SELECT queries. I have received a lot of follow up questions and comments via blogs, yout …

How to Eliminate Gaps in Identity Values in SQL Server by Disabling the Identity Cache

Publié le 4 juin 2019 sur sqlservercentral.com
 

The post How to Eliminate Gaps in Identity Values in SQL Server by Disabling the Identity Cache appeared first on SQLServerCentral.

A Plunge Into TOP

Publié le 4 juin 2019 sur sqlservercentral.com
 

Introduction TOP is one of the many syntactical operators available in T-SQL and at a first view, it could seem very simple and not particularly interesting. According to the official documentation, it “limits the rows returned in a query result …

SQL Clone for Unit Testing Databases

Publié le 4 juin 2019 sur sqlservercentral.com
 

The post SQL Clone for Unit Testing Databases appeared first on SQLServerCentral.

SQL Server Common Table Expression vs Temp Table

Publié le 4 juin 2019 sur sqlservercentral.com
 

The post SQL Server Common Table Expression vs Temp Table appeared first on SQLServerCentral.

SQL Server Diagnostic Information Queries for June 2019

Publié le 3 juin 2019 sur sqlskills.com - glen berry
 

This month, I have added some new columns in some of the queries in most of the query sets. I have also been working on the Azure SQL Database version of the queries some more lately.I have a T-SQL script that you can use to check whether your instance …

Why That “DBA” Job Posting Sounds So Terrible

Publié le 3 juin 2019 sur brentozar.com
 

What follows are just some of the highlights from an actual job posting. I’m not including the job description, just the requirements that an applicant has to have in order to even throw their hat in the ring: Requires Bachelor’s degree or …

SQL SERVER – FIX: Msg 15274 – Access to the Remote Server is Denied Because the Current Security Context is not Trusted

Publié le 3 juin 2019 sur journey to sqlauthority
 

While working with a client, I encountered few errors while using linked server and I am going to share my solutions via a few blog posts. In this blog we would talk about fixing error 15274 – Access to the remote server is denied because the cur …

Create and deploy Azure Resource Manager templates by using the Azure portal

Publié le 3 juin 2019 sur sqlservercentral.com
 

 This article will explain and help to create and deploy ARM templates using the Azure portal. When Azure was first created, Azure resources were managed using the Azure service management (ASM), which is also known as “Classic”. Now t …


Pages :