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,505 reads
Adam Aspin
Data Profiling with T-SQL
Need to understand new data? This article explains why - and how you can profile it efficiently
2013-02-25
24,395 reads
Slowly changing dimensions using T-SQL MERGE
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,924 reads
Industrial-strength database documentation using Extended Properties
To finish this short series on extended properties a look at documenting sets of database objects
2011-04-05
8,571 reads
Modifying and deleting extended properties
Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties
2011-03-29
11,754 reads
Extracting Extended Properties
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,845 reads
A faster way to prepare dimensional databases
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,038 reads
Fast normalization of a denormalized data source, using surrogate IDs
A cursor-free way of normalizing data from a denormalized data source into a database which uses "surrogate" IDs.
2010-01-25
5,591 reads
SQL Server Agent Jobs – Displaying Status in an Application
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,194 reads
Returning full error details from SQL Server Agent jobs
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,910 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002; See possible answers