Born SQL with Randolph West

If there’s one thing that SQL Server is really good at, it’s relationships. After all, a relational database management system...

2017-04-05

105 reads

A First Look At Normalization

Phew! There’s a lot to take in with data types, collation, precision, scale, length, and Unicode, and we’re just getting...

2017-03-29

309 reads

Last week, we discussed storing text in a database. This week we will dive deeper into data types. When storing...

2017-03-22

99 reads

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

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

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

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

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

Comments posted to this topic are about the item 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?