SQL Performance

JUNE 10, 2020

In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. Recall that what triggered this series is some confusion that exists in the SQL Server community around named table expressions.

C++ 109

C++ Database Servers Code 109

SQL Performance

SEPTEMBER 25, 2020

Deriving default values using T-SQL is cumbersome and error-prone. However, the problem still exists in SQL Server 2019. However, the problem still exists in SQL Server 2019. When you’re looping through a string one word at a time, it goes on and on, and there are so many bits you need to track. CREATE PROCEDURE dbo.

Code 42

Code C++ Database Servers 42

SQL Performance

MARCH 5, 2020

FROM [ DemoTable ] t1 INNER LOOP JOIN [ DemoTable ] t2 ON t1. ID ; Since I was running these queries on SQL Server 2019 CU1, the execution plans included the actual wait stats information related to the query execution. (Also see Greg's recent post about focusing on waits alone in general.). Test Configuration.

Education 55

Education Servers Testing Tuning 55

SQL Performance

FEBRUARY 3, 2020

While I got decent results in my first attempt, I wanted to see if I could improve the performance in part 2. I thought so too, but while. Simple, right? Except it's not that simple, since scheduler assignment is kind of like a box of chocolates. In part 1 of this series, I tried out a few ways to compress a 1TB table.

Speed 113

Speed Processing Servers Storage 113

SQL Performance

JUNE 10, 2020

In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. Recall that what triggered this series is some confusion that exists in the SQL Server community around named table expressions.

C++ 93

C++ Database Servers Code 93

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The Back Story.

Servers 90

Servers Media Cache Storage 90

SQL Performance

MAY 8, 2019

This article is the second in a series about T-SQL bugs, pitfalls and best practices. To demonstrate the classic substitution error, I’ll use a simple customers-orders scenario. This time I focus on classic bugs involving subqueries. Particularly, I cover substitution errors and three-valued logic troubles. Substitution error.

Best Practices 68

Best Practices C++ Code Servers 68

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. I have SQL Server 2019 CTP 3.2 Now that 2019 CTP 3.2

Servers 95

Servers C++ Testing Systems 95

Smashing Magazine

AUGUST 28, 2020

With this, you’ll have enough time to focus on the core aspect of your developing your application while Django handles the others for you. While it is not compulsory that you must have used Django, having experience with the basics of Django before continuing with this article will give you an advantage. It’s free and open source.

Virtualization 143

Virtualization Database Code Processing 143

SQL Performance

JANUARY 8, 2020

Last month I introduced the NULL as SQL's marker for any kind of missing value. I explained that SQL doesn't provide you with the ability to distinguish between missing and applicable (A-values) and missing and inapplicable (I-values) markers. I'll continue using the sample database TSQLV5 like last month in some of my examples.

Design 65

Design C++ Code Database 65

SQL Performance

APRIL 14, 2021

Often while reading his articles or posts, I shake my head and tell my wife, Lilach, that when I grow up, I want to be just like Paul. In the plan in Figure 1, most of the time is spent by the leftmost Nested Loops and Top operators, both executing in row mode. I love Paul White ’s work. CREATE OR ALTER FUNCTION dbo. BatchMe ON 1 = 0.

C++ 112

C++ Servers Testing Code 112

SQL Performance

APRIL 5, 2019

The IGNORE_DUP_KEY option for unique indexes specifies how SQL Server responds to an attempt to INSERT duplicate values: It only applies to tables (not views) and only to inserts. Loop integer = 1 , @N integer = 1 ; WHILE @N <= 1000. Loop integer = 1 , @N integer = 1 ; WHILE @N <= 1000. INSERT #Data. (

Storage 53

Storage Servers Engineering Testing 53

SQL Server According to Bob

JULY 23, 2016

This post is not about a specific SQL Server object but instead outlines a technique used in various locations to reduce contention while still providing thread synchronization. There are hundreds of locations throughout the SQL Server code base that must account for multi-threaded access. Example: spinlock ).

Cache 40

Cache Software Engineering Servers Code 40

SQL Performance

SEPTEMBER 2, 2021

SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. For example, it only supports a single-character delimiter, and it doesn’t return anything to indicate the order of the input elements. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1.

C++ 59

C++ Servers Testing Database 59

SQL Server According to Bob

FEBRUARY 10, 2019

. · Random connection failures from both SQL Authentication and AD based logins. SQL Server 2017 CU10 does not show behavior. · SQL Server 2017 CU12 exhibits the behavior. One of the first stops in debugging this issue is the SQL Server health session traces located in the /var/opt/mssql/log/system_health*.xel wait_info*.

Servers 40

Servers Network Database Systems 40

Sutter's Mill

MARCH 11, 2024

recommend using instead of C++ ( example ), so by definition addressing these four would address the immediate NIST/NSA/CISA/etc. However, that “70% of language memory unsafety CVEs” is misleading; for example, in figure 1, most of MITRE’s 2023 “most dangerous weaknesses” did not involve language safety and so are outside that denominator.

C++ 139

C++ Programming Code Java 139

Smashing Magazine

APRIL 1, 2020

With a traditional CMS, changes can be time-consuming, for example, to tweak a part of your site, you need to re-implement the entire CMS. With a traditional CMS, changes can be time-consuming, for example, to tweak a part of your site, you need to re-implement the entire CMS. Building A Web App With Headless CMS And React.

Open Source 103

Open Source Website Mobile Code 103

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. This White Paper is for informational purposes only. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40

SQL Server According to Bob

FEBRUARY 13, 2020

​​​​ For example, the client might compress or encrypt the data block associated with the WriteCmd and store the data in a compressed file format. ​​ While the name can be any string it is commonly a Guid accommodating the ​​ uniqueness requirements.

Servers 40

Servers Availability Transportation Database 40

SQL Server According to Bob

APRIL 25, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. While that is possible, how probable is it? After the talk, I opened up the floor for the audience to ask me questions.

Servers 40

Servers Database Processing Virtualization 40

SQL Server According to Bob

APRIL 21, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. While that is possible, how probable is it? After the talk, I opened up the floor for the audience to ask me questions.

Servers 40

Servers Database Processing Virtualization 40

SQL Server According to Bob

DECEMBER 31, 2018

How It Works: XEvent Output and Visualization SQL Server Management Studio Provides–“XE Profiler” Use the SSMS XEvent Profiler. Using SQL Server Management Studio (SSMS) and storing the events in a table requires reading the events, streaming to table storage followed by an order by event sequence query. event_sequence , sqlserver.

Efficiency 40

Efficiency Code Servers Cache 40

SQL Server According to Bob

MAY 21, 2020

SQL Server for Linux Performance Monitoring ​​ Improvements Last year I posted a blog ​​ with examples ​​ using ​​ Performance Co-Pilot, ​​ [link] , to monitor SQL Server on Linux.

Servers 64

Servers Monitoring Performance Metrics 64