Sites anglophones


“But NOLOCK Is Okay When The Data Isn’t Changing, Right?”

Publié le 5 août 2019 sur brentozar.com
 

I’ve already covered how NOLOCK gives you random results when you’re querying data that’s changing, and that’s a really powerful demo to show folks who think NOLOCK is safe to use in production. However, I’ve gotten a ques …

SQL SERVER – List All Frequently Ran Stored Procedure From Server Cache

Publié le 5 août 2019 sur journey to sqlauthority
 

Earlier this weekend, I had an urgent product to help. One of my clients reached out to me as their application stopped running in the middle night on Saturday. The issue was indeed a strange one as they have very little traffic on weekends and particu …

An Intro to SQL Window Functions

Publié le 5 août 2019 sur sqlservercentral.com
 

The post An Intro to SQL Window Functions appeared first on SQLServerCentral.

How SQL Server monitoring benefits your whole organization.

Publié le 5 août 2019 sur sqlservercentral.com
 

The post How SQL Server monitoring benefits your whole organization. appeared first on SQLServerCentral.

How to Write in Text File from T-SQL in SQL Server? – Interview Question of the Week #236

Publié le 4 août 2019 sur journey to sqlauthority
 

Question: How to Write in Text File from T-SQL in SQL Server?Answer: The question above was actually asked in an interview and also was not asked in the same word. The actual conversation was on a very different topic.Recently I was hired by one of the …

SQL SERVER – DBCC CHECKDB WITH PHYSICAL_ONLY Failing and DBCC CHECKDB Succeeding – Bug

Publié le 3 août 2019 sur journey to sqlauthority
 

The other day, I was hired for the most strange issue I have encountered. One of my previous client of Comprehensive Database Performance Health Check recently reached out with a strange bug where DBCC CHECKDB WITH PHYSICAL_ONLY failed and DBCC CHECKDB …

Reporting Services Basics: Parameters

Publié le 2 août 2019 sur simple-talk.com
 

The series so far: Reporting Services Basics: Overview and Installation Reporting Services Basics: Creating Your First Report Reporting Services Basics: Data Sources and Datasets Reporting Services Basics: Parameters Adding parameters is one of the ess …

SQL SERVER – Upgrade Error: Microsoft NET Framework 4.0 Installation Has Failed With Exit Code – 2146498511

Publié le 2 août 2019 sur journey to sqlauthority
 

While performing an in-place upgrade from SQL Server 2014 SQL server 2016 my client faced an error. In this blog, I am going to share the cause and the solution of error Microsoft .NET Framework 4.0 installation has failed with exit code  -2146498 …

Practical steps for end-to-end data protection

Publié le 2 août 2019 sur sqlservercentral.com
 

The post Practical steps for end-to-end data protection appeared first on SQLServerCentral.

Help! SQL Server 2008 is Still Here!

Publié le 2 août 2019 sur sqlservercentral.com
 

The post Help! SQL Server 2008 is Still Here! appeared first on SQLServerCentral.

What The Consultant Toolkit Does

Publié le 1 août 2019 sur brentozar.com
 

It’s one thing for me to tell you how much easier The Consultant Toolkit makes my job and how clients love how much I can tell them about their server during the initial sales call – but it’s another thing to hear it from a happy cust …

SQL SERVER – Error 35296: Log Backup for Database “SQLAuthority” on Secondary Replica Failed Because the New Backup Information Could Not be Committed on Primary Database

Publié le 1 août 2019 sur journey to sqlauthority
 

One of my clients contacted me for whom I assisted in configuring Always On Availability Groups for the first time. They were getting an error whole taking log backup on secondary replica: Log backup for database “SQLAuthority” on secondary …

How to Unclog SQL Server

Publié le 1 août 2019 sur sqlservercentral.com
 

Not long ago, we were notified of a query timing out in an application after three minutes.  We were consulted to help find out why.  No, it was not SQL Server itself timing out, we explained.  SQL Server doesn’t understand what a …

Polling and Survey Data Transparency

Publié le 1 août 2019 sur sqlservercentral.com
 

The post Polling and Survey Data Transparency appeared first on SQLServerCentral.

3 ways Managed Services Providers can offer more value

Publié le 1 août 2019 sur sqlservercentral.com
 

The post 3 ways Managed Services Providers can offer more value appeared first on SQLServerCentral.


Pages :