Log Files from Different Sources
While working with Extended Events, or with any sort of logging or tracing utility, it becomes critical to consume the data from disparate sources or even to consume the...
2015-12-30
20 reads
While working with Extended Events, or with any sort of logging or tracing utility, it becomes critical to consume the data from disparate sources or even to consume the...
2015-12-30
20 reads
Well, it has been quite a pause between articles in the series. It is well past time to continue the...
2016-01-05 (first published: 2015-12-30)
1,836 reads
Few days ago (28/12) I delivered a full-day seminar about Hadoop Fundamentals. It was part of the Expert Days 2015...
2015-12-30
953 reads
You sometimes want to do things like split a table into two or move a column into another table and...
2015-12-30
1,225 reads
You sometimes want to do things like split a table into two or move a column into another table and when you use SSDT or the compare / merge...
2015-12-30
17 reads
You sometimes want to do things like split a table into two or move a column into another table and...
2015-12-30
220 reads
You sometimes want to do things like split a table into two or move a column into another table and...
2015-12-30
213 reads
What I’ve noticed this year is that there’s really not another group of people like the SQL Community. Earlier this year Paul Randal ( b | t ), in...
2015-12-29
15 reads
What I’ve noticed this year is that there’s really not another group of people like the SQL Community. Earlier this...
2015-12-29
897 reads
Maybe you’re new to SQL Server or maybe you’re just expanding into performance tuning a little more. Query tuning can...
2015-12-29
1,833 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