SQL Server 2016 SP1 is Now Available
In the Business Intelligence and reporting space, SQL Server 2016 was a big step forward. Aside from significant relational engine...
2016-11-16
457 reads
In the Business Intelligence and reporting space, SQL Server 2016 was a big step forward. Aside from significant relational engine...
2016-11-16
457 reads
SQL Server 2016 SP1 entfernt Programmier-Feature-Limits der Editionen! Alles von Always Encrypted bis XTP: In-Memory für Alle!
Unglaubliche Neuigkeiten, anders kann man es gar nicht sagen:
Mit dem heute erschienenen Service...
2016-11-16
27 reads
SQL Server 2016 SP1 entfernt Programmier-Feature-Limits der Editionen! Alles von Always Encrypted bis XTP: In-Memory für Alle!
Unglaubliche Neuigkeiten, anders kann...
2016-11-16
778 reads
Earlier today, Microsoft announced the release of Service Pack 1 (SP1) for SQL Server 2016. Pay close attention to this...
2016-11-16
484 reads
Most of the DBCC commands return their results as textual output, even if you have SSMS configured to return result...
2016-11-16
471 reads
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-11-16
519 reads
With the release of the most epic Service Pack 1 for SQL Server 2016, the biggest attention of everyone should...
2016-11-16
852 reads
This is the most important blog post about SQL Server that I have ever written. As far as I am...
2016-11-16
581 reads
One of the things I’ve been wanting to do is dig more into the command line automation cmdlets from the...
2016-11-16
689 reads
SQLSkills is an amazing resource for the SQL Server community. Between their blogs, white papers, and the SQLSkills Insider emails...
2016-11-16
691 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