Why Data Warehouse Projects Fail
Data warehouse projects are among the most visible and expensive initiatives an organization can undertake. Sadly, they are also among...
2017-01-10
1,112 reads
Data warehouse projects are among the most visible and expensive initiatives an organization can undertake. Sadly, they are also among...
2017-01-10
1,112 reads
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I wanted to highlight this one about adding the date...
2017-01-10
22 reads
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I wanted to highlight this one about adding the date...
2017-01-10
16 reads
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I...
2017-01-10
444 reads
Let’s kick off the new year with a T-SQL Tuesday! This month’s edition is hosted by Brent Ozar:
Announcing T-SQL Tuesday...
2017-01-10
495 reads
T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests hosted by Brent Ozar. https://www.brentozar.com/archive/2017/01/announcing-t-sql-tuesday-87-sql-server-bugs-enhancement-requests/ I did not want to miss out...
2017-01-10
645 reads
This month’s T-SQL Tuesday is hosted by Brent Ozar and he’s asked everyone to find interesting bug or enhancement requests in Microsoft Connect related to SQL Server.
The Connect item doesn’t have...
2017-01-10
24 reads
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-01-09
565 reads
It’s a new year, and the perfect time for you to start blogging about your SQL Server work. I think...
2017-01-09
740 reads
SQL Saturday Vienna 2017 is only just around the corner.
On Friday, January 20, 2017, a lot of local and international...
2017-01-09
413 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