Monday Coffee 2017-01-09
I’m almost back into the swing of things now after the Xmas break, that holiday feeling has just about left...
2017-01-09
402 reads
I’m almost back into the swing of things now after the Xmas break, that holiday feeling has just about left...
2017-01-09
402 reads
By David Postlethwaite
SQL Server 2016 SP1 was released in November 2016 only five months after the initial release.
There have been...
2017-01-18 (first published: 2017-01-09)
2,616 reads
For many years the PASS Summit program committee has enforced a bright line rule – no sponsor content in the educational...
2017-01-09
501 reads
DMV : sys.dm_os_volume_stats
Being a SQL Server database administrator, you may often receive alerts or asked by Senior DBAs to check, if...
2017-01-09
18,049 reads
For years I’ve hosted WordPress somewhere, most recently in Azure using Project Nami so that I could store all the...
2017-01-08
402 reads
Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In this blog post I am continuing...
2017-01-07
503 reads
When designing Availability Group systems one of the first pieces of information I ask clients for is how much transaction log their databases generate. *Roughly*, this is going to...
2017-01-06
17 reads
When designing Availability Group systems one of the first pieces of information I ask clients for is how much transaction...
2017-01-17 (first published: 2017-01-06)
3,251 reads
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that. In SQL PowerShell, the same situation can arise where the SQL Server PowerShell...
2017-01-06
21 reads
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that. In SQL PowerShell, the same situation can arise where the SQL Server PowerShell...
2017-01-06
20 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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