Advent of Code Day 1, Puzzle B
As I continue through the Advent of Code, albeit slowly, Iām solving each puzzle 3 days. I worked through 6...
2016-01-08
753 reads
As I continue through the Advent of Code, albeit slowly, Iām solving each puzzle 3 days. I worked through 6...
2016-01-08
753 reads
The TL;DR on this is simple:
"BECAUSE IT'S SUPPOSED TO!"
A frequent complaint we receive comes from a client that has an...
2016-01-14 (first published: 2016-01-08)
7,753 reads
Transaction Logging & Recovery (part 2)
⦠Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server:...
2016-01-08
447 reads
SQL server error log contain all information about how a SQL server is running, what is happening and occurring for...
2016-01-13 (first published: 2016-01-08)
22,443 reads
... Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server: Logging, Recovery, and the Transaction...
2016-01-08
327 reads
Altering an Extended Event session is not necessarily a difficult task, but it is a very useful ability. Having this basic skill in your wheelhouse can be very positive...
2016-01-08
26 reads
Ready for a change of pace? Good! Today is a really good time to start looking into one of the...
2016-01-13 (first published: 2016-01-08)
2,537 reads
In the final part of this 3 part series on what SSDT actually is I am going to talk about...
2016-01-07
890 reads
In the final part of this 3 part series on what SSDT actually is I am going to talk about the documented API. What I mean by documented is...
2016-01-07
10 reads
In the final part of this 3 part series on what SSDT actually is I am going to talk about...
2016-01-07
35 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