Times have changed for the SQL Server® DBA. Not so long ago, SQL Server was a Windows-only application, and the SQL Server DBA didn’t really need to worry about other platforms. The toolset needed to manage SQL Server was well known and had been around for a quite a while. That all changed with the […]
Read More
Don’t believe everything you read on the web about clustered vs. nonclustered indexes I suspect almost every reader of this article has seen or heard the following, as it is posted “everywhere” on the web. Yet if the advice is taken blindly, it can rob your system of top performance. Every table should have a […]
Read More
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
SQL Server® has been around for over 30 years, and I’ve been working with it for almost as long. I’ve seen a lot of changes over the years (and decades!) to this incredible product. In these posts, I’ll share with you how I look at some of the features or aspects of SQL Server, sometimes […]
Read More
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
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
In Part 1 of this series, we looked at a brief description of in-memory tables, the syntax for creation, and benchmarked data insertion and update. Part 2 will continue with a concentration on the SELECT statement for benchmarking, and also touch on in-memory stored procedures. In-Memory SELECT Performance For the purpose of the following […]
Read More
I’ve always been fascinated by performance, and my careers and hobbies have shown this. I’ve been a rocket scientist, sports car driver, USAF fighter pilot, and now a SQL Server® geek. When in-memory tables first came out in SQL Server 2014, I was highly intrigued by the prospect of something that did not require the […]
Read More
/************************************************************************************ 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
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
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
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