Stairway Series

Stairway to SQLCLR

Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

  • Stairway Step

In the second level of our Stairway to SQLCLR, we look at how to enable the SQLCLR in SQL Server. We then build an assembly, store procedure, and a function that can be called from your T-SQL code.

5 (6)

You rated this post out of 5. Change rating

2020-07-09 (first published: )

22,523 reads

Stairway to SQL Server Indexes

Pages and Extents: Stairway to SQL Server Indexes Level 4

  • Stairway Step

We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.

5 (1)

You rated this post out of 5. Change rating

2019-03-29 (first published: )

17,322 reads

Blogs

EightKB 2024 – Schedule and Registration

By

Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...

Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory

By

I had a customer that was looking to document a restore that had occurred...

T-SQL Tuesday #176: That Piece of Technical Advice for the Past Me

By

DIVERSIFY! We devote a lot of time to mastering the technology that we are...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers