Handling Data Integrity Issues in Analysis Services 2005
Learn about common data integrity issues, and see how Analysis Services 2005 gives you the tools to handle them.
2008-04-04
1,985 reads
Additional Articles
Tame Your Software Dependencies for More Flexible Apps
Few would disagree that striving for a loosely coupled design is a bad thing. Unfortunately, the software we typically design is much more tightly coupled than we intend. How can you tell whether your design is tightly coupled?
2008-04-04
1,816 reads
Find blocking processes using recursion in SQL Server 2005
Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set (or subset) of records. This can create a daisy-chain of processes waiting to complete their work.
2008-04-03
3,069 reads
Implementing Error Handling with Stored Procedures
A look at how you can implement error handling in your stored procedures.
2008-04-03
4,813 reads
SQL Server Index Checklist
Indexing a SQL Server database in some respects is considered both an art and a science. Since this is the case, what are some considerations when designing indexes for a new database or an existing one in production? Are these the same types of steps or not? Do any best practices really exist when it comes to indexing? Where does indexing fall in the priority list from an application or production support perspective?
2008-04-03
4,878 reads
Nuggets from My SSIS Experience
An article that speaks about some of the issues faced by the Author, during his Data Integration Project using SSIS. Shared with you in this article are the issues he was faced with and the solutions applied.
2008-04-02
3,879 reads
2008-04-02
2,786 reads
Why Read-only Table Parameters is Not Enough
In this article I discuss a new feature in SQL 2008, table-valued parameters and particularly the restriction that they have to be read-only. I argue that this makes this feature considerably less useful that it could be, and that in order to build scalable applications be able to pass read-write table parameters between stored procedures is essential.
2008-04-02
2,677 reads
2008-04-01
4,967 reads
SQLskills.com Announces Time-Setback Technology for DBAs
Today, in a surprise development that has stunned industry analysts, SQLskills.com announced a new technology for DBAs that will help in the never-ending battle against human-error and unforeseen disasters. The patent-pending Time-Setback technology allows DBAs of SQL Server to literally rewind time and avoid disasters before they happen.
2008-04-01
2,298 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers