Seattle SQL Pro Workshop 2016
Seattle SQL Pro Workshop 2016
You may be aware of an event that some friends and I are putting together during...
2016-10-24
559 reads
Seattle SQL Pro Workshop 2016
You may be aware of an event that some friends and I are putting together during...
2016-10-24
559 reads
Introduction to Query Store covered here.
Now for the second part on “How to Configure?”
Query Store is configured at the...
2016-10-24
990 reads
In preparation of my upcoming webinar on the new features of Master Data Services 2016, I installed MDS on my...
2016-10-23
2,339 reads
In the series of SQL SERVER 2016, this is a new post. in this post, we will discuss DATEDIFF_BIG and...
2016-10-22
875 reads
Continuation from the previous 87 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Getting Data into the Database is one...
2016-10-22
597 reads
Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax.If...
2016-10-22
246 reads
Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax....
2016-10-22
1,256 reads
In the Series of SQL SERVER 2016, this is another post. Before Jumping in detail just think if you have...
2016-10-22
971 reads
This past week I had the pleasure of attending our first VMworld Europe conference, held this week at the Fira Gran Via in...
2016-10-21
733 reads
Next Monday night is the networking dinner that Andy Warren and I have put together for the last 6 years....
2016-10-21
502 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