SQLStudies

I came across this handy dandy little setting earlier this year. It was well hidden from me, by which I...

2012-08-27

649 reads

keyword DEFAULT

In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and...

2012-08-20

1,335 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...

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

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...

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?