T-SQL Tuesday #48 Roundup
A big thanks to everyone who participated in this month’s T-SQL Tuesday (link) blog party. This month’s topic was to...
2013-11-19
814 reads
A big thanks to everyone who participated in this month’s T-SQL Tuesday (link) blog party. This month’s topic was to...
2013-11-19
814 reads
There is a wealth of information about SQL Server online. Absolutely hundreds of blogs, white papers, editorials, the list goes...
2013-11-19
435 reads
If you’ve followed along to this point, and have assembled the pieces as I’ve given them to you, you’re now...
2013-11-26 (first published: 2013-11-19)
3,873 reads
Microsoft has released SQL Server 2012 Service Pack 1 Cumulative Update 7, which is Build 11.0.3393.0. This CU has 47...
2013-11-19
2,418 reads
Let's look at something a bit more in depth. Let me start by saying, "Please don't arbitrarily change any default...
2013-11-25 (first published: 2013-11-19)
2,247 reads
I feel really bad that I’ve not been able to blog recently. My draft area is littered with half written...
2013-11-19
738 reads
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-11-19
352 reads
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-11-19
589 reads
I’ve been a bit lapse in posting what I am up to recently. For example, I completely missed blogging about...
2013-11-19
718 reads
It’s funny to me how easy it is to fail a phone screen – both as the interviewer, and as the...
2013-11-29 (first published: 2013-11-18)
4,167 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