Most Popular Databases

SQL Server Internals: Peeking Inside the Transaction Log Structure, Part 2

In part one of this topic, “Peeking Inside the Transaction Log Structure,” I told you about the organization of a SQL Server® database’s transaction log. Understanding this structure will help you keep your log from growing unmanageably large, and help you shrink it if the need arises. Ideally, you’ll find a good size for your […]

Read More

Avoiding Common SQL Server Performance Problems

A lot of different factors go into SQL Server® performance, which can make troubleshooting performance problems difficult. However, there are many common SQL Server deployment mistakes that can impact SQL Server performance. In this presentation, you’ll learn about some of the common mistakes that can degrade SQL Server performance and how to avoid them. You’ll […]

Read More

First Look at SQL Operations Studio

Since the release of SQL Server® 2017 on Linux®, DBAs have been waiting for a native release of SQL Server Management Studio (SSMS) on Linux. At this point, Microsoft has stated that they have no plans for a native Linux version of SSMS. However, they have just released a preview version of SQL Operations Studio, […]

Read More

–Index B-Tree Analysis, Part 3

/************************************************************************************ This script explores row compressed non-clustered indexes and the use case when the Primary Key and Clustered Index are not the same (with options) at the page level. Most likely, the page ids used here will change in your database configuration and setup—mine rarely used same page ids even with repetitive usage. However, the […]

Read More

IN vs. OR: Which performs better?

The title describes what I started up to do, but as usual, I like to experiment with queries to see if I can beat the optimizer for an acceptable query plan. Initially I thought the OR clause described below would be the best solution, but with a little experimentation, I found the order of columns […]

Read More

SQL Server on Linux – Jump Start 5: SSIS on Linux

In this presentation, you’ll learn how to install and run SQL Server® Integration Services (SSIS) on SQL Server® 2017 for Linux®. First, you’ll hear about some of the features and limitations of SSIS on Linux. Then you’ll learn how to develop and run SSIS packages on SQL Server for Linux using SQL Server Data Tools […]

Read More

A Layman’s Guide to Climbing the SQL Server Index B-tree (Part 2)

Read Part 1 Read Part 3 This is a continuation of Climbing the SQL Server Index B-tree. In Part 1, we dove down into the SQL Server® pages for a Clustered Index in the Sales.SalesOrderDetail table in the AdventrueWorks2012 database. In this paper, we will look at the data pages of the same table/database for unique-nonclustered […]

Read More

A Layman’s Guide to Climbing the SQL Server Index B-tree (Part 1)

Read Part 2 Read Part 3 The term “geek” applies to me because I am always wondering/tinkering with things that I don’t readily understand. Recently, I’ve become intrigued with “what’s under the covers” with SQL Server Indexes. Part 1 of this paper will dive down and look at the important items on each data page […]

Read More
710