Query Tuning 101: Debugging a procedure
I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds...
2016-12-15 (first published: 2016-11-30)
4,413 reads
I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds...
2016-12-15 (first published: 2016-11-30)
4,413 reads
It’s hard to believe it’s been more than 10 years since we started the planning for the first event in...
2016-12-16 (first published: 2016-11-30)
1,173 reads
I recently wrote an article for SQL Server Central about using OUTPUT. In case you aren’t aware OUTPUT is a...
2016-11-30
725 reads
This post follows on from Part Two in which we created a custom docker image. We’ll now look at pushing...
2016-12-14 (first published: 2016-11-30)
2,041 reads
Just one month later after the 1.4.0 release of CISL, I am here again blogging about the new release 1.4.1...
2016-11-30
655 reads
Last week, I did a presentation titled "SQL Server 2016 SP1 – Rocking RELEASE!!!" to Singapore SQL User Group. The Presentation was...
2016-11-29
859 reads
One of the things that I struggle with is understanding whether a session at a conference like a SQL Saturday...
2016-11-29
779 reads
Microsoft has a new release for the Analytics Platform System (APS). This appliance update is called APS 2016 and has...
2016-11-29
531 reads
VMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine,...
2016-12-07 (first published: 2016-11-29)
3,371 reads
In this module you will learn how to use the Synoptic Panel Power BI Custom Visual. The Synoptic Panel is...
2016-12-06 (first published: 2016-11-29)
2,124 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