Understanding SQL Server Query Optimization – Part 3
A critical part of database design and management is index design. Index design involves balancing space requirements and the resource...
2013-12-14
501 reads
Basit Aalishan Masood-Al-Farooq
Understanding Triggers
A trigger is a specialized stored procedure that activates (executes) in response to an event. There are two basic trigger...
2013-12-14
693 reads
Back to basics: Transact-SQL programming fundamentals – (Part 1)
SQL Server users use Transact-SQL programming to create sets of statements for ad-hoc execution. The aim of the Transact-SQL programming...
2013-10-22
1,134 reads
Back to basics: Transact-SQL programming fundamentals – (Part 2)
In the first of this three-part series, you will learned how to use scripts and batches, and basics of T-SQL...
2013-10-22
1,216 reads
2013-09-20
622 reads
Guide to SQL Server Table Indexes – (Part 4)
Checkout the part-4 of my five part article series on Guide to SQL Server Table Indexeshere, in which you will learn...
2013-09-17
511 reads
Manage your SQL Server databases with SQL DMVs
Microsoft ships SQL Server with several built-in tools that database administrators (DBAs) can use to manage their SQL Server environment....
2013-09-17
811 reads
Planning for Recovery
A database server is generally a mission critical component. Having a recovery plan is essential to ensure the business can...
2013-09-17
418 reads
Understanding SQL Query Optimization – (Part 1)
Most of the activity of the database server is related to queries. Because of this, query optimization is often a...
2013-09-17
987 reads
Understanding SQL Server Full-text Indexing – (Part 1)
SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....
2013-09-17
637 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
The Side Job
Comments posted to this topic are about the item The Side Job
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers