SQL Server 2016 SP 1
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,615 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,615 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,047 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
502 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,250 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
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that.
In SQL PowerShell, the same...
2017-01-06
551 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,...
Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal Sudirman...
Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec. Cilandak, Kota...
Comments posted to this topic are about the item Switching Schema II
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