Joining Fortified Data
Nearly two years ago, I began a new phase in my career when I stepped into the world of consulting. ...
2016-09-08
475 reads
Nearly two years ago, I began a new phase in my career when I stepped into the world of consulting. ...
2016-09-08
475 reads
One thing I try to do in my role with Microsoft is to get clients to think of possible use...
2016-09-08
522 reads
As some of you know, here at gethynellis.com we have partnered with Learning Tree to offer you a range of courses...
2016-09-08
441 reads
Up until SQL Server 2016, we had to write our own functions to split a CSV string into a table...
2016-09-15 (first published: 2016-09-08)
2,751 reads
One of the benefits of having an MSDN Subscription is that you have free access to some Pluralsight courses.
To verify this,...
2016-09-08
590 reads
Being in a shop that utilizes Plan Explorer it was awesome to hear of the news release from SQL Sentry...
2016-09-08
435 reads
I’m happy to announce that I’m speaking at this year’s IT/Dev Connections conference held at the ARIA Resort in Las Vegas...
2016-09-08
360 reads
This is nothing new but it’s still a fun idea.
The problem:
The vendor app we just purchased (and are told we...
2016-09-08
502 reads
Are you going to SQL Saturday Denmark, which is running on Saturday 17th September? If you are David Postlethwaite or @postledm...
2016-09-08
436 reads
Special
Table Types
Objective of this post is to provide a list of special
tables available in Sql Server and brief description of...
2016-09-08
216 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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