T-SQL Tuesday 73 – Naughty or Nice?
Thank you to SQLBalls ( b | t ) for hosting this month’s #tsql2sday.
As you work with SQL Server look around you. Is...
2015-12-08
93 reads
Thank you to SQLBalls ( b | t ) for hosting this month’s #tsql2sday.
As you work with SQL Server look around you. Is...
2015-12-08
93 reads
T-SQL Tuesday is a monthly community-wide blogging event created by Adam Machanic (blog|@AdamMachanic), and everyone is invited to particpate. This...
2015-12-08
1,908 reads
You better watch out, you better not cry, gonna find out who's naught and nice - TSQL Tuesday #73 is coming...
2015-12-08
2,385 reads
Data compression is often misunderstood to cost CPU in exchange for smaller size on disk. Somewhat true, but that simple...
2015-12-08
1,183 reads
It’s the Christmas season! And it’s T-SQL Tuesday! And Bradley Ball (b/t), SQL’s very own superhero (one of many really...
2015-12-08
536 reads
This month T-SQL Tuesday is hosted by Bradley Balls (blog/@SQLBalls) and his topic of choice is “Naughty or Nice.”
(If you...
2015-12-14 (first published: 2015-12-08)
2,882 reads
Hi friends, With new CTP version of SQL Server 2016 many new functionality are added and modified. As with introduction...
2015-12-08
592 reads
Want to get out of the winter blues and into some warmer weather for some deep SQL Server training? Join...
2015-12-07
695 reads
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-12-07
451 reads
I’ve started a new project. Actually, I started this well over a year ago, but I lost track of it...
2015-12-11 (first published: 2015-12-07)
1,890 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