books

Technical Article

Free eBook: Inside the SQL Server Query Optimizer

  • Article

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.

5 (1)

You rated this post out of 5. Change rating

2020-12-09 (first published: )

54,472 reads

SQLServerCentral Article

The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman

  • Article

FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in a special folder on the NTFS file system, while bringing that data under the transactional control of SQL Server. This book describes both the way it works and the implementation, administration and troubleshooting of it.

4 (1)

You rated this post out of 5. Change rating

2012-11-12

546 reads

Technical Article

Free ebook: Troubleshooting SQL Server: A Guide for the Accidental DBA

  • Article

Merry Christmas from SQLServerCentral. We spend much of our working life helping solve SQL Server-related performance problems, hands-on, during consulting, or on online forums. We've seen a few weird-and-wonderful issues but, mainly, it’s the same problems and misconceptions time-and-again. This is our attempt to describe, diagnose, and solve the most common problems with SQL Server 2005, 2008, and 2008 R2. And it's free.

5 (3)

You rated this post out of 5. Change rating

2012-12-25 (first published: )

18,171 reads

Blogs

MSSQL Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database

By

Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...

Dynamic Warehouse & Lakehouse Connections in Microsoft Fabric Data Pipelines

By

When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...

New Pluralsight Course - Certified Kubernetes Administrator - Performing Cluster Version Upgrades

By

We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...

Read the latest Blogs

Forums

Sensitivity Ranks

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Sensitivity Ranks

Fine-grained Access Control for Stored Procedures

By maxtardiveau

Comments posted to this topic are about the item Fine-grained Access Control for Stored...

Strange behavior passing a variable in XML.value

By PatLap

Hi,  anyone would know why as soon as I add a WHERE statement (even...

Visit the forum

Question of the Day

Sensitivity Ranks

I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?

ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price,
    dbo.sales.discount
WITH (
    LABEL = 'Highly Confidential',
    INFORMATION_TYPE = 'Financial',
    RANK = 'INTERNAL ONLY'
);

See possible answers