The Scary DBA

Blog Post

Six Months!

Oh good gosh. Six months without a single blog post. Most important information: I’m not dead. Apologies. The issue is pretty simple. I’m getting old. Ha! Seriously though, I...

2024-06-17

23 reads

Blog Post

Query Store Reports Time Intervals

A great question came up over at DBA.StackExchange regarding the query store reports time intervals: How can SQL Server’s Query Store Reports show data for minute-length intervals, when “Statistics...

2023-11-24 (first published: )

250 reads

Blogs

Can I Change a Primary Key Value? #SQLNewBlogger

By

I heard someone say recently that you can’t change a primary key value in...

SQL Server Index Primer

By

Indexes 101: What, Why, and When? “What Is an Index?” I get this question...

Secure Azure SQL Server Backups Using Managed Identities

By

I do believe most people know about the ability to backup your SQL server...

Read the latest Blogs

Forums

Update particular record in a table

By dhanekulakalyan

I need to update greatherthan8 (category) record to Missing (status) if the same member...

Internationalisation

By julian.fletcher

Quick one I hope in case I'm heading off in entirely the wrong direction!...

Size of DB on physical disk doesn't match Disk Usage by Table report

By water490

Hi everyone I am looking at the size of my db on disk (ie...

Visit the forum

Question of the Day

Getting the TEXTSIZE

How can I check what value I used for TEXTSIZE? I ran this code:

SET TEXTSIZE 8096
But then deleted the code and couldn't remember. Is there a way to check this?

See possible answers