Introduction to Integrity: Data Purity Errors
The final day of this six part series, Introduction to Integrity, sponsored by Idera and their new free tool SQL...
2013-09-19
1,122 reads
The final day of this six part series, Introduction to Integrity, sponsored by Idera and their new free tool SQL...
2013-09-19
1,122 reads
I feel rather flat today. I passed the 3rd entry level 2012 exam a few hours ago, data warehousing to...
2013-09-19
719 reads
This one is just a quick shout-out to Pragmatic Works, and to Sean. Pragmatic Works made DTS xChange, which I...
2013-09-19
531 reads
However I posted this one in one of my post.
Querying Microsoft SQL Server : Functions in SQL Server: Functions in SQL...
2013-09-19
628,730 reads
When extracting Dacpacs it’s quite straightforward to go through the UI and extract, however what if you want to do this for more than one database, or automate the...
2013-09-19
69 reads
So it is done, it being my first presentation at a professional event. As you may recall, I recently presented...
2013-09-18
335 reads
I ran across a twitter conversation about a post recently. The post talks about detaching or attaching databases in bulk....
2013-09-18
1,122 reads
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The...
2013-09-23 (first published: 2013-09-18)
2,472 reads
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The...
2013-09-23 (first published: 2013-09-18)
2,098 reads
I was presenting a session on how to read execution plans when I received a question: Do you have a...
2013-09-20 (first published: 2013-09-18)
3,429 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