T-SQL Tuesday #75: Round Up
This month I challenged the blogging community to share their own creations in Power BI. We got a ton of...
2016-02-26 (first published: 2016-02-22)
1,561 reads
This month I challenged the blogging community to share their own creations in Power BI. We got a ton of...
2016-02-26 (first published: 2016-02-22)
1,561 reads
I had one of my developers ask me why he keeps seeing the following warning when he tries to modify...
2016-02-22
1,166 reads
Database servers have to wait on different resources, and these waits are huge to the performance of SQL Server. Sometimes something changes without our knowledge and is running differently...
2016-02-22
33 reads
Database servers have to wait on different resources, and these waits are huge to the performance of SQL Server. Sometimes...
2016-02-22
696 reads
2016-02-21
288 reads
So you’ve been working as a DBA or a BI developer for several years now. You know your stuff very...
2016-02-21
369 reads
As you read in my earlier post, I am delivering a couple of precons in Tampa, FL and Richmond, VA. ...
2016-02-19
1,264 reads
2016-02-19
523 reads
This is hardware week for me, with a new phone coming in the mail. This was a warranty replacement for...
2016-02-18
774 reads
I’m running a flash sale discount for my upcoming Chicago SQL Saturday Precon called ‘SQL Server Infrastructure Tuning for Availability...
2016-02-18
470 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