Slowly Changing Dimension in SQL Server 2005 – Part 2
This article is Part 2 in the series which explores the options available in SQL Server 2005 for Slowly Changing Dimensions
2008-07-02
2,805 reads
Additional Articles
Deploying Database Developments
When a team is developing a database application, it is a mistake to believe that deployment is a simple task. It isn’t. It has to be planned, and scripted. Alexander Karmanov describes many of the problems you’re likely to meet, and provides an example solution that aims to save the DBA from the nightmare complexity of an unplanned deployment.
2008-07-01
3,321 reads
The Curse and Blessings of Dynamic SQL
How you use dynamic SQL, when you should - and when you should not.
2008-07-01
4,990 reads
How insiders hack SQL databases with free tools
When you find out how easy it is for insiders to hack SQL Server databases with a few free security tools and a little luck, you'll re-examine your database security practices.
2008-06-30
8,714 reads
How To Return a Result Set from a SQL Server 2005 CLR Stored Procedure
We occasionally come up with a requirement that would be a good fit for a CLR function or stored procedure. For instance we would like to call a stored procedure to get the list of files in a particular folder. How can we return the list of files as a standard result set (i.e. rows and columns) using the CLR?
2008-06-30
4,802 reads
Many-to-Many Dimensions in Analysis Services 2005
See an example of using the Many-to-Many dimension in SQL Server 2005 Analysis Services to analyze sales data, and get ideas for other uses such as treating medical conditions, software testing, and more.
2008-06-27
2,788 reads
SQL Server memory configurations for procedure cache
SQL Server expert Denny Cherry explains how SQL Server determines how much memory is used for procedure and buffer cache and how you can allocate available memory.
2008-06-27
4,307 reads
Check your SQL Server using Windows PowerShell – Part 1
This new series examines methods and procedures to check the status of the Operating system, SQL Server instances and databases, using Windows PowerShell. Part One illustrates how to create a PowerShell script to ping the host machine and how to source the PowerShell function and call the function.
2008-06-26
4,215 reads
Create a computed column in SQL Server using XML data
Create a computed column in SQL Server using XML data and optimize SQL queries. Learn how to create a function for XQuery and use it within the computed column formula.
2008-06-25
3,199 reads
Taming Trees: B-Trees
Learn how to build a B-tree similar to those used by databases to implement indexes.
2008-06-25
3,117 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Pulogadung Telpon/WA:085188120691
BCA KCP Pulogadung Telpon/WA:085188120691 Jl. Raya Bekasi No.B-C Km.19 No.30, RT.1/RW.6, Wil, Kec. Pulo...
BCA KCP Klender Telpon/WA:085188120691
BCA KCP Klender Telpon/WA:085188120691 Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec....
BCA KCP Permata Ujung Menteng Telpon/WA:085188120691
BCA KCP Permata Ujung Menteng Telpon/WA:085188120691 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers