PASS Summit 2016 – call for Speakers…
PASS Summit 2016 is the biggest, largest, highest rated summit in the World for the Microsoft SQL Server & BI professionals,...
2016-02-05
815 reads
PASS Summit 2016 is the biggest, largest, highest rated summit in the World for the Microsoft SQL Server & BI professionals,...
2016-02-05
815 reads
On Wednesday, December 16, I presented on this topic at the Minnesota BI User Group. This session is based on...
2016-02-04
565 reads
I’m sitting in the classroom of SQL Cruise listening to Tim Ford (b|t) explain mechanisms for monitoring indexes. It’s a...
2016-02-04
563 reads
Continuation from the previous 75 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
While playing with SQL Server 2016 CTP...
2016-02-04
800 reads
Do people still get certified? I don’t hear much about it in the SQL community these days so I asked...
2016-02-04
515 reads
Loading text files is a skill that probably every DBA needs. I know that the import wizard is available, but...
2016-02-04
1,237 reads
This first post of 3 takes a quick peek at SSRS 2016 using the Community Technical Preview (CTP) 3.2. I...
2016-02-03
1,350 reads
One of the advantages Azure SQL Database has over on-prem SQL Server is the ease in which it can scale. I’ll...
2016-02-03
808 reads
I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a...
2016-02-03
576 reads
One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a...
2016-02-03
632 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...
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