Sites anglophones

SQL SERVER – Results of Dynamic SQL Into A Variable

Publié le 20 novembre 2018 sur journey to sqlauthority

The other day during Comprehensive Database Performance Health Check, I was asked if there is a way to store results of dynamic SQL into a variable. This is a very popular question and let us see the answer to this question in this blog post. For examp …

Psst – it’s holiday card time. Update your address.

Publié le 19 novembre 2018 sur

Last year’s Christmas card We’re getting ready to send out our annual holiday cards to folks who shopped with us this year. If you’d like to get one, make sure you set up your billing address in your account to reflect your current ad …

How Much Memory is “Normal” for SQL Servers?

Publié le 19 novembre 2018 sur

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

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

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 - 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

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

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

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

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

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

Pages :