Veterans Day – Thank You for Your Service
If you currently serve or have served in our military, thank you for your service. Please never doubt that your...
2015-11-11
431 reads
If you currently serve or have served in our military, thank you for your service. Please never doubt that your...
2015-11-11
431 reads
Today I had on my list to finish watching the presentation Gail Shaw did at Summit 2014, one of the...
2015-11-11
460 reads
Good news!
Red-Gate published new version of its SIPF framework with support of SSMS 2016!
Now you can simply download and install...
2015-11-11
572 reads
If you need to move data from one table into a new table, or even tables in a database into another database, the Import/Export Wizard in SQL Server Management...
2015-11-11
24 reads
Using AzCopy in a SQL Job to Upload Files to Azure Blob Storage
NOVEMBER 11, 2015
IntroductionIn my next series of posts, I am going to look into processing files in...
2015-11-10
183 reads
Using AzCopy in a SQL Job to Upload Files to Azure Blob StorageNOVEMBER 11, 2015
Introduction
In my next series of posts,...
2015-11-16 (first published: 2015-11-10)
7,322 reads
Here’s an excerpt from an email from PASS I received on November 4 and also available at this link (bolding added by...
2015-11-10
488 reads
This month Mickey Stuewe hosts the T-SQL Tuesday and she has a great topic. Data Modeling is something few people...
2015-11-10
1,033 reads
T-SQL Tuesday is here again. I’ve had good intentions the past few times this event has come around and even...
2015-11-13 (first published: 2015-11-10)
1,982 reads
I was renewed for another year as a SQL Server – now Data Platform – MVP, always pleasant news. My plan for...
2015-11-10
704 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