Sites anglophones


Filtered Indexes and Forced Parameterization: Can’t we all just get along?

Publié le 8 février 2018 sur bart duncan's sql weblog
 

We have a database here that stores information about Azure SQLDB health issues; it was chugging along fine for months, then earlier this week it started to struggle. You can see the large increase in steady-state CPU consumption: After asking around, …

Filtered Indexes and Forced Parameterization: Can’t we all just get along?

Publié le 8 février 2018 sur bart duncan's sql weblog
 

We have a database here that stores information about Azure SQLDB health issues; it was chugging along fine for months, then earlier this week it started to struggle. You can see the large increase in steady-state CPU consumption: After asking around, …

Rethink Server Sizing II

Publié le 8 février 2018 sur sqlblog.com
 

The huge disparity between round-trip access to DRAM memory and the CPU clock cycle has been a serious problem for more than ten years. It is simple to demonstrate that even a small amount of pointer chasing code, in which the memory value being access …

Creating Insert Triggers to Silently Ignore Data You Don’t Want

Publié le 8 février 2018 sur brentozar.com
 

Say you’ve got an application that insists on inserting data into the database, and…you don’t want the data. You want the application to THINK it inserted the data – you don’t want to roll it back or return an error to th …

Introducing database automation with the SQL Toolbelt

Publié le 8 février 2018 sur sqlservercentral.com
 

In this post, Mary Robbins explains how Absa bank improved development efficiency and minimized risk by implementing SQL Toolbelt.

Adaptive Query Processing – Interleaved Execution

Publié le 8 février 2018 sur sqlservercentral.com
 

Interleaved Execution allows SQL Server’s query optimizer to get accurate cardinality estimates in places where it couldn’t before. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains …

SQL SERVER – Fix – Error – Property MemoryAllocatedToMemoryOptimizedObjectsInKB is not available for Database. This property may not exist for this object, or may not be retrievable due to insufficient access rights.

Publié le 8 février 2018 sur journey to sqlauthority
 

The other day when I was presenting my popular training SQL Server Performance Tuning Practical Workshop, during the demonstrations, I received following error. It was bit embarrassing for me as I was presenting in front of over 25 extremely smart …

SQL Server Machine Learning Services – Part 5: Generating multiple plots in Python

Publié le 7 février 2018 sur simple-talk.com
 

The series so far: SQL Server Machine Learning Services – Part 1: Python Basics SQL Server Machine Learning Services – Part 2: Python Data Frames SQL Server Machine Learning Services – Part 3: Plotting Data with Python SQL Server Mach …

Using LIKE on Integers Gets You Implicit Conversion

Publié le 7 février 2018 sur brentozar.com
 

Using the Stack Overflow public export, take these two queries looking for a particular user by Id (the clustering key):SELECT * FROM dbo.Users WHERE Id = 26837; SELECT * FROM dbo.Users WHERE Id LIKE 26837; The first one (=) gets a clustered index seek …

The new Data Modeling for Power BI course

Publié le 7 février 2018 sur sqlblog.com
 

I recently published a new blog post on SQLBI.You can read it at this link: https://www.sqlbi.com/blog/marco/2018/02/06/the-new-data-modeling-for-power-bi-course/

How to use the SQL Prompt snippet placeholders for selecting and copying text

Publié le 7 février 2018 sur sqlservercentral.com
 

There are four SQL Prompt snippet placeholders that are all about selection and copying of text. These placeholders are very handy if, for example, you have two blocks of code that need to be part of a snippet. One part you hold on the clipboard, and t …

Stairway to Advanced T-SQL Level 6: Creating Rows Of Data Using The UNPIVOT Operator

Publié le 7 février 2018 sur sqlservercentral.com
 

The UNPIVOT operator does just the opposite of the PIVOT operator, which we looked at in the previous level. By using the PIVOT operator we can take multiple rows of data and create as single row as output. The UNPIVOT operator will take values from a …

Reduce SQL Server Costs with Heimdall Data Caching

Publié le 7 février 2018 sur sqlmag.com
 

This article explains how Heimdall Data auto-caches with zero disruption to your current infrastructure.

SQL SERVER – Unable to Repair – SQL_Telemetry_Repair_Startup_Cpu64 gives error – The Service Cannot Be Started

Publié le 7 février 2018 sur journey to sqlauthority
 

A few days ago, I wrote a blog where I have to perform repair of the SQL instance to fix the issue. While running repair, I encountered an interesting error. In this blog, we would learn how to fix error “The service cannot be started, either bec …

Setting mentoring ground rules

Publié le 6 février 2018 sur sqlskills.com - paul randall
 

One of the things I always recommend in the first newsletter of each year is to try to get a mentor. On the flip side of that is that one of the most rewarding things you can do in your professional life is to *be* a mentor to one or more people. I men …


Pages :