Data Profiling with T-SQL
Need to understand new data? This article explains why - and how you can profile it efficiently
2013-02-25
25,964 reads
Need to understand new data? This article explains why - and how you can profile it efficiently
2013-02-25
25,964 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
42,301 reads
To finish this short series on extended properties a look at documenting sets of database objects
2011-04-05
8,747 reads
Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties
2011-03-29
12,405 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
12,507 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,235 reads
Reporting Services provides a robust reporting platform that rivals many other products. New author Adam Aspin stars a series on how you can dress up your reports and maintain good development practices.
2010-10-08 (first published: 2009-02-26)
33,911 reads
A cursor-free way of normalizing data from a denormalized data source into a database which uses "surrogate" IDs.
2010-01-25
5,763 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,431 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
43,889 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers