PASS Virtual Chapter Events : November 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-11-02
941 reads
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-11-02
941 reads
Windows Azure SQL Reporting was the new name of the reporting services component (which was formerly known as SQL Azure...
2013-11-01
6,490 reads
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-11-01
824 reads
I had a project to automate the import of a large number of excel files via SSIS into SQL 2012....
2013-11-08 (first published: 2013-11-01)
7,051 reads
This is a personal pet hate of mine.. Mixing HTML formatting tags directly with XML that aren’t escaped or contained...
2013-11-07 (first published: 2013-10-31)
3,989 reads
I got back from SQL Intersection on Wednesday afternoon. I did work a bit, but not too much after traveling...
2013-10-31
1,205 reads
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different forms, including a standing R2 cake one year for...
2013-10-31
15 reads
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different...
2013-10-31
1,286 reads
From Microsoft, SSDT is now available for SQL Server 2014:
We’d like to announce the availability of SSDT that supports SQL...
2013-10-31
1,587 reads
Hello Dear Reader! Today is Halloween, October 31st. My Daughter turns a big 15 today! Happy Birthday Ches!!!!!
To celebrate two...
2013-10-31
1,390 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