Podcast with SQL Data Partners on Patching Best Practices
Recently, I joined Carlos L Chacon (site|@CarlosLChacon), Steve Stedman (blog|@SqlEmt), and the rest of the SQL Data Partners Podcast team...
2017-10-23
468 reads
Recently, I joined Carlos L Chacon (site|@CarlosLChacon), Steve Stedman (blog|@SqlEmt), and the rest of the SQL Data Partners Podcast team...
2017-10-23
468 reads
I will be doing a live webcast on Thursday, November 9th 2017 at 3 PM Eastern Time (8 PM UTC...
2017-10-23
476 reads
If a disaster struck tomorrow, are you ready for it? Are you sure you thought of everything? I cannot count...
2017-09-04
532 reads
A few years ago, I did a blog post series dedicated to disaster recovery (backups, restores, corruption, etc). 31 blog...
2017-08-18
492 reads
If you’ve been living under a rock, you may not have noticed how frequently SSMS is getting updated. The SQL...
2017-08-14
521 reads
It’s T-SQL Tuesday again, and this month’s host is Kendra Little (blog|@), and the excellent topic selected by Kendra is...
2017-08-08
619 reads
Join me Friday, July 21, 2017 for a day of Real-life SQL Server Performance Troubleshooting as part of SQLSaturday Columbus...
2017-06-26
727 reads
It’s time for another iteration of the blog party known as T-SQL Tuesday. This month’s theme is Shipping Database Changes...
2017-05-09
804 reads
This topic has come up several times recently, so I feel the need to blog on it. As the person...
2017-05-05
1,162 reads
Thanks to everyone who attended my presentation for the 24 Hours of PASS event on May 3rd. This iteration of...
2017-05-04
747 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