TOP vs Max/Min: Is there a difference?
Is there a difference between using TOP and MAX/MIN to return and end value to a table?
2020-08-14 (first published: 2018-12-17)
7,847 reads
Is there a difference between using TOP and MAX/MIN to return and end value to a table?
2020-08-14 (first published: 2018-12-17)
7,847 reads
2018-12-04
1,057 reads
2018-11-29
1,141 reads
Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version.
2018-11-29
637 reads
A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.
2021-04-09 (first published: 2018-11-27)
16,106 reads
2018-11-20
730 reads
Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.
2018-11-15
927 reads
2018-11-08
1,814 reads
2018-11-07
943 reads
2018-10-19
1,053 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...
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 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers