Sites anglophones

Introducing sp_BlitzQueryStore

Publié le 6 juin 2017 sur

Oh, so you’re the one While SQL Server 2016 adoption is still pretty low, and 2017 still quite isn’t out yet, that’s no reason to not invest a few days of dev time into a stored procedure that is only usable by the smallest portion of …

Query Store and Parameterization Problems

Publié le 6 juin 2017 sur

Although parameterization problems can have a serious impact on the performance of a SQL Server database, it isn’t easy to determine which queries have the problem so that you can fix the issues that are causing them to run slowly. Although it is …

New Data Driven Podcast: Donald Farmer Talks Nakatomi Space, Ambiguity, Gatekeepers vs Shopkeepers

Publié le 6 juin 2017 sur

This week on Data Driven , Frank and I are honored to interview Donald Farmer, founder of TreeHive Strategy ! In this episode, we talk with Donald Farmer about data, profiting off ambiguity, fish farming, and Die Hard. Oh yeah, and tree houses. Notable …

SQL Server Temporary Object Caching

Publié le 6 juin 2017 sur

Paul White describes temporary object caching in SQL Server – what it is, why it exists, and how to use it to your advantage.

How to style your SQL using SQL Prompt’s new formatting options

Publié le 6 juin 2017 sur

Prefer tabs but your teammates use spaces? That’s not a problem with the brand new formatting options in SQL Prompt. It’s now possible to customize, save, and share multiple styles that you can then quickly switch between when working. Here’s how it wo …

The OUTPUT Clause for UPDATE Statements

Publié le 6 juin 2017 sur

In this article, I will provide a set of examples to showcase the use of OUTPUT clause in capturing the results of the updated rows into a table variable for the UPDATE statements.

SQL SERVER – How to Update Two Tables in One Statement?

Publié le 6 juin 2017 sur journey to sqlauthority

Question: How to Update Two Tables in One Statement? Answer: Not Possible. There are some questions where the answer is no and that is totally fine. I often get asked that as it is possible to select  two or more tables in a single SELECT sta …

[Video] Office Hours 2017/05/31 (With Transcriptions)

Publié le 5 juin 2017 sur

This week, Brent and Richie discuss sp_Blitz Backups, change history tracking, exams and certifications, using Azure for DR-only, which version of SQL server to use for a new DB, adding additional data files, load balancing, trace flag 2371, dealing wi …

Reducing Long R720 POST Boot Time

Publié le 5 juin 2017 sur sqlskills - jonathan kehayas

I was recently working with a client that uses R720 servers for SQL Server and during restarts of the server, the POST (Power On Self Test) would stall for as long as 15 minutes before the Windows Server OS would actually begin starting.  I did so …

Where is my SQL Server Configuration Manager?

Publié le 5 juin 2017 sur

If you are running Windows 8 and above, you might have found out that you can’t find SQL Server Configuration Manager in the list of installed applications. Read on to learn how to locate it.

Simplifying the user access audit with SQL Census

Publié le 5 juin 2017 sur

SQL Census is the latest piece of technology to be developed within Redgate Foundry. Still early in its development, it’s a product that’s designed to help you explain to an auditor which of your colleagues are able to access business-criti …

Practical usage of SQLCLR: Building QueryToHtml function

Publié le 5 juin 2017 sur

This article shows a few techniques with SQLCLR to to transform a query result into HTML.

SQL SERVER – sp_server_diagnostics – The User Does Not Have Permission to Perform this Action. (297)

Publié le 5 juin 2017 sur journey to sqlauthority

In SQL Server 2012 onwards, the cluster health check detection logic has been enhanced. Instead of the traditional pull mechanism of the cluster (IsAlive and LooksAlive), SQL Server (version 2012 onwards) uses a push mechanism to detect the health of t …

BI Beginner: Using R Visualizations

Publié le 5 juin 2017 sur

Last week I showed a simple line plot of a hypothetical college student’s GPA . The plot could have been done using R. Before showing you a visualization that requires the power of R, I’m starting with the simple line plot recreated in R. F …

How to Round Up or Round Down Number in SQL Server? – Interview Question of the Week #125

Publié le 4 juin 2017 sur journey to sqlauthority

Question: How to Round Up or Round Down Number in SQL Server? Answer: This is a very popular question. Let me rephrase this question as I often see the other version of this question being asked as well. Alternate Version of Question: How to find ceili …

Pages :