Sites anglophones


How Much Memory is “Normal” for SQL Servers?

Publié le 19 novembre 2018 sur brentozar.com
 

When I look at a SQL Server, one of the first things I check is, “How much memory does this thing have relative to the amount of data we’re hosting on here?” I’ve long used some seat-of-the-pants numbers, but armed with data fro …

Recursive CTE calculations

Publié le 19 novembre 2018 sur sqlservercentral.com
 

Reusing the previous value of a recursive CTE to construct the new value

What we learnt at PASS Summit Webinar

Publié le 19 novembre 2018 sur sqlservercentral.com
 

PASS President Grant Fritchey will be joined by fellow Microsoft MVPs Kendra Little and Steve Jones to discuss their highlights and learnings from PASS Summit 2018, the largest Microsoft Data Platform conference. How to fix SQL Server disk I/O bottlene …

SQL SERVER – Get List of the Logical and Physical Name of the Files in the Entire Database

Publié le 19 novembre 2018 sur journey to sqlauthority
 

One of the most popular questions I often receive is why do I like to do consultation – my answer is very simple – it gives me an opportunity to learn continuously learn new things from my clients. Here is a script which I have built during …

CPU Upgrade to AMD Ryzen Threadripper 2950X

Publié le 18 novembre 2018 sur sqlskills.com - glen berry
 

About a year ago, I built a high-end desktop (HEDT) workstation based on the then, top-of-the-line 14nm AMD Ryzen Threadripper 1950X processor. This is the machine that I use for most of my daily work, and I have been quite happy with it over the past …

How to Trim TIME Part in DATETIME Values? – Interview Question of the Week #200

Publié le 18 novembre 2018 sur journey to sqlauthority
 

Question: How to Trim TIME Part in DATETIME Values? Answer: One of my blog followers sent me an email asking this question I want to convert ‘2013-01-15 11:23:49.930′ into output =’2013-01-15 11:00:00.000’ If you look …

[Video] Office Hours 2018/11/14 (With Transcriptions)

Publié le 17 novembre 2018 sur brentozar.com
 

This week, Tara, Erik, and Richie discuss using Docker in dev environment, in-place upgrades, disaster recovery, the minimum amount of CPU and RAM for new SQL Server VMs, troubleshooting long-running SQL agent jobs, dbcc checkdb running longer than nor …

SQL SERVER – Optimize Key Lookup by Creating Index with Include Columns

Publié le 17 novembre 2018 sur journey to sqlauthority
 

I love query tuning and performance tuning projects. In one of the recent Comprehensive Database Performance Health Check my client had a very interesting scenario where their queries were running pretty fast earlier but gradually started to run s …

Adventures In Foreign Keys 5: The Limits Of Elimination

Publié le 16 novembre 2018 sur brentozar.com
 

FINALLY… This is the last post I’ll write about foreign keys for a while. Maybe ever. Let’s face it, most developers probably find them more annoying than useful, and if you didn’t implement them when you first started designin …

Use SQL Server? We’d like to hear from you.

Publié le 16 novembre 2018 sur sqlservercentral.com
 

We are running a survey to better understand trends in adoption of different technologies and platforms. Completing this survey will take just a few minutes. As a thank you for your time, we will be giving away one $100 Amazon gift card to one randomly …

Puzzle – Datatime to DateTime2 Conversation in SQL Server 2017

Publié le 16 novembre 2018 sur journey to sqlauthority
 

Earlier last week, I was presenting various questions about SQL Server 2017 at PASS in Seattle. However, during one of the session, I was fortunate to meet SQL Server Expert Christopher Savage. He shared a very interesting puzzle with me. I have b …

Adventures In Foreign Keys 4: How Should I Index These Things?

Publié le 15 novembre 2018 sur brentozar.com
 

This week, we’re all about foreign keys. So far, we set up the Stack Overflow database to get ready, then tried to set up relationships, and encountered cascading locking issues. Dawn Of The Data I don’t know how long the recommendatio …

T-SQL Decommenter Part II

Publié le 15 novembre 2018 sur sqlservercentral.com
 

Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.

SOX and Database Administration – Part 3

Publié le 15 novembre 2018 sur sqlservercentral.com
 

Database administrators are typically responsible for the security and availability of financial data. In this article, Robert Sheldon discusses SOX, passed in 2002, that governs financial data of publicly traded companies in the US.

SQL SERVER – Steps to Change IP Address of SQL Server Failover Cluster Instance

Publié le 15 novembre 2018 sur journey to sqlauthority
 

There have been many questions in my mailbox asking about exact steps to change the windows cluster and SQL failover cluster IP address to the new VLAN. In this blog, I would outline the steps which are needed to perform this migration. If we look at t …


Pages :