Run Book, Run!!!
How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains...
2016-12-21
1,276 reads
How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains...
2016-12-21
1,276 reads
I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I...
2016-12-21
1,985 reads
Problem
I was contacted by a user asking if it was possible for his team to be able to execute specific...
2016-12-21
2,671 reads
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation for them. Licensing is given at the end of...
2016-12-20
42 reads
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation for them. Licensing is given at the end of...
2016-12-20
24 reads
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation...
2016-12-20
297 reads
By Steve Bolton
…………I’ve written several amateur tutorial series on this blog in order to more quickly absorb difficult data mining,...
2016-12-30 (first published: 2016-12-20)
2,251 reads
It’s amazing just how much the landscape changed with the release of SQL Server 2016 SP1. For example, I just...
2016-12-20
476 reads
Change is not always easy. In fact, change is hard.
“Change” is a word from which some people shy away, and...
2016-12-20
351 reads
Microsoft has finally implement support for JSON data in SQL Server 2016 and in Azure SQL Database. In a previous...
2016-12-20
3,653 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,...
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
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