What is the Lambda Architecture?
Lambda architecture is a data-processing architecture designed to handle massive quantities of data (i.e. “Big Data”) by using both batch-processing and...
2016-08-08 (first published: 2016-08-05)
3,261 reads
Lambda architecture is a data-processing architecture designed to handle massive quantities of data (i.e. “Big Data”) by using both batch-processing and...
2016-08-08 (first published: 2016-08-05)
3,261 reads
I’m going to be speaking this fall at Visual Studio Live, Washington D.C. edition on Oct 3-6. This is my...
2016-08-05
463 reads
2016-08-05
199 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-08-09 (first published: 2016-08-04)
2,098 reads
On July 25th Microsoft released the first cumulative update (#1) for SQL Server 2016. This is a good reason to...
2016-08-04
342 reads
AdvertisementsMove database without breaking alwaysON
This post is going to show the database movement from one drive to another drive, without...
2016-08-08 (first published: 2016-08-03)
15,919 reads
I’m truly stunned at the responses I received to my post asking how far people have traveled for a SQL...
2016-08-12 (first published: 2016-08-03)
1,428 reads
A DBA walked into a bar, saw a couple of tables, and asked “Can I JOIN you?”
There are several different...
2016-08-03
1,302 reads
Overview
SQL Server is the most popular relational database management system, which is used by many organizations to maintain their data....
2016-08-03
1,560 reads
One of the server settings that I always enable when configuring a new instance of SQL is database instant file...
2016-08-03
472 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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