Normalization & Denormalization
Normalization & Denormalization Someone asked me about this basic thing which we generally do not think much, so realize that should...
2012-09-04
1,342 reads
Vinay Thakur
RAID (Redundant Array Independent Disk)
RAID (Redundant Array Independent Disk) As disk/storage plays a very important role in any application, everything is saved on disk...
2012-08-17
906 reads
Denali – Memory: “any size” page allocations
I blog introduction to Memory here. Considering you already know memory concept, till sql server 2008 R2, memory management is divided...
2012-07-12
903 reads
Different ways to move Sql Server file location
Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons,...
2012-07-11
1,020 reads
Download: Consolidated Denali a Day – May 2012
Download: Consolidated Denali a Day – May 2012 If you like what’s New in Denali (Sql server 2012) a day, for...
2012-06-05
933 reads
Denali – Day 31: Discontinue and Breaking/Behavior change features
Denali – Day 31: Discontinue and Breaking/Behavior change features Discontinue Features: As discussed about Deprecated will going to discontinue with that...
2012-05-31
1,748 reads
Denali – Day 30: Deprecated Features
Denali – Day 30: Deprecated Features Deprecated feature means these features are available in the current version of Sql server but...
2012-05-30
2,658 reads
Denali – Day 29: Resource Governor Enhancements (Database Engine)
Denali – Day 29: Resource Governor Enhancements (Database Engine) Introduction to Resource Governor: Resource Governor is a feature introduced in sql...
2012-05-29
1,645 reads
Denali – Day 28: CDC for ORACLE
Denali – Day 28: CDC for ORACLE Sql server has provided a great features for changes monitoring as Change data Capture...
2012-05-28
1,347 reads
Denali – Day 27: System Center Advisor (aka ‘Atlanta’)
Denali – Day 27: System Center Advisor (aka ‘Atlanta’) As Microsoft is working more on Cloud base system, on that basis...
2012-05-27
1,003 reads
Blogs
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers