When should I use a CTE?
If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d...
2016-08-27
783 reads
If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d...
2016-08-27
783 reads
Overview
There are multiple numbers states of a SQL Database. These states determine the current status or mode of database in...
2016-08-27
559 reads
To kick off this series, I thought it would be worthwhile to discuss why it is I step up to...
2016-08-26
449 reads
Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events...
2016-08-26
507 reads
The SQL Server news this week is there is no news!
http://news.bbc.co.uk/1/shared/spl/hi/newswatch/history/noflash/html/1930s.stm
No this is not the 1930’s BBC.
There are no...
2016-08-26
351 reads
This will be my second time speaking at SQL Saturday in Dallas. My first was last year and it was...
2016-08-25
445 reads
Time for another update.
The minutes for the June in-person meeting have been approved and are now ready for your information....
2016-09-07 (first published: 2016-08-25)
1,139 reads
I’m off to the Viking Ship Museum for SQL Saturday #532. Actually, the Viking Museum will (hopefully) be a side...
2016-08-25
3,769 reads
I was having a conversation with someone over a disgusting vanilla latte and we talked about shutting down a machine...
2016-08-25
197 reads
I am very honoured to share that I have been picked up to speak at the German SQLSaturday in Munich...
2016-08-25
493 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. 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...
Comments posted to this topic are about the item Switching Schema II
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