Machine Learning – What is It Good For?
Machine Learning is a very powerful technology used in the field of predictive analytics. As far as I see it,...
2016-10-20
433 reads
Machine Learning is a very powerful technology used in the field of predictive analytics. As far as I see it,...
2016-10-20
433 reads
Long ago there were locking / blocking problems with the SELECT INTO statement. That’s not the case anymore and for AdHoc...
2016-10-20
1,058 reads
Question: Who owns your availability groups?
The person who creates the AG becomes the owner by default. Did you know that...
2016-10-20
307 reads
About 8 months ago I wrote an article (http://www.sqlservercentral.com/articles/SQL+Server/139998/ ) where I showed you how to migrate your “earth” SQL Database...
2016-10-20
480 reads
I saw this tweet from the always awesome @DBArgenis and @sqldbawithbeard and couldn't help but feel a bead of sweat...
2016-10-20
146 reads
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-10-19
741 reads
Microsoft Data Warehouse Fast Track for SQL Server 2016 is a joint effort between Microsoft and its hardware partners to...
2016-10-19
979 reads
I’ll be attending the 2016 Pass Summit as a part of the Redgate Software crew. I’m not speaking this year,...
2016-10-19
467 reads
Recently I gave an introductory webinar on how to build an auditing framework for SQL Server. The focus was for...
2016-10-19
510 reads
For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says...
2016-10-19
1,415 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