SQL Server 2014 - Cardinality Estimator - Part 1
It has been a while since I blogged. Just moved to few other mediums like speaking at user group and...
2016-04-03
716 reads
It has been a while since I blogged. Just moved to few other mediums like speaking at user group and...
2016-04-03
716 reads
<img alt=’’ class=’alignright size-full wp-image-1238 ‘src=’/img/2016/04/img_570152b22dc45.png’>
If you are a SQL Server professional and are interested in spending a day...
2016-04-03
78 reads
(DE)
Meine letzten Veröffentlichungen und Vorträge zu Reporting Services sind schon Jahre her. Kein Wunder, denn seit dem 2008 R2-Release...
2016-04-03
881 reads
Of all the fundamental concepts within SQL Server, nothing is potentially more basic and fundamental than the often overlooked Select statement.
Related Posts:
Changing Default Logs Directory - Back to Basics...
2016-04-02
31 reads
Prelude in SQL Minor
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to...
2016-04-02
727 reads
Announced on 3/31/2016 SQL Server Developer Edition is now free and available as a download to all who have signed...
2016-04-01
851 reads
Moving system databases in SQL Server takes a bit of practice. I got that again, along with a dose of...
2016-04-01
8,305 reads
Almost fives months ago I joined Microsoft as a Data Platform Solutions Architect. As a DPSA for Microsoft, I am...
2016-04-01
670 reads
I’ve playing around with AdventureWorks and managed to found some hidden code! Truly odd stuff. I’m so shocked I couldn’t...
2016-04-01
516 reads
THIS IS NOT AN APRIL FOOL POST!
Seriously.
My Speaker of the Month for April 2016 is Keith Tate (b|t) and his...
2016-04-01
502 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