SQLCLR vs. SQL Server 2017, Part 2: “CLR strict security” – Solution 1
As mentioned in Part 1 of this “SQLCLR vs. SQL Server 2017” series, the new clr strict security server-level configuration...
2017-08-09
953 reads
As mentioned in Part 1 of this “SQLCLR vs. SQL Server 2017” series, the new clr strict security server-level configuration...
2017-08-09
953 reads
The Good, the Bad, and the Ugle¯e¯ (need to avoid copyright infringement ?? )
SQL Server 2017 is soon to be officially...
2017-08-07
2,338 reads
In SQL Server Management Studio (SSMS), there are a lot of options and functions. In fact, there are so many...
2017-07-20
2,005 reads
SQL Server Management Studio (SSMS) for SQL Server 2016 added some interesting enhancements for the vertical scroll bar: Map Mode...
2017-07-17
593 reads
Quite often people will use, or will recommend using, a binary Collation (one ending in “_BIN” or “_BIN2“) when wanting...
2017-07-13
2,100 reads
You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them...
2017-07-10
4,940 reads
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
By Arun Sirpal
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 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers