Using Virtual Desktops for Presentations
Today I was reading William Durkin‘s fine post on Presentation Mode in SSMS vNext when inspiration struck.
One of the things that...
2017-03-13
527 reads
Today I was reading William Durkin‘s fine post on Presentation Mode in SSMS vNext when inspiration struck.
One of the things that...
2017-03-13
527 reads
I’ve written several times about the Cost Threshold for Parallelism and it’s relationship to your execution plans, how to determine...
2017-03-23 (first published: 2017-03-13)
3,159 reads
One of the problems with whitepapers is that they get out of date pretty quickly. It’s important to update them...
2017-03-13
552 reads
Are you a software developer?
Did you ever get to develop a software that works with a Microsoft SQL Server database?
...
2017-03-13
816 reads
Query Store was, probably without doubt, the most anticipated and talked out new feature in SQL 2016. Certainly by the...
2017-03-29 (first published: 2017-03-13)
6,401 reads
The 11th cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Downloads site. Please...
2017-03-13
510 reads
In my last post I showed how to add a T-SQL Job step to an existing SQL Agent Job. The...
2017-03-13
1,156 reads
Less than a week to go until SQLSaturday Iceland now, it’s going to be a busy couple of months for...
2017-03-13
270 reads
This month’s TSQL Tuesday is organized by Kennie T Pontoppidan(t) – the topic is ‘Daily Database WTF‘ – or a horror story...
2017-03-12
462 reads
Just a quick post, as much as a reminder for me as anything, but also useful to those that attended...
2017-03-17 (first published: 2017-03-12)
2,707 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