Query Store and What Happened Earlier On Your Server
Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what...
2016-10-06 (first published: 2016-09-26)
1,881 reads
Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what...
2016-10-06 (first published: 2016-09-26)
1,881 reads
Everyone has goals or at least they should have goals. As a young professional out of college, I had plenty...
2016-09-26
585 reads
Over the weekend, I went to the local theater to watch Sully, the movie about the US Airways pilot who...
2016-10-05 (first published: 2016-09-26)
1,325 reads
As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve...
2016-09-26
613 reads
In our last blog on Hadoop Big Data we have discussed about Hadoop and its tools/utility to connect to HDFS. on...
2016-09-26
610 reads
This has bit a couple of clients recently, figured I'd put out a PSA.
Express editions of SQL Server Reporting Service,...
2016-10-04 (first published: 2016-09-25)
2,167 reads
If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and...
2016-10-04 (first published: 2016-09-24)
3,785 reads
This may feel very
simple to many developers and yes it is, but I saw this request somewhere in community
website.So thought...
2016-09-24
953 reads
This is a story of my 11-year association with PASS, and the many ways it helped me grow as a...
2016-09-23
455 reads
With just 1 week until SQLSaturday Portugal Porto 2016, I am glad to share that we have SQLSaturday Lisbon 2017...
2016-09-23
473 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