Future DBA – Hadoop Big Data
As we discussed on earlier blog that in future its more than SQL-(R)DBMS, as data is growing we have to...
2016-09-21
436 reads
As we discussed on earlier blog that in future its more than SQL-(R)DBMS, as data is growing we have to...
2016-09-21
436 reads
A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following:
Negative...
2016-10-03 (first published: 2016-09-21)
2,080 reads
In this post am going to attempt to explore a statistical procedure called ‘One Sample T Test’.
A T-Test is used...
2016-09-30 (first published: 2016-09-21)
1,958 reads
This article is for those who have no idea about Sql and I will be giving them a start point...
2016-09-21
456 reads
Didn't see SQL 2016 Configuration manager in the start menu. Ran a quick search to see if this was a...
2016-09-21
109 reads
For this blog post I want to show you the steps required to setup an Azure SQL Data warehouse and...
2016-09-21
527 reads
Didn't see SQL 2016 Configuration manager in the start menu. Ran a quick search to see if this was a...
2016-09-30 (first published: 2016-09-21)
1,956 reads
(EN)
After my Asia-tour this summer I feel it is about time for this article. At the time of this article (09-2016) I have presented at more than 50 technical...
2016-09-20
26 reads
(EN)
After my Asia-tour this summer I feel it is about time for this article.
At the time of this article...
2016-09-20
676 reads
Three men are in a hot-air balloon. Soon, they find themselves lost in a canyon somewhere. One of the three...
2016-09-20
425 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