Adding Identity to an existing column
A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He...
2017-06-19
3,077 reads
A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He...
2017-06-19
3,077 reads
A couple of weeks back I blogged about my progress in the “Microsoft Professional Program in Data Science” curriculum. I’ve...
2017-06-27 (first published: 2017-06-19)
2,864 reads
In this post we will explore a common statistical term – Relative Risk, otherwise called Risk Factor. Relative Risk is a...
2017-06-21 (first published: 2017-06-19)
1,978 reads
Last weekend was SQL Saturday Dublin, and it was a good one.
My session on An introduction to SQL Server & Containers...
2017-06-19
322 reads
SQL Server 2017 is the first version of SQL Server that will also run natively on Linux and on macOS...
2017-06-19
56 reads
Well, it is almost that time of the year again. Elections for the PASS Board.
This is a great way to...
2017-06-19
516 reads
Great to see all of you at #SQLSatHouston today, an awesome event put on by a great crew of volunteers....
2017-06-17
308 reads
Been looking forward to this weekend for a while now as it’s SQLSaturday Dublin tomorrow. I did a lightening talk...
2017-06-16
339 reads
With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to...
2017-06-16
3,101 reads
The theme of day 2 of the Microsoft Data Insights Summit was sessions, sessions, sessions! There were a ton of...
2017-06-15
253 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