Mastering Index – Introduction
One of the most interesting and talked about topic in database field is Index. I am writing this Series of...
2016-09-29
872 reads
One of the most interesting and talked about topic in database field is Index. I am writing this Series of...
2016-09-29
872 reads
I have been eager to write this blog post for a while now. I want to share my experience of...
2016-09-29
887 reads
It’s always been my dream to speak at SQL PASS Summit. It’s a tough egg to crack. In my experience...
2016-09-29
786 reads
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-09-28
1,255 reads
Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is...
2016-09-28
1,792 reads
PASS is our community.
It may sound a little cliche in this time of election propaganda in the US, but it’s...
2016-09-28
732 reads
Social Media and Analytics is always an interesting combination. Twitter has an API that you can so you can connect...
2016-09-28
1,174 reads
Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you!
Following on from...
2016-10-13 (first published: 2016-09-28)
4,144 reads
UPDATE 2016-10-27: the preview is available as a VM in the Azure Marketplace. More information can be found on the...
2016-10-12 (first published: 2016-09-28)
3,888 reads
If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know...
2016-09-28
552 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