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
499 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
692 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,132 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,215 reads
2013-09-20
621 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
509 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
417 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
986 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
636 reads
Blogs
When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
Prepping for Certification, Part 4 of 4
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Flyway Tips: Automation Assistance in Flyway Desktop
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
Forums
what are the downsides of TDE not running vs running?
hi for the 2 years i've been here I believe we've had "encryption" turned...
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers