New Formatting in #SQLPrompt
I love SQL Prompt. This might be my favorite tool from Redgate Software and just when I thought it couldn’t...
2016-12-27
680 reads
I love SQL Prompt. This might be my favorite tool from Redgate Software and just when I thought it couldn’t...
2016-12-27
680 reads
I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery...
2016-12-26
476 reads
Most of you would know that using query store one can force query plans. Is there a need to check...
2016-12-26
1,906 reads
In the previous tutorial, we went through how to setup “External Network” to access the internet on Hyper-v client machine....
2016-12-25
2,942 reads
While creating database users, it is possible to encounter an invalid character error message. This article will help clarify the error message.
Related Posts:
Changing Default Logs Directory - Back...
2016-12-24
259 reads
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-24
1,929 reads
Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments....
2016-12-23
15 reads
Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments....
2016-12-23
18 reads
Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and...
2016-12-23
284 reads
For a little pre-holiday fun, I’ve got a simple scenario to present to you, and I am interested in your...
2016-12-23
386 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