Sql-Server

Category: sql-server

SQL Server Management Studio Is as Relevant as Ever

SQL Server Management Studio Is as Relevant as Ever

By Kendra Little on August 14, 2019

Category: database-administration , sql-server
Tags: ssms , azure-data-studio , sql-server-tools , database-administration

šŸ”„ UPDATE: Azure Data Studio (ADS) was retired on February 6, 2025, with support ending on February 28, 2026. Additionally, SSMS has been modernized and is no longer based on the legacy Visual Studio shellā€”it's now built on Visual Studio 2022 with 64-bit support and improved performance.

For more details, see the Azure Data Studio retirement announcement and Erin Stellato's announcement about SSMS modernization..

Sometimes you keep a classic around.

Continue reading

The SQL Server Data Row Size Question: Why Is It Bigger?

The SQL Server Data Row Size Question: Why Is It Bigger?

By Kendra Little on March 19, 2019

Category: database-administration , sql-server
Tags: row-versioning , snapshot-isolation , readable-secondaries , availability-groups , row-size

This morning, I received the following question from a user:

Could you please clarify SQLServer “Data Row” size: If I run the script below on SQL Server 2012, then Slot(row) Size is 710 bytes if I run the same script against SQL Server 2016 and above, then Slot(row) Size is 724 bytes.

They then provided a script which creates and inserts a few rows into a sample table, runs the DBCC IND command to find a list of pages for the sample table, then uses the DBCC PAGE command to examine the page.

Continue reading

Why You Shouldn't Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures

Why You Shouldn't Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures

By Kendra Little on March 18, 2019

Category: tsql-programming , sql-server
Tags: deferred-name-resolution , database-dependencies , stored-procedures , views , functions

I recently published Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures over on Simple Talk.

Continue reading

Fix My Functions: Speeding Up Scalar and Table Valued UDFs (video)

Fix My Functions: Speeding Up Scalar and Table Valued UDFs (video)

By Kendra Little on November 14, 2018

Category: tsql-programming , sql-server
Tags: user-defined-functions , udf , scalar-functions , table-valued-functions , sql-server-2019 , udf-inlining , pass-summit

Last week, I presented on the topic of TSQL User Defined Functions (UDFs) in SQL Server at the PASS Summit.

Continue reading

ORDER BY, OFFSET, and Fetch in TSQL

ORDER BY, OFFSET, and Fetch in TSQL

By Kendra Little on June 29, 2018

Category: tsql-programming , sql-server
Tags: order-by , quiz-results , offset , fetch

My most recentĀ QuizletterĀ featured a quiz on ORDER BY in TSQL, complete with questions on the OFFSET and FETCH clauses which we got in SQL Server 2012.

One great thing about teachingĀ TSQL SchoolĀ is that it reminds me of these cool options that can be easy to forget.

Continue reading

AVG() in TSQL: Watch Your Data Types

AVG() in TSQL: Watch Your Data Types

By Kendra Little on June 21, 2018

Category: tsql-programming , sql-server
Tags: avg , data-types , quiz-results , aggregate-functions

This week’s QuizletterĀ featured a quiz on using the AVG() function in SQL Server.

I was inspired to write this quiz because I’ve been teaching “TSQL School” each week. When we covered aggregate functions, I remembered how tricksy AVG() can be.

Continue reading

Query Store Cleanup Can be Part of a Blocking Chain

Query Store Cleanup Can be Part of a Blocking Chain

By Kendra Little on April 18, 2018

Category: query-store , sql-server
Tags: blocking , cleanup

Forgetfulness can lead to learning something new. This is a bit of a nightmare when it happens in production, but a treat when it happens in an isolated test system– and that’s how I learned this.

I left a bit of blocking open on my test VM, and forgot about it.

Continue reading