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
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
Which Pench Safari Package Is Right for You in 2026?
Planning a wildlife adventure in Pench National Park can be exciting yet overwhelming, especially...
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers