TDE Recovery
This week’s TSQL Tuesday is being held by the mighty Kenneth Fisher – Backup and Recovery- see this link, how can...
2016-12-26 (first published: 2016-12-07)
1,518 reads
This week’s TSQL Tuesday is being held by the mighty Kenneth Fisher – Backup and Recovery- see this link, how can...
2016-12-26 (first published: 2016-12-07)
1,518 reads
In this post, let’s learn how to use chgrp and chown commands to change group and user ownership of a...
2016-12-07
393 reads
I got a link recently from Microsoft on building apps easily for SQL Server. At the top of the page,...
2016-12-06
1,410 reads
For a long time clients would ask me how to determine the cost savings by migrating their applications and databases...
2016-12-06
1,285 reads
Colleague:
I think I just encountered my first Right join
*shocked* Me:
huh. weird.
a rare Right Join has appeared!Colleague:
catch it!Me:
You use ON. It's...
2016-12-22 (first published: 2016-12-06)
2,904 reads
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...
2016-12-06
559 reads
In this module you will learn how to use the Sankey Power BI Custom Visual. The Sankey is a type...
2016-12-06
977 reads
In-Memory OLTP (A.K.A. Hekaton) is a specialized, memory-optimized relational data management engine and native stored procedure compiler, integrated into SQL...
2016-12-06
707 reads
Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that are...
2016-12-06
479 reads
Wait stats is my go to thing, however I do get bored just querying it via a table so I...
2016-12-06
813 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