SQL Server Desired Enhancements
SQL Server 2016 has come with a ton of cool features, bells, whistles and well cool stuff (yes redundant). That aside, what are some of the really cool features...
2016-07-13
11 reads
SQL Server 2016 has come with a ton of cool features, bells, whistles and well cool stuff (yes redundant). That aside, what are some of the really cool features...
2016-07-13
11 reads
Happy Belated Birthday
The monthly Data Professionals blog party has come and gone. It happens the second Tuesday of every month...
2016-07-13
528 reads
This is the 2nd post in the series named SQL Server and Continuous Integration. The previous post explained the problems I...
2016-07-13
941 reads
Next Tuesday is the next installment of our DLM series from Redgate. I’m off the hook, with Grant and Arneh...
2016-07-13
582 reads
The Azure SQL Data Warehouse (SQL DW), that I blogged about here, is now generally available. Here is the official...
2016-07-13
603 reads
I heard the news this week, and I’m still sad. Karla Landrum is leaving PASS after five years of acting...
2016-07-13
506 reads
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the LEC in London. Following on from last weeks...
2016-07-13
390 reads
Hi friends, in this blog post I will tell you how we can retrieve the SQL plan from the cache....
2016-07-13
668 reads
Well I finally accomplished a goal of mine– that being to complete the training for SQL Server Performance Tuning and...
2016-07-12
198 reads
It’s time for another round of the global blog party we call T-SQL Tuesday. This is T-SQL Tuesday #80 and...
2016-07-12
781 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...
Telp/Wa 628217555651 Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Telp/Wa 62817825533 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
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