MeasureUp 2016
I’m heading down to Austin next weekend for MeasureUp 2016. This is a Microsoft stack conference that looks to help...
2016-07-16
562 reads
I’m heading down to Austin next weekend for MeasureUp 2016. This is a Microsoft stack conference that looks to help...
2016-07-16
562 reads
Make sure you have a working install of SQL Server 2016. The size of the database is only 8 MB.
USE...
2016-07-15
314 reads
I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 23th 2016! This will be my third SQLSaturday event this year and I’m really excited...
2016-07-15
16 reads
I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 23th 2016! This will be my...
2016-07-15
434 reads
I’ve been using Microsoft’s cloud database for some time now. I’ve had a few customers with various performance problems and...
2016-07-15
2,222 reads
One of the exciting new features you may want to explore in SQL Server 2016 is PolyBase. However, as I...
2016-07-15
1,465 reads
Introduction
Despite the traditional relational DB world, there’s also a trend for NoSQL. The NoSQL databases that enable storing unstructured and...
2016-07-15
4,661 reads
I’ve spent most of my career using VSS and TFS, mainly because that’s what was being used. Better any source...
2016-07-15
446 reads
Its been long but productive week at Tree Tech
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the...
2016-07-15
420 reads
We are happy to announce the birth of DataGinger. Starting today we officially re-branded ourselves as DataGinger.com (previously SQLServerZest.com). The...
2016-07-15
422 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