Advent of Code–Day 2
I’ve continued working along, and while I found Day 2 to be straightforward in Python and PowerShell, I thought it...
2016-01-20
628 reads
I’ve continued working along, and while I found Day 2 to be straightforward in Python and PowerShell, I thought it...
2016-01-20
628 reads
Azure SQL Database is a relational database-as-a-service in the cloud. It uses a special version of Microsoft SQL Server as...
2016-01-20
985 reads
… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server: Logging, Recovery, and the Transaction...
2016-01-20
419 reads
tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter.
While at the...
2016-01-20
10,712 reads
Earlier this week I wrote about the basics of change tracking in SQL Server, and showed how to get started...
2016-01-28 (first published: 2016-01-20)
3,033 reads
I am very pleased to announce that I will be speaking about SQL Server Storage Structure, Level 100 session on...
2016-01-20
350 reads
Thanks to everybody that participated in this month’s T-SQL Tuesday. A big thanks to everyone who wrote a participating blog...
2016-01-20
677 reads
Let’s say you have a port conflict and need to change the port on your Availability Group endpoint. How can...
2016-01-19
1,750 reads
I recently came across Tim Ford’s (B|T) challenge to the technical blogging community. The challenge is to write one introductory...
2016-01-19
418 reads
There’s two fairly common questions I see on the forums around SQL Server’s memory usage. Either the question asks why...
2016-01-19
2,055 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
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