Query tuning 101: Problems with IN ()
If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...
2016-11-14 (first published: 2016-11-10)
5,726 reads
If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...
2016-11-14 (first published: 2016-11-10)
5,726 reads
I am in the middle of some research regarding CHECKDB and learnt something new. From SQL Server 2014 onwards the...
2016-11-10
470 reads
One of the coolest things to release with SQL Server 2016 was “Number of Rows Read” information in execution plan....
2016-11-10
850 reads
Has anyone in my network or readers my blog have any experience of a database called Firebird?
If you have and...
2016-11-09
392 reads
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-11-09
426 reads
Abstract
This article details the use of “Execute AT LinkedServer” clause. It’s best in some ways when you are trying to run...
2016-11-09
1,920 reads
I know that more and more of you are moving more and more resources into the Azure Data Platform. In...
2016-11-09
625 reads
Following up on my notes about the 2016 SQLSaturday Roundtable I wanted to write more about the ROI of SQLSaturday....
2016-11-09
483 reads
I was working with a developer the other day and he was typing out each table name and all the...
2016-11-09
1,097 reads
This weeks Learning Tree deals are in. If you want to learn about big data, Network security and with the...
2016-11-09
418 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