Sites anglophones


SQL SERVER – Database Attach Failure – Msg 2571 – User ‘guest’ Does Not Have Permission to Run DBCC Checkprimaryfile.

Publié le 14 mars 2018 sur journey to sqlauthority
 

One of my clients was trying to recover from a disaster and wanted to attach the MDF and LDF files. While trying to do that, they encountered an error. In this blog we would learn about how to fix the error – User ‘guest’ does not hav …

SQL Server Diagnostic Information Queries for March 2018

Publié le 14 mars 2018 sur sqlskills.com - glen berry
 

This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. I have made the most changes to the SQL Server 2017 version this month. I have also developed a T-SQL script that you can u …

An Easier Way of Transposing Query Result in SQL Server

Publié le 13 mars 2018 sur simple-talk.com
 

I like Phil Factor’s articles. The latest one, An Easier Way of Pivoting Data in SQL Server, inspired me to start exploring another option to transpose a result from a query. There are many situations in which the results of a query look better w …

Announcing 2 New Online Classes: Database DevOps and Practical Real-World Performance Tuning

Publié le 13 mars 2018 sur brentozar.com
 

We’re proud to announce that in addition to our existing summer lineup: Always On Availability Groups: The Senior DBA’s Field Guide with Edwin Sarmiento, 3 days $2,995 Data Science Fundamentals with R with Steph Locke, 2 days, $1,995 PowerS …

Consider using [NOT] EXISTS instead of [NOT] IN (subquery)

Publié le 13 mars 2018 sur sqlservercentral.com
 

The query optimizer now treats EXISTS and IN the same way, whenever it can, so you’re unlikely to see any significant performance differences. Nevertheless, you need to be cautious when using the NOT IN operator if the subquery’s source dat …

AI in Industries

Publié le 13 mars 2018 sur sqlservercentral.com
 

It is important to showcase how Artificial Intelligence is being used in various fields and industries with some facts

SQL SERVER – Puzzle – How Does YEAR Function Work?

Publié le 13 mars 2018 sur journey to sqlauthority
 

There are many different datetime related functions such as DAY, MONTH, YEAR, DATEDIFF, etc available in SQL Server. For example, YEAR function can be used to extract year value from a date. Let me show you a simple example DECLARE @TRANSACTION_DATE DA …

[Exclusive] Practical Real World Performance Tuning – Live Training Session for Limited Time

Publié le 12 mars 2018 sur journey to sqlauthority
 

I am happy to announce that the new course Practical Real-World Performance Tuning, along with Brent Ozar (blog) is now live. We are accepting the registration for a limited time. This is very unique opportunity …

Building SQL ConstantCare®: The Vision

Publié le 12 mars 2018 sur brentozar.com
 

We’re starting to roll out a new product, SQL ConstantCare®, and now that we’ve got over 50 customers, it’s time to start sharing some behind-the-scenes details about what we’ve built. Over the next several Mondays, I’ …

Redgate’s support for Azure SQL Database Managed Instances

Publié le 12 mars 2018 sur sqlservercentral.com
 

Last week Microsoft released the public preview of Azure SQL Database Managed Instances – an exciting new option for running SQL Server workloads in the cloud. This blog post explains what they are, and how Redgate’s SQL Toolbelt supports them.

Intervals Part 1 – Definitions and Terms

Publié le 12 mars 2018 sur sqlservercentral.com
 

Learn the basic terms and definitions for intervals in SQL Server. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bot …

Non-Standard Delimiters for Columns and Rows Using SQL Server Bulk Insert

Publié le 12 mars 2018 sur sqlservercentral.com
 

In this tip, Tim Smith looks at how to use bulk insert to load data into SQL Server when the column and row terminators are not what you typically see.

SQL SERVER – Fix Error 3271: A nonrecoverable I/O error occurred on file. The remote server returned an error: (404) Not Found

Publié le 12 mars 2018 sur journey to sqlauthority
 

In SQL Server one error message can be caused due to many reasons. One of such error message is 3271 which is caused during failure of backup to URL command. Here are two earlier blogs about same error message 3271. (404) Not Found. SQL SERVER …

[Video] Office Hours 2018/03/07 (With Transcriptions)

Publié le 11 mars 2018 sur brentozar.com
 

This week, Brent, Erik, Tara, and Richie discuss database restores, opening a case with Microsoft, buying a pre-built server vs building your own, auto-shrinking all databases with a single command, SQL Server dev environment options, the best way to l …

What is Alternative to CASE Statement in SQL Server? – IIF Function – Interview Question of the Week #164

Publié le 11 mars 2018 sur journey to sqlauthority
 

Question: What is Alternative to CASE Statement in SQL Server? Answer: IIF Function. Honestly, when I write this blog post I feel a bit sad that IIF Function has not received necessary adoption since its release in the year 2012. When I am writing this …


Pages :