Data Channel - Interview 01 - Andreas Wolter on Columnstore
Dear all,
Welcome to the first ever interview of DataChannel. I am honored to have Mr.Andreas Wolter, a German MVP, MCM, MCSM...
2016-12-03
743 reads
Dear all,
Welcome to the first ever interview of DataChannel. I am honored to have Mr.Andreas Wolter, a German MVP, MCM, MCSM...
2016-12-03
743 reads
More dbatools experimentation for me. This is a great set of Powershell cmdlets that solve simple, handy problems. In this...
2016-12-02
1,043 reads
People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server...
2016-12-13 (first published: 2016-12-02)
5,440 reads
Another week almost over so here’s a random selection of articles that I’ve been reading…
Changing the SQL Server port on...
2016-12-02
382 reads
When you have many SQL databases that are required to run your environments and they show signs of specific usage...
2016-12-12 (first published: 2016-12-02)
1,451 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-12-01
765 reads
Azure Advisor is a really cool personalized recommendation engine that provides you with proactive best practices guidance on High Availability,...
2016-12-01
327 reads
Open any book or article about database development and administration, and I can all but guarantee that you will find...
2016-12-01
378 reads
In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs that execute periodically. Figure 1 shows such a situation....
2016-12-01
16 reads
In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs that execute periodically. Figure 1 shows such a situation....
2016-12-01
12 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