Implementing Fuzzy Sets in SQL Server, Part 3: Using Fuzzy Intersections as AND Statements
By Steve Bolton
…………Whenever we assign set membership grades to records on a continuous scale, we open up a whole new...
2016-09-06
630 reads
By Steve Bolton
…………Whenever we assign set membership grades to records on a continuous scale, we open up a whole new...
2016-09-06
630 reads
The last week of October, we’ll be at the PASS Summit in Seattle, WA. As some of you already know – and as I...
2016-09-06
519 reads
Like the alliteration in the title? I almost removed it, but decided it had a nice ring. Maybe that should...
2016-09-06
501 reads
Resolving an Error When Creating an Availability Group Listener.
In this post, I’m going to talk an issue that I found...
2016-09-06
269 reads
In this module you will learn how to use the Table Heatmap Power BI Custom Visual. The Table Heatmap has...
2016-09-13 (first published: 2016-09-06)
2,001 reads
I’m participating in two community activities this week. One is a #SQLCchat on Twitter and the other is a webinar...
2016-09-06
371 reads
I’m proud to be speaking at this year’s IT/Dev Connections conference in Las Vegas during the week of October 10th!...
2016-09-06
361 reads
I am endlessly fascinated by how the Query Store works. I love teaching it at every opportunity too. Plus, almost...
2016-09-12 (first published: 2016-09-06)
1,360 reads
I’m very excited to be presenting in the opening slot for this year’s 24 Hours of PASS – Summit Preview Edition...
2016-09-06
380 reads
UPDATE: The other half of this scenario has been posted. Check out Importing a BACPAC to SQL Server.
Azure SQL...
2016-09-09 (first published: 2016-09-06)
5,264 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