Sites anglophones


How to Think Like the SQL Server Engine: Running a Query Repeatedly

Publié le 16 octobre 2019 sur brentozar.com
 

Earlier in this series, we ran a query with ORDER BY, and we realized that it was CPU-intensive work that tripled the cost of the query: Now, let’s run that query a bunch of times. In SSMS, you can add numbers after the GO, and SSMS will run your …

MariaDB – MySQL – Show Engines to Display All Available and Supported Engine

Publié le 16 octobre 2019 sur journey to sqlauthority
 

My primary job is to help my clients with their SQL Server Performance Problems. The best part of my job is that I get to work with the new client every day on my favorite topic of Comprehensive Database Performance Health Check. Many of my client …

Find SQL Server Stored Procedure Create, Modified, Last Execution Date and Code

Publié le 16 octobre 2019 sur sqlservercentral.com
 

The post Find SQL Server Stored Procedure Create, Modified, Last Execution Date and Code appeared first on SQLServerCentral.

How to Think Like the SQL Server Engine: The Perils of SELECT *

Publié le 15 octobre 2019 sur brentozar.com
 

In our last post, we ran a query with an ORDER BY, but we only got one column in the SELECT:SELECT Id FROM dbo.Users WHERE LastAccessDate > ‘2014/07/01’ ORDER BY LastAccessDate; The estimated cost was about $18 Query Bucks because SQL Server had to: …

SQL Puzzle – Schema and Table Creation – Answer Without Running Code

Publié le 15 octobre 2019 sur journey to sqlauthority
 

It has been a while we have a puzzle on this blog. Let us have a very simple and interesting puzzle today about Schema and Table Creation. Please answer this puzzle without running the code. If you totally can’t figure out why this is happening, …

Database Tools and Extensions for Visual Studio 2019

Publié le 15 octobre 2019 sur sqlservercentral.com
 

The post Database Tools and Extensions for Visual Studio 2019 appeared first on SQLServerCentral.

Using a Surrogate vs Natural Key

Publié le 15 octobre 2019 sur sqlservercentral.com
 

Choosing the primary key for a table is one of the most important decisions you can make when creating a table. A common debate is whether you should use a surrogate or a natural key. What is the difference? A natural key is a column or columns already …

[Video] What’s New in SQL Server 2019

Publié le 14 octobre 2019 sur brentozar.com
 

We must be getting pretty close to the official release of Microsoft SQL Server 2019. There are less than 80 days left in the year. (Interestingly, it’s been almost 60 days since Release Candidate 1 shipped – that’s unusually long for …

MySQL – MariaDB – Writing the Very First Stored Procedure

Publié le 14 octobre 2019 sur journey to sqlauthority
 

As many of you know I am a big fan of the SQL Server Performance Tuning area and I spend most of the time working with the client on various SQL Server Performance Tuning projects. The best part of my job is that I get to work with the new client every …

Capturing the business value of Compliant Database DevOps

Publié le 14 octobre 2019 sur sqlservercentral.com
 

The post Capturing the business value of Compliant Database DevOps appeared first on SQLServerCentral.

A User-Defined Function returns more rows

Publié le 14 octobre 2019 sur sqlservercentral.com
 

The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, th …

How to Know If Index is Forced on Query? – Interview Question of the Week #246

Publié le 13 octobre 2019 sur journey to sqlauthority
 

Question: How to Know If Index is Forced on Query?Answer: This was indeed a very interesting question received during the recent Comprehensive Database Performance Health Check by my client. Let me tell you a brief story so you understand the context o …

SQL SERVER Management Studio – ALT Keys Trick to Select Vertical Text

Publié le 12 octobre 2019 sur journey to sqlauthority
 

As wise ones say, there are always multiple solutions to one problem, today we will see the alternative trick to select vertical text in SQL Server Management Studio which I discussed earlier here: SQL SERVER Management Studio – ALT + SHIFT Keys …

Glenn’s Tech Insights For October 11, 2019

Publié le 11 octobre 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …

Foreign Keys and Multi-Table Inserts in Oracle

Publié le 11 octobre 2019 sur sqlservercentral.com
 

The post Foreign Keys and Multi-Table Inserts in Oracle appeared first on SQLServerCentral.


Pages :