Get list of dates using recursive Common Table Expression (CTE)
Many times we need a list of consecutive dates or time at runtime mainly for a recursive ETL process. This...
2013-10-23
1,141 reads
Many times we need a list of consecutive dates or time at runtime mainly for a recursive ETL process. This...
2013-10-23
1,141 reads
I was asked by some attendees of my PASS 2013 Session, Unseen Minions : Improving parallel processing in SSIS, if I had any...
2013-10-22
465 reads
I’ve been working on an automated data compare process for one client. I’ve been struggling a little with odd hangups...
2013-10-22
1,155 reads
Windows 8.1 was released to the Windows Store last week and aside from having to download the same 3.9 GB...
2013-10-22
1,225 reads
In the first of this three-part series, you will learned how to use scripts and batches, and basics of T-SQL...
2013-10-22
1,225 reads
SQL Server users use Transact-SQL programming to create sets of statements for ad-hoc execution. The aim of the Transact-SQL programming...
2013-10-22
1,142 reads
I have had the pleasure of taking my son with me on a number of trips where I was a...
2013-10-22
839 reads
Adam and I attended PASS Summit for the first time this year in Charlotte, NC. We had a great time and enjoyed meeting new people. The following are a...
2013-10-22
15 reads
Adam and I attended PASS Summit for the first time this year in Charlotte, NC. We had a great time and enjoyed meeting new people. The following are a...
2013-10-22
33 reads
Adam and I attended PASS Summit for the first time this year in Charlotte, NC. We had a great time...
2013-10-22
956 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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