Is Data Visualization still just a buzzword?
If asked this question two years ago, my answer would have been a resounding “Yes.” At that time, the focus...
2016-01-05
542 reads
If asked this question two years ago, my answer would have been a resounding “Yes.” At that time, the focus...
2016-01-05
542 reads
SQL Saturday NYC is going full steam ahead and we have finalized our 2 Precons for Friday May 29th. Before...
2015-02-21
270 reads
SQL Saturday NYC is going full steam ahead and we have finalized our 2 Precons for Friday May 29th. Before...
2015-02-21
783 reads
SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2...
2015-02-20
261 reads
SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2...
2015-01-09
477 reads
There are several really good blogs that already exists that explain the differences between Table Variable, Common Table Expressions (CTE)...
2015-01-05
320 reads
There are several really good blogs that already exists that explain the differences between Table Variable, Common Table Expressions (CTE)...
2015-01-05
1,180 reads
Just over 2 weeks now since SQL Saturday NYC went live and planning is in full force. An update on...
2014-12-10
326 reads
If you are going to use functions first you should understand how functions work as they are often over used...
2014-12-05
634 reads
It has been one week now since SQL Saturday NYC was announced and the planning committee and myself are very...
2014-12-03
380 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