11 years of PASS Summit
This is a story of my 11-year association with PASS, and the many ways it helped me grow as a...
2016-09-23
455 reads
This is a story of my 11-year association with PASS, and the many ways it helped me grow as a...
2016-09-23
455 reads
With just 1 week until SQLSaturday Portugal Porto 2016, I am glad to share that we have SQLSaturday Lisbon 2017...
2016-09-23
473 reads
Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out...
2016-09-23
510 reads
I've been gone... wow. Since March 31st of this year?! Let's fix that.
So what has been holding me back?
Kids? I...
2016-09-23
384 reads
Its been another Learning Tree week for me this week and a very interesting one at that. I'm on the...
2016-09-23
528 reads
Mastering Index - Filtered Index
This article is the part of series Mastering Index, in this particular article we will be exploring Filtered Index. Take...
2016-09-23
629 reads
Last week, we faced a basic and yet the only major problem that sql developers/admin had to deal with and...
2016-10-07 (first published: 2016-09-23)
4,347 reads
I was riding the elevator up from lunch today, at work. I am relatively new at my job and do...
2016-09-23
519 reads
I wrote about Azure SQL Database for T-SQL Tuesday #82, but I had a few mistakes in my process, at...
2016-09-22
594 reads
You’ve got your team; now you need to find a somewhere to host your event. If you are lucky, you...
2016-09-22
428 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