T-SQL Tuesday #74–The Changes
It’s T-SQL Tuesday time, the monthly blog party on the second Tuesday of the month. This is the first T-SQL...
2016-01-12
589 reads
It’s T-SQL Tuesday time, the monthly blog party on the second Tuesday of the month. This is the first T-SQL...
2016-01-12
589 reads
Welcome to my contribution for T-SQL Tuesday 74 being hosted by me. So special thanks to me for hosting it....
2016-01-12
750 reads
Happy New Year, and welcome back! One of the projects I undertook over the holidays was to give the site...
2016-01-12
293 reads
The Austin SQL Server User Group will host its third SQL Saturday on Saturday,
SQL Saturday Austin on January 30th, 2016
January...
2016-01-12
483 reads
Quick little post. I just wanted to share how happy I am with the new “THIS TOPIC APPLIES TO” infographic....
2016-01-12
449 reads
One new thing that SQL Server 2016 has added is the ability to natively compile user-defined functions. Previously, native compilation,...
2016-01-19 (first published: 2016-01-12)
4,296 reads
TSQL Tuesday #74: Be The Change
Each month, on the first Tuesday of the month, the announcement for the blog...
2016-01-18 (first published: 2016-01-12)
1,573 reads
This month T-SQL Tuesday is hosted by Robert Davis (blog/@SQLSoldier) and his topic of choice is “Be The Change”
(If you...
2016-01-12
512 reads
Read My Article "Here"
Ganapathi varmaSenior SQL Engineer, MCP
For more updates:
Subscribe for Blog posts [Click Here]
Follow FB Page [Click Here]
Follow FB Group [Click Here]
For...
2016-01-12
125 reads
It’s the second Tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know...
2016-01-20 (first published: 2016-01-12)
1,393 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