SQLSaturday Baton Rouge at LSU on July 29
The big finale to our SQL Summer and the last of the three Gulf South 2017 SQLSat events, our 9th...
2017-07-19
445 reads
The big finale to our SQL Summer and the last of the three Gulf South 2017 SQLSat events, our 9th...
2017-07-19
445 reads
We’re weeks away from another SQL Cruise. If you’ve never heard of this before, follow the link to read more....
2017-08-01 (first published: 2017-07-19)
1,789 reads
Every now and again you need to know how big a table is. Or several tables. Or all of the...
2017-08-03 (first published: 2017-07-19)
1,853 reads
This puzzle was first proposed in 1848 by a composer of chess puzzles called Max Bezzel and has since spawned...
2017-08-04 (first published: 2017-07-19)
2,215 reads
Two years ago, we officially became MinionWare and launched the absolutely masterful SQL Server management solution, Minion Enterprise. For a...
2017-07-18
341 reads
I was reading Brent’s blog today and decided to make my own $250k dream car garage list. Mostly because I...
2017-07-18
266 reads
Watch this week's video on YouTube
Historically it's been difficult to accomplish certain tasks in SQL Server.
Probably the most annoying problem I had to do regularly before SQL Server 2012...
2017-07-18
39 reads
In this module you will learn how to use the Drilldown Player Custom Visual. The Drilldown Player acts like a...
2017-08-01 (first published: 2017-07-18)
1,729 reads
There’s no substitute for mentoring. We’ve heard it before, and in various ways, but I think we tend to largely...
2017-07-18
361 reads
And I’ve got it.
Glenn Berry posted a a link to the MSDN blog and almost immediately a note that the...
2017-08-04 (first published: 2017-07-18)
1,921 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