To the page and back again
To the page
It’s not one of those things you have to do frequently but every now and again you need...
2016-01-18
553 reads
To the page
It’s not one of those things you have to do frequently but every now and again you need...
2016-01-18
553 reads
Change tracking for SQL Server is a flexible and easy-to-use technology for monitoring tables for inserts, updates, and deletes. In...
2016-01-18
1,095 reads
I will be speaking with other SQL Server experts for SQLSaturday #461 in Austin on Jan 30th, 2016. This is...
2016-01-18
477 reads
I’m happy, honoured and humbled to be able to say that I will be presenting pre-cons and both SQL Saturday...
2016-01-17
417 reads
Operating System Error Message
Error: 18210, Severity: 16, State:1
BackupMedium::ReportIoError: write failure on backup device ‘VDI_ DeviceID ‘. Operating system error 995...
2016-01-16
14,954 reads
It was a few years back that my wife and I planned a trip to the Austin City Lights music...
2016-01-15
642 reads
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for our purposes. Such one, for example, is the function...
2016-01-15
22 reads
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for our purposes. Such one, for example, is the function...
2016-01-15
16 reads
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for...
2016-01-15
122 reads
SQL Server has plenty of built-in functions but sometimes we just have to combine some of them to create functions for...
2016-01-15
88 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