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
505 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
701 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,138 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,220 reads
2013-09-20
624 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
522 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
818 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
430 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
992 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
641 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers