SQL server on Linux
Microsoft accounted yesterday that SQL server will plan run in Linux, with early private preview available today along with full...
2016-03-09
2,271 reads
Microsoft accounted yesterday that SQL server will plan run in Linux, with early private preview available today along with full...
2016-03-09
2,271 reads
You might have seen error message like this from a SQL job that pulls data from an OLAP cube using...
2016-03-14 (first published: 2016-03-08)
2,266 reads
Looks outside: pigs are flying!
In an announcement yesterday, SQL Server will be made available on Linux. The private preview of...
2016-03-08
914 reads
I got a copy of some backup files recently and needed to restore them. However, I don’t have SQL Backup...
2016-03-08
1,379 reads
Well yesterday was a big day in the SQL Community, Microsoft announced that they will be developing a version of SQL Server for Linux. Check out the announcement here.
Image...
2016-03-08
11 reads
Well yesterday was a big day in the SQL Community, Microsoft announced that they will be developing a version of...
2016-03-08
1,770 reads
Yes, you read that right. SQL Server will be ported to Linux. Here’s the Blog post from Scott Guthrie.
http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/
Today I’m...
2016-03-08
500 reads
It’s T-SQL Tuesday time again (Number 76!) and this month we are hosted by Bob Pusateri (b/t) who has invited...
2016-03-08
1,170 reads
Yesterday Microsoft made the earth shattering news that a version of SQL Server with the “core relational database capabilities” will be...
2016-03-08
427 reads
A few weeks ago I met a couple of my business partners in a moderately upscale restaurant in the Washington,...
2016-03-08
397 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
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