Session: Introduction to Powershell Cmdlets for DBAs
I’ve given my new Powershell Cmdlets for DBAs session a handful of times now, and just realized I haven’t blogged...
2014-10-28
888 reads
I’ve given my new Powershell Cmdlets for DBAs session a handful of times now, and just realized I haven’t blogged...
2014-10-28
888 reads
We released Minion Reindex by MidnightDBA unto the world, accompanied by a press release on SQLServerCentral.com, and people have responded so incredibly positively. We’re quite...
2014-10-27
718 reads
Edit: Minion Reindex has arrived, and it’s getting fantastic notes! The MidnightDBA team is announcing the release of a new,...
2014-10-20
1,142 reads
The first week of November, we’ll be at the PASS Summit inSeattle, WA. This is the highlight of most SQL Server speakers’...
2014-10-10
662 reads
Edit: I went and changed the first query without paying close enough attention. I’ve fixed the explanation and the query....
2014-10-08
850 reads
If I had a favorite kind of politician, it would be the kind that, when asked a question, sighs tiredly,...
2014-09-19
570 reads
I’ve seen this mistake more than once, from DBAs with a middling to fair amount of experience. So it bears repeating....
2014-09-08
935 reads
If you’re in Seattle the week of November 2 – say, for example, you’re attending the PASS Summit that week – consider...
2014-07-30
1,040 reads
This week in awesome: Denny Cherry – our own @mrdenny – has created a Password Vault WordPress plugin. That looks seriously cool....
2014-05-30
1,097 reads
Ever heard of orphaned users? It’s a database user account, disconnected from its associated login. You typically get this when...
2014-05-05
941 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