SQL Server Internals Presentation with PASS DC Chapter October 10, 2013
If you’re in the DC/Baltimore area, or just feel like coming to DC to learn about SQL Server, please join...
2013-09-24
529 reads
If you’re in the DC/Baltimore area, or just feel like coming to DC to learn about SQL Server, please join...
2013-09-24
529 reads
Recently I wrote about the myth that you can’t use an alias in an UPDATE statement. You can of course,...
2013-09-24
902 reads
Yesterday the slate of candidates for the PASS Board of Directors was announced. Seven candidates for three open positions this...
2013-09-24
853 reads
Wow! It’s been one year since I launched my blog, and my how things have changed.
Accomplishments Over the Past...
2013-09-24
740 reads
That’s the title of an article i came across this morning in Slate.com. I am not a big fan of...
2013-09-24
665 reads
Being a DBA is more than just knowing about SQL: it’s about the technology which SQL runs on, which includes servers and storage. I’m naturally interested in hardware, so...
2013-09-24
27 reads
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Over the next...
2013-09-23
788 reads
This post is to start the services of local or remote computers. It also check for all its dependent services....
2013-09-23
1,599 reads
Last month at VMworld, VMware announced the upcoming release of their virtualization suite, vSphere 5.5. As you all know, I...
2013-09-23
1,237 reads
It’s just a week until Dev Connections. This is one of the great conferences for the hybrid technology person, with...
2013-09-23
691 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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