Slowly Changing Dimensions in SQL Server 2005
This article explores the options available in SQL Server 2005 for Slowly Changing Dimensions.
2008-05-07
3,048 reads
Additional Articles
Simplify SQL Server 2005 queries with a Dates table
Learn what a Dates table is and how to create one, and then try it out for yourself
2008-05-06
5,831 reads
SQL Server source code analysis and management adds database security
SQL Server source code analysis and management add database security by debugging and testing SQL applications. Learn about SQL source code analysis.
2008-05-06
2,617 reads
SQL Server 2008 (Katmai) Reporting Services Performance: Two Steps Forward, One Step Back?
In this article, David Leibowitz compares the performance of the prerelease of Microsoft's SQL Server 2008 Reporting Services to SSRS 2005. While it is clear performance improvements have been made for report automation, developers might have differing opinions on the new Report Designer.
2008-05-05
4,012 reads
SqlCredit – Part 15: The Cost of Distribution
Part 15 of this series examines what cost is paid when tables are separated into multiple databases on the same server.
2008-05-05
2,879 reads
Introduction to MDX Scripting in Microsoft SQL Server 2005
This document describes how Multidimensional Expressions (MDX) for Microsoft SQL Server 2005 can be applied to common business problems. This document assumes some familiarity with MDX.
2008-05-02
3,531 reads
Using Indexes to Bypass Locks
One of the issues you'll face with SQL Server is blocking which is caused by other processes that are holding locks on objects. Until the locks are removed on an object the next process will wait before proceeding. This is a common process that runs within SQL Server to ensure data integrity, but depending on how transactions are run this can cause some issues. Are there ways to get around blocking by using different indexes to cover the queries that may be running?
2008-05-02
3,383 reads
Configure SQL Server Service Broker for Sending Stored Procedures
Set up SQL Server 2005 Service Broker for a messaging platform to queue data of stored procedures and functions. Configure Service Broker with these steps.
2008-05-01
2,758 reads
SQL Server 2008’s Management Data Warehouse
This article looks at the new Management Data Warehouse (MDW) that is incorporated into SQL Server 2008. This warehouse is performance analysis and capacity planning tool for DBAs. This article will discuss the basic architecture of the MDW and how to set it up using a wizard.
2008-05-01
2,161 reads
Custom job categories to organize your SQL Agent jobs
Sometimes the tools that Microsoft provides us with do not give us complete control over the organization of our environment. Such is the case with organizing SQL Agent Jobs. We are able to organize and sort jobs by a variety of factors:
2008-04-30
2,633 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers