Different types of ANSI standard joins
INNER JOIN (SIMPLE JOIN): This returns all rows for which there is at least one match in BOTH tables. This is...
2016-09-26
327 reads
INNER JOIN (SIMPLE JOIN): This returns all rows for which there is at least one match in BOTH tables. This is...
2016-09-26
327 reads
UNION merges the contents of two structurally-compatible tables into a single combined table. This return unique records from all the...
2016-09-26
196 reads
Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what...
2016-10-06 (first published: 2016-09-26)
1,882 reads
Everyone has goals or at least they should have goals. As a young professional out of college, I had plenty...
2016-09-26
586 reads
Over the weekend, I went to the local theater to watch Sully, the movie about the US Airways pilot who...
2016-10-05 (first published: 2016-09-26)
1,326 reads
As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve...
2016-09-26
613 reads
In our last blog on Hadoop Big Data we have discussed about Hadoop and its tools/utility to connect to HDFS. on...
2016-09-26
610 reads
This has bit a couple of clients recently, figured I'd put out a PSA.
Express editions of SQL Server Reporting Service,...
2016-10-04 (first published: 2016-09-25)
2,167 reads
If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and...
2016-10-04 (first published: 2016-09-24)
3,785 reads
This may feel very
simple to many developers and yes it is, but I saw this request somewhere in community
website.So thought...
2016-09-24
954 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