Extended Properties Introduction
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
2013-09-27 (first published: 2011-03-17)
22,417 reads
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
2013-09-27 (first published: 2011-03-17)
22,417 reads
Need to understand new data? This article explains why - and how you can profile it efficiently
2013-02-25
24,184 reads
Of all the technical solutions to the problem of slowly changing dimensions, the T-SQL MERGE statement is one of the most elegant.
2011-06-20
39,685 reads
To finish this short series on extended properties a look at documenting sets of database objects
2011-04-05
8,561 reads
Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties
2011-03-29
11,685 reads
In this second article of a short series we look at using the Extended Properties which you have added to a database
2011-03-22
11,774 reads
When you are obliged to create a dimensional database for an SSAS cube, how can you do it as fast as possible?
2010-12-17 (first published: 2010-02-24)
17,027 reads
A cursor-free way of normalizing data from a denormalized data source into a database which uses "surrogate" IDs.
2010-01-25
5,584 reads
This article shows ways of getting feedback to your users when running a SQL Server agent job from an ASP.NET page
2009-09-16
9,185 reads
Tired of the truncated error history that is available for SQL Server Agent jobs in SSMS, here is a way to get deeper information - easily!
2009-09-09
39,701 reads
By Steve Jones
feresy – n. the fear that your partner is changing in ways you don’t...
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
Comments posted to this topic are about the item The Cloud Security Problem, which...
Hi, I'm not even sure whether this is possible. I've three tables, one containing...
Hi, I have a simple table with 5 columns as follows with about 80,000...