Good Advice on "Certification"
Buck Woody (blog | twitter) is often seen as one of the wise men of the SQL Server community and with...
2013-09-13 (first published: 2013-09-10)
2,646 reads
Buck Woody (blog | twitter) is often seen as one of the wise men of the SQL Server community and with...
2013-09-13 (first published: 2013-09-10)
2,646 reads
Trending database and table sizes helps give you an idea of what to expect, and, sometimes, points out problems and...
2013-09-11 (first published: 2013-09-10)
4,147 reads
Are you ready for some SQL? If you are like me, you are probably almost always ready for some SQL. Well, we have just what you are hungry...
2013-09-10
12 reads
Are you ready for some SQL?
If you are like me, you are probably almost always ready for some SQL. Well,...
2013-09-10
690 reads
It’s the first Monday of September and it’s time to check up on your SQL Servers. In truth, it’s the...
2013-09-09
523 reads
Windows Azure Virtual Machines is a real game changer as it gives us ability to spin up VMs in no...
2013-09-09
1,379 reads
So I’m studying a lot these days, and I find myself evaluating and reconsidering the theories of “study” that I’ve...
2013-09-09
701 reads
This post is to help you out in finding UpTime of one or more computers also you can pass file...
2013-09-09
926 reads
Monday morning and it’s time for weekly round-up. This edition makes number #48. As a change to this week’s post,...
2013-09-09
1,118 reads
Yeah, Azure.
How we program, what we program and where we program is changing. All the time. This excellent article lays...
2013-09-09
1,283 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