The Side Project
When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and...
2017-01-11 (first published: 2017-01-04)
1,367 reads
When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and...
2017-01-11 (first published: 2017-01-04)
1,367 reads
In this blog post. Let us learn about how to retrieve date and time when the SQL Server was installed. To retrieve...
2017-01-04
13,982 reads
Wish you a Happy New Year to all the readers and technical enthusiasts!!!
https://blogs.technet.microsoft.com/wikininjas/2017/01/02/interview-with-a-sql-server-expert-and-wiki-ninja-prashanth-jayaram/
My interview is published on the Microsoft Technet blog...
2017-01-03
455 reads
It is easy to get caught up in the daily details of life and not take the time to reflect on longer term goals and accomplishments.
Inspired by Brent Ozar...
2017-01-03
24 reads
Launching #TAPtips Blog Posts While forming Datalere, Carlos and I wanted to continue with our contributions to the Denver, Colorado...
2017-01-03
206 reads
I was rehearsing a demo with someone recently and we had some stored procedure code that looked like this:
CREATE PROCEDURE...
2017-01-03
3,792 reads
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about that, there were months where I barely managed to...
2017-01-03
12 reads
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
175 reads
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
518 reads
I hope you run consistency checks on your databases, if you are not currently doing this you probably will want to....
2017-01-03
589 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,...
Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal Sudirman...
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
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