SSIS Pivot on bad data
The pivot transform in SSIS is already a pain to use. When you have bad data it makes it even...
2013-10-31 (first published: 2013-10-28)
1,812 reads
The pivot transform in SSIS is already a pain to use. When you have bad data it makes it even...
2013-10-31 (first published: 2013-10-28)
1,812 reads
It’s one of those things that always aggravated me but not really enough to complain about. When you run a...
2013-10-28
720 reads
This past week I attended my third SQL PASS Summit in Charlotte, North Carolina. All I can say is – WOW....
2013-10-28
822 reads
Book Details:
SQL Server Transaction Log Management
Davis, Tony and Shaw, Gail
Simple Talk Publishing, October 2012.
Free PDF download
Do I Recommend This Book?
Yes,...
2013-10-28
2,906 reads
I had the honor to speak for the first time at this past PASS Summit 2013 in Charlotte, NC. It...
2013-10-27
881 reads
This year I was honored to sponsor and speak at IT Pro Camp Tampa 2013. Like always, it is a...
2013-10-27
913 reads
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-10-25
965 reads
The PIVOT function is very useful but not easily understood at first. I thank Itzik Ben-Gan, Dejan Sarka and Ron...
2013-10-25
3,117 reads
1. How to find the maximum no of connection allowed in SQL Server?
Select@@MAX_Connections
2. How to select top 2 rows without...
2013-10-24
1,105 reads
“Psssst….”
“Hey buddy! Yeah, you there in the propeller hat. You’re a SQL nerd, right? Can you help me tune this...
2013-10-24
934 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