SQL Server on Linux Authentication
Yesterday Microsoft announced that they will now support SQL Server on Linux. They are targeting mid-2017, but you can download...
2016-03-11
2,390 reads
Yesterday Microsoft announced that they will now support SQL Server on Linux. They are targeting mid-2017, but you can download...
2016-03-11
2,390 reads
Three days of presentations in Richmond Virginia. From Naked SQL to Wheel of Doom - there is a wide breadth of knowledge to be shared.
Related Posts:
An Experiment with Deadlocks...
2016-03-11
8 reads
Long Time Coming
With less than a week before the Richmond SQLSaturday event, I am finally getting this post done – maybe.
This...
2016-03-11
523 reads
On occassion, I need to take a number of different result sets and combine them into a single output, which I then want to store in a temporary table....
2016-03-11
13 reads
On occassion, I need to take a number of different result sets and combine them into a single output, which...
2016-03-11
448 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-03-11
698 reads
I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted...
2016-03-11
352 reads
I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted...
2016-03-11
5,137 reads
How many of you are known as the “Grumpy DBA” or have a bad reputation with users because you are...
2016-03-11
282 reads
By now, all you folks who logged on to watch the ultimate Microsoft Data Driven event, streamed live from New...
2016-03-11
1,289 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