PowerShell Usage In DBA Work — Case Study 1 / 7
I have been blogged non-technical topics for too long and it is time for me to return to my favourite...
2013-03-06
984 reads
I have been blogged non-technical topics for too long and it is time for me to return to my favourite...
2013-03-06
984 reads
When I started playing with GeoFlow, I just had to find a way to do something interesting with it. This...
2013-03-06
710 reads
I saw it in the Connector, but just had time to read the minutes to see what was behind the...
2013-03-06
867 reads
I was reading about the American Association of Woodturners annual symposium that will be held in Tampa this year (and...
2013-03-05
645 reads
I received my long-awaited Microsoft Surface Pro 128GB yesterday! The first thing I did was to promptly install SQL Server...
2013-03-05
4,484 reads
Data Explorer (download), which I first mentioned in my blog about PASS Summit 2011 (SQL Server 2012 and other PASS...
2013-03-05
2,009 reads
Hello and welcome to the third T-SQL Tuesday of 2013!
Over three years ago, Adam Machanic (Twitter) dreamed up the idea...
2013-03-05
662 reads
Recently while changing some production security around on a new server I needed to modify the SQL Server Analysis Services...
2013-03-05
1,258 reads
Just for the record, this happens to be one of my favorite interview questions to ask candidates.
At some point in...
2013-03-05
2,364 reads
With a case ordered and a CPU in mind I decided to focus on the power supply next. Remember that...
2013-03-05
661 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